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?