For Export:
mysqldump -u [user] -p [db_name] | gzip > [filename_to_compress.sql.gz]
For Import:
gunzip
I am so used running drush ard etc these days that i have almost forgot the good all mysql dump database terminal commands.
This is just for future reference in case i forget them somehow :)
terminal
linux