How to dump a mysql database as a bzip file?

Use this command:

mysqldump -u <username> -p<password> -q <database> | bzip2 -c > filename.sql.bz2

Leave a Comment