Commands to export/import/transport mysql database dumps

MySQLDump.sh

# Reference: http://webcheatsheet.com/sql/mysql_backup_restore.php

# import without compression
mysql --host=host --user=user --password=password database < path_to_file.sql

# import with compression
gunzip < path_to_file.sql.gz | mysql --host=host --user=user --password=password database

# export wihtout compression
mysqldump --host=host --user=user --password=password database table --where="condition" > path_to_file.sql

# export with compression
mysqldump --host=host --user=user --password=password database table --where="condition" | gzip -9 > path_to_file.sql.gz

# dump between servers 
mysqldump --host=host --user=user --password=password database | ssh user@server "mysql --user=user --password=password database"