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
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