Backup of whole DB
Source Machine:
mysqldump --quick database_name | gzip > db_name.gz
Destination Machine :
mysqladmin create db_name (if not exists)
gunzip < db_name.gz | mysql db_name
Backup of 1 table
Source Machine:
mysqldump --quick database_name table_name | gzip >
db_name.gz
Destination Machine :
mysqladmin create db_name (if not exists)
gunzip < db_name.gz | mysql db_name