Backup
Backup a certain database;
$ mysqldump -u dbUser -p dbName > dbBackup.sql;
Backup a certain table;
$ mysqldump -u dbUser -p dbName tableName > dbTableBackup.sql;
Backup all the databases;
$ mysqldump -u dbUser -p --all-databases > allDbBackup.sql;
Optional parameters:
-lock-all-tables
-quick
-complete-insert
-no-create-db
-no-create-info
Restore
Restore a certain database;
$ mysql -u dbUser -p dbName < dbBackup.sql
Restore all databases;
$ mysql -u dbUser -p < backup.sql