mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]
mysqldump --add-drop-table -u sadmin -p pass21 Customers customer_master customer_details> custback.sql 
mysqldump --all-databases> alldatabases.sql
mysqldump --all-databases | bzip2 -c >databasebackup.sql.bz2

auto backup:
#!/bin/sh
date=`date -I`
mysqldump --all-databases | gzip > /var/backup/backup-$date.sql.gz

restore:
mysql -u sadmin -p pass21 Customers < custback.sql
mysql -u [username] -p [password] [database_to_restore] < [backupfile]
gunzip < custback.sql.sql.gz | mysql -u sadmin -p pass21 Customers
cat backup1.sql backup.sql | mysql -u sadmin -p pass21

inter db transfer:
mysqldump -u sadmin -p pass21 Customers | mysql --host=202.32.12.32 -C Customers