MySQL Database Backup Ignore one or more tables while doing mysqldump : mysqldump -u username -p database --ignore-table=db.table1 --ignore-table=db.table2 > mysqldump.sql``` **<font size="3">**Compress the output of mysqldump :**</font>** mysqldump -u username -p database  | /bin/gzip -9 > filename.