备份:

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

还原:

mysq> use dbName

mysq> source /data/tableName.bak