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?