mysqldump --user=myuser --password=mypass mydatabase > mydb.sql
[download]

You should be able to do the bzip at the same time as the dump: mysqldump --user=myuser --password=mypass mydatabase | bzip2 -- > mydb.sql That way, you don't use as much disk space.