Cacher is the code snippet organizer for pro developers

zcat myfile.sql.gz | mysql -u root -p mydb

/usr/bin/mysqldump --opt --user=USERNAME --password=DBPASS DBNAME | gzip > /PATH/TO/dump.sql.gz