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

Using innobackupex to restore a single database

BHensleyBHensley EntrantInactive User Role Beginner
Hi ,
We are currently hosting a 3-node Percona xtradb cluster environment in one of our client environments. We have configured for daily full backups using innobackupex and also running mysqldumps on the secondary. The main reason to have mysqldumps was with the intention if we need to restore just a single database.
I have done fair bit of research and found that with innobackupex we can only restore single table or all the databases from the hotbackup copies which innobackupex creates.

Please can you correct me if I am wrong here and also please suggest we could you innobackupex to do single database restores.



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.