????17??--insert-ignore????????insert ignore??????insert???
????18??--log-error-file??????????warnings??erros?????????????????????
????19??--max-allowed-packet???????????client/server????????buffer?????С??
????20??--net-buffer-length???????????client/server??????buffer??С???????????в??????????mysqlpump ?????е?N????????
????21??--no-create-db???????дCREATE DATABASE??????????????????ò???-B???????-B?????????create database????ò???????????create database ???
????22??--no-create-info???????д?????????????????????????????-t??
????23??--hex-blob?? ????binary??ε????????????????????????????????????BINARY??VARBINARY??BLOB??BIT??
????24??--host ????????????????????-h??
????25??--parallel-schemas=[N:]db_list????????б??????????????????????????N???????N?????????У????N??????????? --default-parallelism?????N???????????????--parallel-schemas??
????mysqlpump --parallel-schemas=4:vs??aa --parallel-schemas=3:pt #4????????vs??aa??3????????pt?????show processlist ?????????7??????
????mysqlpump --parallel-schemas=vs??abc --parallel-schemas=pt #???2????????2????????vs??abc??2????????pt
????####?????????IO????????????????????????????????в??б???26??--password???????????????
????27??--port ???????????????
????28??--protocol={TCP|SOCKET|PIPE|MEMORY}????????????????Э?顣
????29??--replace?????????replace into???
????30??--routines??????????????洢?????????????????????? mysql.proc???в??????????????л????CREATE PROCEDURE ?? CREATE FUNCTION???????????????????????--skip-routines??????
????31??--triggers???????????????????????????????--skip-triggers??????
????31??--set-charset???????????дSET NAMES default_character_set ????????????????? -- skip-set-charset??????????????????????????д??set names...
????32??--single-transaction???ò?????????????????ó?Repeatable Read??????dump??????start transaction ?????????????????innodb????????????????start transaction????????????????κ?????μ????????????myisam??memory???????????????????????????ε????????????????????????ALTER TABLE??CREATE TABLE??DROP TABLE??RENAME TABLE??TRUNCATE TABLE??????????????????????????????--add-locks???λ?????mysql5.7.11????--default-parallelism????1????????????????????--default-parallelism=0??5.7.11???????--single-transaction??--default-parallelism?????????
????33??--skip-definer????????Щ?????????洢????????? DEFINER ?? SQL SECURITY ?????????????????????????????????????????DEFINER????????????????
????34??--skip-dump-rows??????????????????????-d?????mysqldump???--no-data??mysqlpump?????--no-data
????35??--socket???????????localhost??Unix???????????????Windows?????????????????????-S??
????36??--ssl??--ssl????????????????--ssl-mode?????????ssl??????????????????
????37??--tz-utc???????????????????????????SET TIME_ZONE='+00:00'??????????????????????????????????????е?????timestamp??Σ???????????????????????????ò??????? --skip-tz-utc??????????
????38??--user?????????????????-u??
????39??--users??????????????????????????CREATE USER...??GRANT...?????????????????????????????
????mysqlpump --exclude-databases=% --users #??????????????40??--watch-progress??????????????????????????????к??????????ò????????????--skip-watch-progress??????
????????????
????mysqlpump????????????е?????mysqlpump????е?????????????????+?????????ж?????У?--parallel-schemas????????????????ж??????N??????????????п????1??????????????????????mysqlpump?????????????е?????????????????????????????????и???????????????????????????????????????????????????????????棬???б????Ч???????????????????????mydumper??????chunk????????????????mydumper??????????????chunk???????????????????????mysqldump?????????????????