Produce output that is more compatible with other database systems or with older MySQL servers --complete-insert, -c Use complete INSERT statements that include column names(使用完整的insert语句(包含列名称)。这么做能提高插入效率,但是可能会受到 max_allowed_packet 参数的影响而导致插入失败) --compres...
--add-locks Add locks around INSERT statements. (Defaults to on; use --skip-add-locks to disable.) --allow-keywords Allow creation of column names that are keywords. --apply-slave-statements Adds 'STOP SLAVE' prior to 'CHANGE MASTER' and 'START SLAVE' to bottom of dump. --bind-addres...
Produce output that is more compatible with other database systems or with older MySQL servers --complete-insert, -c Use complete INSERT statements that include column names(使用完整的insert语句(包含列名称)。这么做能提高插入效率,但是可能会受到 max_allowed_packet 参数的影响而导致插入失败) --compres...
static int dump_databases(char **db_names) { int result = 0; char **db; DBUG_TRACE; for (db = db_names; *db; db++) { if (is_infoschema_db(*db)) die(EX_USAGE, "Dumping \'%s\' DB content is not supported", *db); if (dump_all_tables_in_db(*db)) result = 1; } if...
实际dump一个表的操作逻辑也比较清晰,就是先获取表的结构信息,得到表的创建语句,然后获取表中每行的实际数据并生成对应的insert语句。 不过,前面的general log中有个值得注意的点是SAVEPOINT的出现,这一点在MySQL 5.5的mysqldump中是没有的,查看dump_all_tables_in_db函数的实现,可以找到设置savepoint的对应代码: ...
--no-set-names 同--skip-set-charset 选项 --no-tablespaces 导出文件中不包含 CREATE LOGFILE GROUP 和 CREATE TABLESPACE 语句 --opt --add-drop-table --add-locks --create-options --disable-keys --extended-insert --lock-tables --quick --set-charset的缩写 --order-by-primary 导出的数据...
-N, --skip-column-names Don't write column names in results. --sigint-ignore Ignore SIGINT (CTRL-C). -o, --one-database Ignore statements except those that occur while the default database is the one named at the command line. ...
This option requires a server version of 4.1.0 or higher. With older servers, it does nothing. · --complete-insert, -c Use complete INSERT statements that include column names. · --compress, -C Compress all information sent between the client and the server if both support compression. ...
--complete-insert Use complete INSERT statements that include column names -h, --host The host to connect to -u, --user Username with the necessary privileges -p, --password User password -P, --port TCP/IP port to connect to -S, --socket UNIX domain socket file to use for connection...
-Q, --quote-names Quote table and column names with backticks (`). --1、使用 ` 符号引起表和列名。2、默认为打开状态,使用-skip-quote-names取消该选项。 (Defaults to on; use --skip-quote-names to disable.) --replace Use REPLACE INTO instead of INSERT INTO. --使用REPLACE INTO 取代...