Cacher is the code snippet organizer for pro developers

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]