From: Rick James
Date: November 7 2012 3:59pm
Subject: RE: How to verify mysqldump files
List-Archive: http://lists.mysql.com/mysql/228593
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB1490E7A7F7@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

A variant on that...
1. pre-validate slave's consistency using pt-table-checksum
2. dump slave, wipe clean, restore
3. RE-validate slave's consistency using pt-table-checksum

> -----Original Message-----
> From: Stillman, Benjamin [mailto:BStillman@stripped]
> Sent: Wednesday, November 07, 2012 7:09 AM
> To: 'Gary'; mysql@stripped
> Subject: RE: How to verify mysqldump files
>=20
> In the past when I used mysqldump, I used a slave database for backups an=
d
> periodically testing restores.
>=20
> 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.
>=20
> I have this scripted so it just runs and emails me the results.
>=20
> Useful link:
> http://dev.mysql.com/doc/workbench//en/mysqldbcompare.html
>=20
>=20
>=20
>=20
> -----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
>=20
> 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 thin=
g
> I want to do is find out that the backups themselves are in some way
> corrupt.
>=20
> 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 li=
ke
> that. Is there any way to check whether the output file is "valid" in the
> sense that it is complete and syntactically correct?
>=20
> --
> Gary        Please do NOT send me 'courtesy' replies off-list.
>=20
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>=20
>=20
> ________________________________
>=20
> 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.
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql