Exporting entire database:

$ mysqldump -u user -p database --opt | gzip > database.sql.gz

Export table

$ mysqldump -uroot --opt --databases DB_NAME --tables TABLE_NAME | gzip > /tmp/TABLE_NAME.export.sql.gz

Importing:

$ gunzip < database.sql.gz | mysql -u user -p database

Credit http://failshell.io/mysql/using-gzip-and-gunzip-with-mysql-to-importexport-backups/