MySQL Forums
Forum List  »  Backup

Re: How can we ensure if mysql backups are consistent
Posted by: Ravi Thati
Date: September 06, 2012 03:48AM

Putting back the question:

Taking FULL using mysqldump of MYISAM tables involves locking tables for a consistent backup.

Taking BINARY LOG backups as INCR has no issues.


If you are looking for database verification methods:
what you are doing is correct. May you have look for writing a generic script (python) that takes original database name and restored database name that double checks the restored content via row count matching.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How can we ensure if mysql backups are consistent
1306
September 06, 2012 03:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.