The simplest test of the correctness of a backup is to run the backup process
%mysql_home%\bin\mysqldump" -uUSR -pPWD -A --add-drop-database -K -E -R >%1\mysqlbak.sql
(note: you need those flags for a complete backup), open the resulting dumpfile with a text editor like NotePad++ or TextPad to change database names to datbasenameBAK, save the result, run the dumpfile in the mysql client with ...
source C:\MySQLBackups\mysqlbak.sql
(note: NO terminating semicolon), then compare the databases and databaseBAKs with something like the script under "Compare two databases" at
http://www.artfulsoftware.com/queries.php.
Edited 1 time(s). Last edit at 04/19/2013 12:07PM by Peter Brawley.