Users Pricing

blog

Home Blogs Back up MySql Database with Compress – MindStick

Back up MySql Database with Compress

Uttam Misra 4876 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.


Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md