From: Benjamin Stillman Date: November 7 2012 3:09pm Subject: RE: How to verify mysqldump files List-Archive: http://lists.mysql.com/mysql/228592 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable In the past when I used mysqldump, I used a slave database for backups and = periodically testing restores. My process for testing: - Stop the slave process (so the db doesn't get updated). - Run the backup. - Create restore_test database. - Restore the backup to the restore_test database. - Use mysqldbcompare to compare the two databases. - Drop restore_test database. - Start the slave process. I have this scripted so it just runs and emails me the results. Useful link: http://dev.mysql.com/doc/workbench//en/mysqldbcompare.html -----Original Message----- From: Gary [mailto:listgj-mysql@stripped] Sent: Wednesday, November 07, 2012 7:52 AM To: mysql@stripped Subject: How to verify mysqldump files Can anyone suggest how I could verify that the files created by mysqldump a= re "okay"? They are being created for backup purposes, and the last thing I= want to do is find out that the backups themselves are in some way corrupt= . I know I can check the output of the command itself, but what if.. I don't = know... if there are problems with the disc it writes to, or something like= that. Is there any way to check whether the output file is "valid" in the = sense that it is complete and syntactically correct? -- Gary Please do NOT send me 'courtesy' replies off-list. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql ________________________________ Notice: This communication may contain privileged and/or confidential infor= mation. If you are not the intended recipient, please notify the sender by = email, and immediately delete the message and any attachments without copyi= ng or disclosing them. LBI may, for any reason, intercept, access, use, and= disclose any information that is communicated by or through, or which is s= tored on, its networks, applications, services, and devices.