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