Couple of lines to export and import gzipped MySQL db dumps

Export:

mysqldump -uroot -p --single-transaction stglr | gzip > stglr.sql.gz

Import:

 zcat /home/user/db_dump.sql.gz | mysql -uroot -p database