mysqldump data only

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

Solution 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

Solution 2:

This should work:

# To export to file (data only)
mysqldump -u [user] -p[pass] --no-create-info mydb > mydb.sql

# To export to file (structure only)
mysqldump -u [user] -p[pass] --no-data mydb > mydb.sql

# To import to database
mysql -u [user] -p[pass] mydb < mydb.sql

NOTE: there's no space between -p & [pass]