Users Pricing

blog

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

Back up MySql Database with Compress

Uttam Misra 4766 23 Sep 2011 Updated 18 Sep 2014

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]

Uttam Misra

Information Technology

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