Monday, August 5, 2013

MySql Database back-up from Linux OS to Linux OS

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