I am mikek's Blog

The personal blog of Mike Karthauser, who you may know from Brightstorm Limited or the internet.

Exporting to a text file in mysql

Getting data out of a mysql database into a text file is pretty straight forward using mysqldump


TABLE_NAMES are optional and need to separated by a space if you are exporting a couple.

A couple of useful additional flags you can add after table names

  • –xml – converts sql output to xml which makes for an easier read
  • –no-create-info – outputs just data and no schema data.
  • –no-data – the opposite of above, which gives you just the schema
  • –complete-insert – to get column names within your insert statements
  • –skip-triggers –compact –no-create-info – for just insert statements

Filed under: development, , ,

what's hot

Flickr Photos

Sponsor Mike run the Bath Half marathon

mikek on twitter