MySQL Forums
Forum List  »  Backup

How can we ensure if mysql backups are consistent
Posted by: Mannoj Kumar
Date: September 05, 2012 02:50AM

How can we ensure if mysql backups are consistent when they are in full backups as well as in incremental backups using binlogs. According to me, I just take random count() tables after issuing flush logs on the database. And take binlogs generated until that flushed binary file and ensuring the table is not altered while doing select count() . And then restore the binary logs in different database server and cross check count(*) for the random tables are same or not against prod db and restored db. Any other thoughts other than this?? Keep in mind that hits from application to tables can be paused only for few mins.

Options: ReplyQuote


Subject
Views
Written By
Posted
How can we ensure if mysql backups are consistent
2120
September 05, 2012 02:50AM


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.