MySQL Forums
Forum List  »  Backup

Consistent tab delimited dump with mysqldump
Posted by: Biswajit Bardalai
Date: February 24, 2009 05:19PM


mysqldump --single-transaction --master-data=2 --tab=/tmp/mytabdump livedb

Will the above command provide a consistent dump that can be loaded onto a slave?

The data I'm concerned about are in InnoDB tables. I know --single-transaction provides a consistent dump when dumping into a sql file but does it do so when dumping into tab delimited files? I just want to make sure.

Our databases are about 60GB on the average and the dump into sql file takes way too long to restore. Due to a SAN issue, several of our slaves have become corrupt and shutting down the masters to copy raw files over is not an option.


Options: ReplyQuote

Written By
Consistent tab delimited dump with mysqldump
February 24, 2009 05:19PM

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.