Home > DeveloperSection > Blogs > Back up MySql Database with Compress

Back up MySql Database with Compress


Database Database 
Ratings:
0 Comment(s)
 2850  View(s)
Rate this:

Back up your MySQL Database with Compress

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]


Don't want to miss updates? Please click the below button!

Follow MindStick