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
Use this only if you sure that you have a duplicate databases with same structure.

Leave a Reply

Your email address will not be published. Required fields are marked *