Lizard Lizard - 6 months ago 21
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

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

Comments