How to Backup Only Data of a MySQL Database

, , Leave a comment

For exporting MySQL database’s only the data, use –no-create-info option. The dump will not re-create the database, tables, fields, and other structures when importing.

mysqldump -u username -ppassword –no-create-info database_name > dump.sql

[box type=”warning”]
Use this only if you sure that you have a duplicate databases with same structure.[/box]


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.