Dumping a human-readable MySQL database

From Stack Overflow
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
Personal tools