Wednesday, September 7, 2016

Backup only table data in MySQL

To backup only table data in MySQL, use `--no-create-info` as follows:

mysqldump -u trust -p db_trust --no-create-info > trust_data_20160907.sql

Reference:
http://stackoverflow.com/questions/5109993/mysqldump-data-only

No comments:

Post a Comment