MySQL Data export

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

Comments are closed.