When I recently backed up with mysqldump, I wanted to backup the data tables and data separately, so I made 2 backups.
When you perform a backup of a database table structure, you specify the--SKIP-OPT option, which is equivalent to disabling the following parameters:
--add-drop-table,--add-locks,--create-options,--quick,--extended-insert,--lock-tables,--set-charset, and-- Disable-keys
The option--create-option looks rather inconspicuous:
-A,--create-options Include all MySQL specific create options.
In fact, if you put it disable, the backup table structure will be less:
The Auto_increment property of the Auto_increment--pk field and the Auto_increment property of the datasheet are discarded Engine=innodb DEFAULT Charset=utf8-The engine of the data table, character set properties
such as MySQL-specific data table properties, you need to note that the version information, see:
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)
--------------------------------------Split Line--------------------------------------
http://zhishuedu.comTraining is a professional quality training brand jointly launched by senior MySQL expert Ye Jinlong and Wu Bingxi, with MySQL dba combat optimization and Python devops Development course, which is the most conscientious and The most quality training courses.
This article is from the "Lao Ye teahouse" blog, please be sure to keep this source http://imysql.blog.51cto.com/1540006/1879753
FAQ Series | Skip-opt of the mysqldump option