Exporting MySQL Dump GZIP

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