MySql Help

2012-05-16 12:00 am | 评论

Backup and Recovery

Use following command to backup an InnoDB table

$ mysqldump -u username -p password --default-character-set=utf8 
    --single-transaction db_name table_name > db_name-table_name-backup.sql

If you want to backup the whole database you just omit the table name. And then use the following command to recover the table.

$ mysql -u username -p password db_name-table_name-backup.sql