HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlModerate

How do I dump only the data for all tables using mysqldump

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
dumptablestheallmysqldumpforusinghowdataonly

Problem

I have a new database with schema and primary key, FK, index constraints created for all tables. How do I dump only the data from an existing database using mysqldump, so that I can import only the values alone and exclude everything else.

Solution

mysqldump --no-create-db --no-create-info  ...options...


See http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html

Code Snippets

mysqldump --no-create-db --no-create-info  ...options...

Context

StackExchange Database Administrators Q#34124, answer score: 10

Revisions (0)

No revisions yet.