Skip-opt for mysqldump

Recently, when I used mysqldump to back up data tables separately, I made two backups. When the database table structure is backed up, the skip-opt option is specified, which is equivalent to: -- add-drop-table, -- add-locks, -- create-options, -- quick, -- extended-insert, -- lock-tables, -- set-charset, and -- di

Recently, when I used mysqldump to back up data tables separately, I made two backups. When the database table structure is backed up, the skip-opt option is specified, which is equivalent to: -- add-drop-table, -- add-locks, -- create-options, -- quick, -- extended-insert, -- lock-tables, -- set-charset, and -- di

Recently, when I used mysqldump to back up data tables separately, I made two backups.
When the database table structure is backed up, the-skip-opt option is specified, which is equivalent:

--add-drop-table, --add-locks,--create-options, --quick, --extended-insert,--lock-tables, --set-charset, and --disable-keys

Option-create-option looks inconspicuous:

  -a, --create-options       Include all MySQL specific create options.

In fact, if we disable it, the table structure backed up will be missing:

AUTO_INCREMENT -- The AUTO_INCREMENT attribute of the PK field and the AUTO_INCREMENT attribute of the data table all lose ENGINE = InnoDB default charset = utf8 -- the ENGINE and character set attribute of the data table

For MySQL-specific data table attributes, note the following:

Server version:         5.5.19-55-log Percona Server (GPL), Release rel24.0, Revision 204mysqldump --versionmysqldump  Ver 10.13 Distrib 5.5.19, for Linux (x86_64)

Original article address: skip-opt of mysqldump option. Thank you for sharing it with the original author.