mysql - mysqldump data only

Question

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

Answer 1

mysqldump --no-create-info ...

Also you may use:

• --skip-triggers: if you are using triggers
• --no-create-db: if you are using --databases ... option
• --compact: if you want to get rid of extra comments