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

innobackupex/xtrabackup, Is it possible to restore a single database instead of all?

eclayeclay EntrantCurrent User Role Beginner
All,

I'm trying to find out how to restore a single database backed up by innobackupex/xtrabackup. I've been looking for an answer on this for a while and have only come across this option.

http://www.tekovic.com/mysql-hot-backup-with-xtrabackup-on-c entos

Near the bottom of the page it explains that to do this you have to restore the backup to a alternate mysql server and dump the db then restore it on the origin server. Is this really the only method for restoring a single database?
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.