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]