# 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