Lizard Lizard - 1 year ago 177
MySQL Question

mysqldump data only

I am looking for the syntax for dumping all data in my mysql database. I don't want any table information.

Answer Source

mysqldump --no-create-info ...

If you are using triggers you also need to include --skip-triggers

And if you are using the --databases ... option you also need to include --no-create-db

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download