Skip to main content
Solved

MySQL Backup using Percona XtraBackup


Forum|alt.badge.img+12

Hi Team,

 

We took a hot backup of our MySQL DBs with the Percona XtraBackup utility in the document below. We will perform restore tests, can we return any DB under MySQL Instance that we want to learn? Or is all Full Instance restore the only option?

 

https://documentation.commvault.com/2022e/expert/93111_mysql_backup_using_percona_xtrabackup.html

 

Best Regards.

Best answer by Sunil

Hi @ETO 

This is enough. You don’t need to select Full instance XtraBackup at subclient level if you want the ability to restore single database.

 

Thanks,

Sunil

View original
Did this answer your question?

3 replies

Sunil
Vaulter
Forum|alt.badge.img+13
  • Vaulter
  • 300 replies
  • April 6, 2023

If I understand correctly, you want to run restore of single database.

It depends on which mode of backup you run. If you run XtraBackup full instance backup, it’s only the entire instance that can be restored.

 

If you run with full instance backup, you will be able to restore at database level. We backup individual databases separately and the schema of the Database.

 

Thanks,

Sunil-


Forum|alt.badge.img+8
  • Byte
  • 29 replies
  • April 7, 2023

Hello  Sunil,

Yes, wewant to run restore of single database with XtraBackup if it is possible. is the following config enough for XtraBackup? There is an option on subcleint properties “Full instance Xtrabackup” do we have to choose it for Xtrabackup

 


Sunil
Vaulter
Forum|alt.badge.img+13
  • Vaulter
  • 300 replies
  • Answer
  • April 7, 2023

Hi @ETO 

This is enough. You don’t need to select Full instance XtraBackup at subclient level if you want the ability to restore single database.

 

Thanks,

Sunil


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings