Note to self. When trying to export data from a mysql 5 table in something approaching a sane format use:

mysqldump -p --skip-opt --complete insert --no-create-info dbname

Additionally, mysqldump now has a convenient option to specify that you want to dump in a PostgreSQL compatible format for when you have outgrown MySQL:

mysqldump --skip-opt --complete-insert --no-create-info --compatible=postgresql -p dbname
Add post to: Delicious Reddit Slashdot Digg Technorati Google