# mysqldump -u [uname] -p[pass] [dbname] | gzip -9 > [backupfile.sql.gz]
If you want to extract the .gz file, use the command below:
# gunzip [backupfile.sql.gz]
Showing posts with label Back up your MySQL Database with Compress. Show all posts
Showing posts with label Back up your MySQL Database with Compress. Show all posts
Back up your MySQL Database with Compress
0 comments
If your mysql database is very big, you might want to compress the output of mysqldump. Just use the mysql backup command below and pipe the output to gzip, then you will get the output as gzip file.
If you want to extract the .gz file, use the command below:
If you want to extract the .gz file, use the command below:
Subscribe to:
Posts (Atom)
