mysqldump dbname -u root -p | gzip -c | cat > dbname-backup_$(date +%Y-%m-%d).sql.gz
Dump MySQL database
Quick (one line) command for dumping a MySQL database to a gzipped file: