mysqldump

Backup :

mysqldump -u user -p password > backup.sql

mysqldump -u user -p password database > backup.sql

mysqldump -u user -p password database table_name1 table_name2 > backup.sql

Restore :

mysqldump -u user -p password database < backup.sql