snippetsqlModerate
How do I dump only the data for all tables using mysqldump
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.