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

Does XtraBackup avoid the problems of invalid views stopping backups (mysqldump)

turagittechturagittech EntrantInactive User Role Beginner
Hi
I recently came across a problem with a database whereby the backup (mysqldump) was failing due to an invalid view. From what I can see and understand from the product documents, if I swapped all of our backups to XtraBackup, that this would no longer be an issue.
Currently on MySQL 5.1 but moving soon to 5.5, possibly MariaDB

Can anyone shed some light?

Cheers
Peter

Comments

  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    XtraBackup does a binary backup (file copy), so in theory the bad view should not cause any issue for it. The problem would just exist on whatever server you load the backup on however, so I would try and fix the root cause of the issue at some point still. =)
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.