Dumping a large database can be a daunting task. With millions of records you worry something may be missed or a small mistake could cost you hours of time.
I've found the easiest way to dump a database(s) is to use a simple script. This script uses the mysqldump program with the option "tab". This option "tab" will split the each databases's table into two files.
The first file is a "sql" files and contains all the sql used to generate the table. The second table is a "txt" file which is tab delimited row data.
No comments:
Post a Comment