????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?????????????????