[How To] Backup Only Data of a MySQL Database

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]