Cacher is the code snippet organizer for pro developers

mysqldump --user=root --password= --host=localhost --compress  --disable-keys --quick [db_name] [Space separated Table Names ] > export.sql

// disable-keys + gzip compress
mysqldump -u username -p  --compress  --disable-keys --quick db_name | gzip > db.sql.gz