For Export:
mysqldump -u [user] -p [db_name] | gzip > [filename_to_compress.sql.gz]
/usr/bin/mysqldump courier --result-file=/home/ermakov/courier.sql --skip-lock-tables --user=courierapp --host=192.168.3.42 --port=3306 -p
mysqldump -P 3310 -h localhost -u mysql_user -p database_name > file.sql
mysqldump --column-statistics=0 -P 3311 -h 127.0.0.1 -uroot -pWandex1 cpanel > /home/kirill/Downloads/cpanel.sql
For Import:
gunzip < [compressed_filename.sql.gz] | mysql -u [user] -p[password] [databasename]