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``` ****Compress the output of mysqldump :**** mysqldump -u username -p database  | /bin/gzip -9 > filename.sql.gz **Backuping a single table from a database** mysqldump -u -p