mysqldump data only

mysql mysqldump
Lizard picture Lizard · Feb 24, 2011 · Viewed 288.1k times · Source

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

Answer

matei picture matei · Feb 24, 2011 
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

Related questions

How can I access the MySQL command line with XAMPP for Windows?

How can I access the MySQL command line with XAMPP for Windows?

Read More
Skip certain tables with mysqldump

Is there a way to restrict certain tables from the mysqldump command? For example, I'd use the following syntax to dump only table1 and table2: mysqldump -u username -p database table1 table2 > database.sql But is there a similar …

Read More
how to mysqldump remote db from local machine

I need to do a mysqldump of a database on a remote server, but the server does not have mysqldump installed. I would like to use the mysqldump on my machine to connect to the remote database and do the …

Read More