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]
Reference:
The --no-create-info reference
Share "How to backup MySQL data only?"
Related snippets:
- Import an SQL file using the command line in MySQL
- Backup only certain rows from MySQL database
- Create INSERT statement for each record with mysqldump
- Backup MySQL database without locking tables
- Backup MySQL data only
- Skip tables in MySQL backup
- Backup only selected tables in MySQL
- Backup MySQL schema only
- Backup MySQL database
Tags:
mysql backup data only, mysql dump data only, mysqldump data only, backup mysql without schema info Technical term:
Backup MySQL data only