Not the answer you need?
Register and ask your own question!

Backing up and restoring individual DBs in MySQL

RandomDBARandomDBA EntrantCurrent User Role Beginner
I've read the documentation for Percona XtraBackup and from what I've been able to gather at the links below, it looks like I cannot restore individual databases from a backup created using XtraBackup if I'm not using Percona server.

Currently we are running MySQL 5.5.15. The vast majority of our tables are INNODB, but we do have a handful of MYISAM and ARCHIVE tables.

Unfortunately the ability for us to restore a single database from backup is crucial for our system. I'm really excited XtraBackup and would like to test it in our environment, but the inability to restore individual databases is a deal breaker and convincing upper management to switch from MySQL to Percona Server is a pretty hard sell.

If I'm misunderstanding something, please let me know. If my understanding is correct, will there be a point in the future where this functionality will be available for MySQL server?

Comments

  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    You are correct. The basic requirements are:

    1. The source table may use InnoDB or XtraDB
    2. Both the source and target servers must have innodb_file_per_table enabled and the table to be exported must be in it's own .ibd file.
    3. The target server must be using Percona Server with XtraDB.
    4. The target server must have innodb_expand_import enabled.

    As for when / if this will change, I'll leave that up to someone from Percona.
  • RandomDBARandomDBA Entrant Current User Role Beginner
    Thank you very much for confirming!
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.