MySQL Forums :: Backup :: How can we ensure if mysql backups are consistent


Advanced Search

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 2069 Mannoj Kumar 09/05/2012 02:50AM
Re: How can we ensure if mysql backups are consistent 984 Ravi Thati 09/05/2012 03:35AM
Re: How can we ensure if mysql backups are consistent 838 Mannoj Kumar 09/05/2012 03:44AM
Re: How can we ensure if mysql backups are consistent 823 Ravi Thati 09/05/2012 08:48AM
Re: How can we ensure if mysql backups are consistent 869 Mannoj Kumar 09/05/2012 09:17AM
Re: How can we ensure if mysql backups are consistent 890 Ravi Thati 09/06/2012 03:48AM
Re: How can we ensure if mysql backups are consistent 1067 Rick James 09/08/2012 12:10PM


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.