blog

home / developersection / blogs / back up mysql database with compress

Back up MySql Database with Compress

Uttam Misra 4630 23-Sep-2011

If your mysql database is very big and you want to compress the output of mysqldump. Just use below command..

$ mysqldump -u [username] -p[password] [databasename] | gzip -9 >
[backupfile.sql.gz]

If you want to extract the .gz file, use the command below:

$ gunzip [backupfile.sql.gz]

Updated 18-Sep-2014
Uttam Misra

Information Technology

More than 18 years of working experience in IT sector. We are here to serve you best.

Leave Comment

Comments

Liked By