Backup

Método 1

mysqldump -u root -h mysqserver -p --result-file=dbname_dbtable.sql dbname dbtable

Método 2

mysql>mysqldump -u root -p dbname > dbname_dbtable.sql

Restaurar

mysql -u root -h mysqserver -p dbname < dbname_dbtable.sql