- Instant help with your Sql coding problems

Backup MySQL data only

Question:
How to backup MySQL data only?
Answer:
mysqldump -u testuser -p --no-create-info testdb > /tmp/backup_data_only.sql
Description:

If you want to backup only data in case of a MySQL database, use the --no-create-info option of the mysqldump utility. As result, mysqldump does not write CREATE TABLE statements that create each dumped table. 

Syntax: mysqldump -u [MYSQL_USER] -p --no-create-info testdb > [OUTPUT_FILE]

Share "How to backup MySQL data only?"