Another draft post
Create mysql dump
$ mysqldump -uUSER -p DATABASENAME --single-transaction --quick --skip-add-drop-table --result-file=/tmp/database.sql
$ gzip /tmp/database.sql
Another draft post
$ mysqldump -uUSER -p DATABASENAME --single-transaction --quick --skip-add-drop-table --result-file=/tmp/database.sql
$ gzip /tmp/database.sql