mysqldump --compact option

--compact is a mysqldump format option that is used to produce a more compact output of the resulting dump file.

mysqldump --compact > my_backup.sql

In order to produce a more compact output, this option enables five other options:

• --skip-add-drop-table
• --skip-add-locks
• --skip-comments
• --skip-disable-keys
• --skip-set-charset