Here are three ways to backup your MySQL database(s) and compress the backup on the fly: 1. Dump database ‘dbname’ into a compressed file To dump multiple databases, you can either writ…