To take backup:
All database of a user : mysqldump -Q -u[User] -A -p > foo.sql
particular Database : mysqldump -Q -u[dbUser] -B[dbName] -p > bar.sql
Restore
mysql -u[UserName] -p
mysql > source foo.sql;
mysql -u[UserName] -p
mysql > create database user_bar; # for restoring single database
mysql > source bar.sql;
To dump all database from a remote server to local server The best option is
follows
------------------------------------------------------------------------------------------------------------------------------------------------
#mysqldump --all-databases --add-drop-table --host=10.10.10.1 -p > foo.dump
--------------------------------------------------------------------------------------------------------------------------------------------------
To Restore the dump
#mysql < foo.dump
