Dumping a human-readable MySQL database
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
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