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.
Subject
Views
Written By
Posted
3451
September 05, 2012 02:50AM
1518
September 05, 2012 03:35AM
1322
September 05, 2012 03:44AM
1293
September 05, 2012 08:48AM
1364
September 05, 2012 09:17AM
Re: How can we ensure if mysql backups are consistent
1368
September 06, 2012 03:48AM
1602
September 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.