备份:

1
mysqldump -hhostname -uroot -ppassword dbName tableName> tableName.bak

还原:

1
2
3
mysq> use dbName

mysq> source /data/tableName.bak