数据备份恢复

backup:

mysqldump -uusername -p dbname tab1 tab2 > backup.sql

recovery:

mysql -uusername -p dbname < backup.sql