Generating a set of files containing dumps of individual tables in a way that guarantees database co

Posted by intuited on Stack Overflow See other posts from Stack Overflow or by intuited
Published on 2010-05-04T03:08:10Z Indexed on 2010/05/04 3:18 UTC
Read the original article Hit count: 208

Filed under:
|
|
|

I'd like to dump a MySQL database in such a way that a file is created for the definition of each table, and another file is created for the data in each table. I'd like this to be done in a way that guarantees database integrity by locking the entire database for the duration of the dump. What is the best way to do this? Similarly, what's the best way to lock the database while restoring a set of these dump files?

edit

I can't assume that mysql will have permission to write to files.

© Stack Overflow or respective owner

Related posts about mysql

Related posts about mysqldump