Dan F wrote:
Thanks for your reply! Very helpful.
Presumably, I can read about SET FOREIGN_KEY_CHECKS = 0; and it will
only apply as long as the file is running, or I can turn it back on at
the end of the whole process.
Out of curiosity, are you saying mysqldump of a whole DB does some
sort
Thanks for your reply! Very helpful.
Presumably, I can read about SET FOREIGN_KEY_CHECKS = 0; and it will
only apply as long as the file is running, or I can turn it back on at
the end of the whole process.
Out of curiosity, are you saying mysqldump of a whole DB does some sort
of global lock
Folks,
I find it useful for browsing to dump each table of a DB, i.e.
psuedo-code like
foreach table
mysqldump --add-drop-table DB table table
This produces a file per table, and that file has the DDL and data.
My question: does this per-table version capture all the information
that doing
At 8:37 -0500 8/18/03, Dan F wrote:
Folks,
I find it useful for browsing to dump each table of a DB, i.e.
psuedo-code like
foreach table
mysqldump --add-drop-table DB table table
This produces a file per table, and that file has the DDL and data.
My question: does this per-table version