Dumping a human-readable MySQL database

From Stack Overflow
Revision as of 18:12, 27 May 2008 by BrianEnigma (talk | contribs) (New page: The key is the "--skip-opt" flag. Otherwise, all of the insert statements are mashed together on one line and difficult to read and extract. mysqldump -uroot --skip-opt databasename)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

The key is the "--skip-opt" flag. Otherwise, all of the insert statements are mashed together on one line and difficult to read and extract.

mysqldump -uroot --skip-opt databasename