List:General Discussion« Previous MessageNext Message »
From:Benjamin Stillman Date:November 7 2012 3:09pm
Subject:RE: How to verify mysqldump files
View as plain text  
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:

-----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 are "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:
To unsubscribe:


Notice: This communication may contain privileged and/or confidential information. If you
are not the intended recipient, please notify the sender by email, and immediately delete
the message and any attachments without copying or disclosing them. LBI may, for any
reason, intercept, access, use, and disclose any information that is communicated by or
through, or which is stored on, its networks, applications, services, and devices.
How to verify mysqldump filesGary7 Nov
  • Re: How to verify mysqldump filesClaudio Nanni7 Nov
    • Re: How to verify mysqldump filesAnanda Kumar7 Nov
      • Re: How to verify mysqldump filesManuel Arostegui7 Nov
  • RE: How to verify mysqldump filesBenjamin Stillman7 Nov
    • RE: How to verify mysqldump filesRick James7 Nov