Exporting MySQL Table GZIP (MySQL Dump)
mysqldump -u [username] -p[password] database_name tablename | gzip > /path/to/backup-name.sql.gz
Exporting MySQL Database GZIP (MySQL Dump)
mysqldump -u [username] -p[password] database_name | gzip > /path/to/backup-name.sql.gz