Backing up and restoring a MySQL database

[edit] 1 On the command line

[edit] 1.1 Back up

mysqldump -u USER -h HOST -p DATABASE > FILE.sql

[edit] 1.2 Restore

mysql -u USER -h HOST -p DATABASE < FILE.sql