Cacher is the code snippet organizer for pro developers

# export
mysqldump -u [uname] -p[pass] [dbname] | gzip -9 > [backupfile.sql.gz]

# import
gunzip < [backupfile.sql.gz] | mysql -u [uname] -p[pass] [dbname]

# daily export for example to be used via cron
mysqldump -u[uname] -p[pass] [dbname] | gzip -9 > /database-backup/database-daily-$(date +%d-%m-%Y).sql.gz