Chapter聽8.聽Client and Utility Programs - MySQL 5.1参考手册中文版

涓嬮潰绠�鍗曞垪鍑轰簡MySQL瀹㈡埛绔�绋嬪簭鍜屽疄鐢ㄥ伐鍏凤細

路         myisampack

鍘嬬缉MyISAM琛ㄤ互浜х敓鏇村皬鐨勫彧璇昏〃鐨勪竴涓�宸ュ叿銆傚弬瑙�8.2鑺傦紝鈥渕yisampack锛氱敓鎴愬帇缂┿�佸彧璇籑yISAM琛ㄢ��銆�

路         mysql

浜や簰寮忚緭鍏�SQL璇�鍙ユ垨浠庢枃浠朵互鎵瑰�勭悊妯″紡鎵ц�屽畠浠�鐨勫懡浠よ�屽伐鍏枫�傚弬瑙�8.3鑺傦紝鈥渕ysql锛歁ySQL鍛戒护琛屽伐鍏封��銆�

路         mysqlaccess

妫�鏌ヨ�块棶涓绘満鍚嶃�佺敤鎴峰悕鍜屾暟鎹�搴撶粍鍚堢殑鏉冮檺鐨勮剼鏈�銆�

路         mysqladmin

鎵ц�岀�＄悊鎿嶄綔鐨勫�㈡埛绋嬪簭锛屼緥濡傚垱寤烘垨鍒犻櫎鏁版嵁搴擄紝閲嶈浇鎺堟潈琛�锛屽皢琛ㄥ埛鏂板埌纭�鐩樹笂锛屼互鍙婇噸鏂版墦寮�鏃ュ織鏂囦欢銆�mysqladmin杩樺彲浠ョ敤鏉ユ��绱㈢増鏈�銆佽繘绋嬶紝浠ュ強鏈嶅姟鍣ㄧ殑鐘舵�佷俊鎭�銆傚弬瑙�8.5鑺傦紝鈥渕ysqladmin锛氱敤浜庣�＄悊MySQL鏈嶅姟鍣ㄧ殑瀹㈡埛绔�鈥�銆�

路         mysqlbinlog

浠庝簩杩涘埗鏃ュ織璇诲彇璇�鍙ョ殑宸ュ叿銆傚湪浜岃繘鍒舵棩蹇楁枃浠朵腑鍖呭惈鐨勬墽琛岃繃鐨勮��鍙ョ殑鏃ュ織鍙�鐢ㄦ潵甯�鍔╀粠宕╂簝涓�鎭㈠�嶃�傚弬瑙�8.6鑺傦紝鈥渕ysqlbinlog锛氱敤浜庡�勭悊浜岃繘鍒舵棩蹇楁枃浠剁殑瀹炵敤宸ュ叿鈥�銆�

路         mysqlcheck

妫�鏌ャ�佷慨澶嶃�佸垎鏋愪互鍙婁紭鍖栬〃鐨勮〃缁存姢瀹㈡埛绋嬪簭銆傚弬瑙�8.7鑺傦紝鈥渕ysqlcheck锛氳〃缁存姢鍜岀淮淇�绋嬪簭鈥�銆�

路         mysqldump

灏�MySQL鏁版嵁搴撹浆鍌ㄥ埌涓�涓�鏂囦欢锛堜緥濡�SQL璇�鍙ユ垨tab鍒嗛殧绗︽枃鏈�鏂囦欢锛夌殑瀹㈡埛绋嬪簭銆傚�炲己鐗堝厤璐硅蒋浠堕�栧厛鐢�Igor Romanenko鎻愪緵銆傚弬瑙�8.8鑺傦紝鈥渕ysqldump锛氭暟鎹�搴撳�囦唤绋嬪簭鈥�銆�

路         mysqlhotcopy

褰撴湇鍔″櫒鍦ㄨ繍琛屾椂锛屽揩閫熷�囦唤MyISAM鎴�ISAM琛ㄧ殑宸ュ叿銆傚弬瑙�8.9鑺傦紝鈥渕ysqlhotcopy锛氭暟鎹�搴撳�囦唤绋嬪簭鈥�銆�

路         mysql import

浣跨敤LOAD DATA INFILE灏嗘枃鏈�鏂囦欢瀵煎叆鐩稿叧琛ㄧ殑瀹㈡埛绋嬪簭銆傚弬瑙�8.10鑺傦紝鈥渕ysqlimport锛氭暟鎹�瀵煎叆绋嬪簭鈥�銆�

路         mysqlshow

鏄剧ず鏁版嵁搴撱�佽〃銆佸垪浠ュ強绱㈠紩鐩稿叧淇℃伅鐨勫�㈡埛绋嬪簭銆傚弬瑙�8.11鑺傦紝鈥渕ysqlshow锛氭樉绀烘暟鎹�搴撱�佽〃鍜屽垪淇℃伅鈥�銆�

路         perror

鏄剧ず绯荤粺鎴�MySQL閿欒��浠ｇ爜鍚�涔夌殑宸ュ叿銆傚弬瑙�8.13鑺傦紝鈥減error锛氳В閲婇敊璇�浠ｇ爜鈥�銆�

路         replace

鏇存敼鏂囦欢涓�鎴栨爣鍑嗚緭鍏ヤ腑鐨勫瓧绗︿覆鐨勫疄鐢ㄥ伐鍏枫�傚弬瑙�8.14鑺傦紝鈥渞eplace锛氬瓧绗︿覆鏇挎崲瀹炵敤宸ュ叿鈥�銆�

MySQL AB杩樻彁渚涗簡澶ч噺GUI宸ュ叿鐢ㄤ簬绠＄悊鍜�MySQL鏈嶅姟鍣ㄧ殑鍏跺畠宸ヤ綔銆傜浉鍏冲熀鏈�淇℃伅鍙傝��绗�4绔狅細MySQL绋嬪簭姒傝堪銆�

姣忎釜MySQL绋嬪簭鏈夎�稿�氫笉鍚岀殑閫夐」銆備絾姣忎釜MySQL绋嬪簭鍧囨彁渚涗竴涓�---help閫夐」锛屽彲浠ョ敤鏉ュ叏闈㈡弿杩扮▼搴忎笉鍚岀殑閫夐」銆備緥濡傦紝鍙�浠ヨ瘯璇�mysql---help銆�

浣跨敤mysqlclient搴撳悓鏈嶅姟鍣ㄨ繘琛岄�氳��鐨�MySQL瀹㈡埛浣跨敤涓嬮潰鐨勭幆澧冨彉閲忥細

浣跨敤MYSQL_PWD涓嶅畨鍏ㄣ�傚弬瑙�5.8.6鑺傦紝鈥滀娇浣犵殑瀵嗙爜瀹夊叏鈥�銆�

鍙�浠ュ湪閫夐」鏂囦欢涓�鎴栧湪鍛戒护琛屼腑鎸囧畾閫夐」鏉ユ浛鎹㈡墍鏈夋爣鍑嗙▼搴忕殑榛樿�ら�夐」鍊兼垨鎸囧畾鐨勭幆澧冨彉閲忕殑鍊笺�傚弬瑙�4.3鑺傦紝鈥滄寚瀹氱▼搴忛�夐」鈥�銆�

myisampack宸ュ叿鍙�浠ュ帇缂�MyISAM琛�.MYIsampack鍒嗗埆鍘嬬缉琛ㄤ腑鐨勬瘡涓�鍒椼�傞�氬父锛�myisampack鍙�浠ュ皢鏁版嵁鏂囦欢鍘嬬缉鍒�40%-70%銆�

褰撲互鍚庝娇鐢ㄨ〃鏃讹紝瑙ｅ帇缂╁垪闇�瑕佺殑淇℃伅琚�璇诲叆鍐呭瓨銆傚綋璁块棶鍏蜂綋鐨勮�板綍鏃舵�ц兘浼氭洿濂斤紝鍥犱负浣犲彧闇�瑕佽В鍘嬬缉涓�涓�璁板綍銆�

MySQL浣跨敤mmap()瀵瑰帇缂╃殑琛ㄨ繘琛屽唴瀛樻槧灏勩�傚�傛灉mmap()涓嶅伐浣滐紝MySQL杩斿洖鍒版櫘閫氳��/鍐欐枃浠舵搷浣溿��

璇锋敞鎰忥細

路         濡傛灉鐢�--skip-external-locking閫夐」璋冪敤mysqld鏈嶅姟鍣�锛屽�傛灉鍦ㄥ帇缂╄繃绋嬩腑琛ㄥ彲鑳借��鏇存柊锛岃皟鐢�myisampack涓嶆槸涓�涓�濂芥敞鎰忋��

路         琛ㄥ帇缂╁悗锛屽畠鍙樹负鍙�璇汇�傝繖鏄�鏁呮剰鐨�(渚嬪�傚綋璁块棶CD涓婄殑鍘嬬缉鐨勮〃鏃�)銆傚厑璁稿啓鍏ュ埌鍘嬬缉鐨勮〃浣嶄簬鎴戜滑鐨�TODO鍒楄〃涓�锛屼絾浼樺厛绾ц緝浣庛��

路         myisampack鍙�浠ュ帇缂�BLOB鎴�TEXT鍒椼�傛棫鐗堟湰ISAM琛ㄧ殑pack_isam绋嬪簭涓嶅彲浠ャ��

璋冪敤myisampack鐨勬柟娉曪細

shell> myisampack [options] filename ...

鏂囦欢鍚嶅簲涓虹储寮�(.MYI)鏂囦欢鐨勬枃浠跺悕銆傚�傛灉涓嶅湪鏁版嵁搴撶洰褰曪紝搴旀寚瀹氭枃浠剁殑璺�寰勫悕銆傚厑璁稿拷鐣�.MYI鎵╁睍鍚嶃��

myisampack鏀�鎸佷笅闈㈢殑閫夐」锛�

路         --help锛�-锛�

鏄剧ず甯�鍔╂秷鎭�骞堕��鍑恒��

路         --backup锛�-b

浣跨敤tbl_name.OLD鍚嶅�囦唤琛ㄦ暟鎹�鏂囦欢銆�

路         ---debug[=debug_options]锛�-# [debug_options]

鍐欒皟璇曟棩蹇椼��debug_options瀛楃�︿覆閫氬父涓�'d:t:o,file_name'銆�

路         --force锛�-f

浜х敓涓�涓�鍘嬬缉鐨勮〃锛屽嵆浣垮畠姣斿師濮嬭〃澶э紝鎴栧�傛灉浠ュ墠璋冪敤myisampack鐨勪腑闂存枃浠跺瓨鍦ㄣ��(myisampack鍘嬬缉琛ㄦ椂鍦ㄦ暟鎹�搴撶洰褰曚腑鍒涘缓涓�涓�鍚嶄负tbl_name.TMD鐨勪腑闂存枃浠躲�傚�傛灉鏉�鎺�myisampack锛�.TMD鏂囦欢浼氳��鍒犻櫎锛�銆�閫氬父鎯呭喌锛屽�傛灉myisampack鍙戠幇tbl_name.TMD瀛樺湪鍒欓��鍑哄苟鎻愮ず閿欒��銆傜敤--force锛�myisampack鍒欎竴瀹氬帇缂╄〃銆�

路         -join=big_tbl_name锛�-j big_tbl_name

灏嗗懡浠よ�屼腑鐨勬墍鏈夎〃鑱旀帴涓轰竴涓�琛�big_tbl_name銆傚皢瑕佽繛鎺ョ殑鎵�鏈夎〃蹇呴』鏈夌浉绛夌殑缁撴瀯(鐩稿悓鐨勫垪鍚嶅拰绫诲瀷锛岀浉鍚岀殑绱㈠紩绛夌瓑)銆�

路         --pack length=len锛�-p len

鎸囧畾璁板綍闀垮害瀛樺偍澶у皬锛屼互瀛楄妭璁°�傚�煎簲涓�1銆�2鎴栬��3銆�myisampack淇濆瓨鎵�鏈夐暱搴︽寚閽堜负1銆�2鎴栬��3瀛楄妭鐨勮�屻�傚湪澶у�氭暟姝ｅ父鎯呭喌涓嬶紝myisampack鍦ㄥ紑濮嬪帇缂╂枃浠跺墠鍙�浠ョ‘瀹氬噯纭�鐨勯暱搴﹀�硷紝浣嗗湪鍘嬬缉杩囩▼涓�瀹冨彲浠ユ彁绀哄畠鍙�鑳藉凡缁忎娇鐢ㄤ簡涓�涓�鐭�鐨勯暱搴︺�傚湪杩欑�嶆儏鍐典笅锛�myisampack杈撳嚭涓�鏉℃彁绀猴紝涓嬫�′綘鍘嬬缉鍚屼竴鏂囦欢鏃讹紝浣犲彲浠ヤ娇鐢ㄦ洿鐭�鐨勮�板綍闀垮害銆�

路         --silent锛�-s

娌夐粯妯″紡銆傚彧鏈夊彂鐢熼敊璇�鏃舵墠鍐欒緭鍑恒��

路         --test锛�-t

娌℃湁瀹為檯鍦板帇缂╄〃锛屽彧鏄�娴嬭瘯鍘嬬缉銆�

路         --tmpdir=path锛�-T path

浣跨敤myisamchk鍒涘缓涓存椂鏂囦欢鐨勭洰褰曘��

路         --verbose锛�-v

鍐楅暱妯″紡銆傚啓鍘嬬缉鎿嶄綔杩囩▼鐩稿叧淇℃伅鍜屽叾缁撴灉銆�

路         --version锛�-V

鏄剧ず鐗堟湰淇℃伅骞堕��鍑恒��

路         --wait锛�-w

濡傛灉琛ㄦ�ｄ娇鐢ㄥ垯绛夊緟骞堕噸璇曘�傚�傛灉鐢�--skip-external-locking閫夐」璋冪敤浜�mysqld鏈嶅姟鍣�锛屽�傛灉鍦ㄥ帇缂╄繃绋嬩腑琛ㄥ彲鑳借��鏇存柊锛岃皟鐢�myisampack涓嶆槸涓�涓�濂芥敞鎰忋��

涓嬮潰鐨勯『搴忓懡浠よ�存槑浜嗗吀鍨嬬殑琛ㄥ帇缂╀細璇濓細

shell> ls -l station.*

-rw-rw-r--   1 monty    my         994128 Apr 17 19:00 station.MYD

-rw-rw-r--   1 monty    my          53248 Apr 17 19:00 station.MYI

-rw-rw-r--   1 monty    my           5767 Apr 17 19:00 station.frm

shell> myisamchk -dvv station

MyISAM file:     station

Isam-version:  2

Creation time: 1996-03-13 10:08:58

Recover time:  1997-02-02  3:06:43

Data records:              1192  Deleted blocks:              0

Datafile parts:            1192  Deleted data:                0

Datafile pointer (bytes):     2  Keyfile pointer (bytes):     2

Max datafile length:   54657023  Max keyfile length:   33554431

Recordlength:               834

Record format: Fixed length

table description:

Key Start Len Index   Type                 Root  Blocksize    Rec/key

1   2     4   unique  unsigned long        1024       1024          1

2   32    30  multip. text                10240       1024          1

Field Start Length Type

1     1     1

2     2     4

3     6     4

4     10    1

5     11    20

6     31    1

7     32    30

8     62    35

9     97    35

10    132   35

11    167   4

12    171   16

13    187   35

14    222   4

15    226   16

16    242   20

17    262   20

18    282   20

19    302   30

20    332   4

21    336   4

22    340   1

23    341   8

24    349   8

25    357   8

26    365   2

27    367   2

28    369   4

29    373   4

30    377   1

31    378   2

32    380   8

33    388   4

34    392   4

35    396   4

36    400   4

37    404   1

38    405   4

39    409   4

40    413   4

41    417   4

42    421   4

43    425   4

44    429   20

45    449   30

46    479   1

47    480   1

48    481   79

49    560   79

50    639   79

51    718   79

52    797   8

53    805   1

54    806   1

55    807   20

56    827   4

57    831   4

shell> myisampack station.MYI

Compressing station.MYI: (1192 records)

- Calculating statistics

normal:     20  empty-space:   16  empty-zero:     12  empty-fill:  11

pre-space:   0  end-space:     12  table-lookups:   5  zero:         7

Original trees:  57  After join: 17

- Compressing file

87.14%

Remember to run myisamchk -rq on compressed tables

shell> ls -l station.*

-rw-rw-r--   1 monty    my         127874 Apr 17 19:00 station.MYD

-rw-rw-r--   1 monty    my          55296 Apr 17 19:04 station.MYI

-rw-rw-r--   1 monty    my           5767 Apr 17 19:00 station.frm

shell> myisamchk -dvv station

MyISAM file:     station

Isam-version:  2

Creation time: 1996-03-13 10:08:58

Recover time:  1997-04-17 19:04:26

Data records:               1192  Deleted blocks:              0

Datafile parts:             1192  Deleted data:                0

Datafile pointer (bytes):      3  Keyfile pointer (bytes):     1

Max datafile length:    16777215  Max keyfile length:     131071

Recordlength:                834

Record format: Compressed

table description:

Key Start Len Index   Type                 Root  Blocksize    Rec/key

1   2     4   unique  unsigned long       10240       1024          1

2   32    30  multip. text                54272       1024          1

Field Start Length Type                         Huff tree  Bits

1     1     1      constant                             1     0

2     2     4      zerofill(1)                          2     9

3     6     4      no zeros, zerofill(1)                2     9

4     10    1                                           3     9

5     11    20     table-lookup                         4     0

6     31    1                                           3     9

7     32    30     no endspace, not_always              5     9

8     62    35     no endspace, not_always, no empty    6     9

9     97    35     no empty                             7     9

10    132   35     no endspace, not_always, no empty    6     9

11    167   4      zerofill(1)                          2     9

12    171   16     no endspace, not_always, no empty    5     9

13    187   35     no endspace, not_always, no empty    6     9

14    222   4      zerofill(1)                          2     9

15    226   16     no endspace, not_always, no empty    5     9

16    242   20     no endspace, not_always              8     9

17    262   20     no endspace, no empty                8     9

18    282   20     no endspace, no empty                5     9

19    302   30     no endspace, no empty                6     9

20    332   4      always zero                          2     9

21    336   4      always zero                          2     9

22    340   1                                           3     9

23    341   8      table-lookup                         9     0

24    349   8      table-lookup                        10     0

25    357   8      always zero                          2     9

26    365   2                                           2     9

27    367   2      no zeros, zerofill(1)                2     9

28    369   4      no zeros, zerofill(1)                2     9

29    373   4      table-lookup                        11     0

30    377   1                                           3     9

31    378   2      no zeros, zerofill(1)                2     9

32    380   8      no zeros                             2     9

33    388   4      always zero                          2     9

34    392   4      table-lookup                        12     0

35    396   4      no zeros, zerofill(1)               13     9

36    400   4      no zeros, zerofill(1)                2     9

37    404   1                                           2     9

38    405   4      no zeros                             2     9

39    409   4      always zero                          2     9

40    413   4      no zeros                             2     9

41    417   4      always zero                          2     9

42    421   4      no zeros                             2     9

43    425   4      always zero                          2     9

44    429   20     no empty                             3     9

45    449   30     no empty                             3     9

46    479   1                                          14     4

47    480   1                                          14     4

48    481   79     no endspace, no empty               15     9

49    560   79     no empty                             2     9

50    639   79     no empty                             2     9

51    718   79     no endspace                         16     9

52    797   8      no empty                             2     9

53    805   1                                          17     1

54    806   1                                           3     9

55    807   20     no empty                             3     9

56    827   4      no zeros, zerofill(2)                2     9

57    831   4      no zeros, zerofill(1)                2     9

myisampack鏄剧ず涓嬮潰鐨勫悇绉嶄俊鎭�锛�

路         normal

涓嶉渶瑕佽繘琛岄�濆�栧帇缂╃殑鍒楃殑鏁伴噺銆�

路         empty-space

鍙�鍖呭惈绌烘牸鐨勫垪鐨勬暟閲忥紱鍗犱竴涓�姣旂壒銆�

路         empty-zero

鍙�鍖呭惈浜岃繘鍒堕浂鐨勫垪鐨勬暟閲忥紱鍗犱竴涓�姣旂壒銆�

路         empty-fill

涓嶅崰璇ョ被鍏ㄥ瓧鑺傝寖鍥寸殑鏁存暟鍒楃殑鏁伴噺锛涜繖浜涘垪琚�鏀逛负杈冨皬鐨勭被鍨嬨�備緥濡傦紝濡傛灉鎵�鏈夊�肩殑鑼冨洿涓轰粠-128鍒�127锛�BIGINT鍒�(8涓�瀛楄妭)鍙�浠ヤ繚瀛樹负TINYINT鍒�(1涓�瀛楄妭)銆�

路         pre-space

鐢ㄥ紩瀵肩┖鏍间繚瀛樼殑鍗佽繘鍒跺垪鐨勬暟閲忋�傚湪杩欑�嶆儏鍐典笅锛屾瘡涓�鍊煎寘鍚�涓�涓�寮曞�肩┖鏍肩殑鏁伴噺璁℃暟銆�

路         end-space

鏈夊ぇ閲忕粨灏剧┖鏍肩殑鍒楃殑鏁伴噺銆傚湪杩欑�嶆儏鍐典笅锛屾瘡涓�鍊煎寘鍚�涓�涓�缁撳熬绌烘牸鐨勬暟閲忚�℃暟銆�

路         table-lookup

璇ュ垪鍙�鏈夊皯閲忕殑涓嶅悓鐨勫�硷紝鍦ㄨ繘琛屽搱澶�鏇煎帇缂╁墠琚�杞�鎹�涓轰竴涓�ENUM銆�

路         zero

鎵�鏈夊�间负闆剁殑鍒楃殑鏁伴噺銆�

路         Original trees

鍝堝か鏇兼爲鐨勬渶鍒濇暟閲忋��

路         After join

鑱旀帴鏍戜互鑺傜渷涓�浜涘ご绌洪棿涔嬪悗鐣欎笅鐨勫搱澶�鏇兼爲鐨勬暟閲忋��

琛ㄨ��鍘嬬缉鍚庯紝myisamchk -dvv涓烘瘡鍒楄緭鍑鸿�︾粏淇℃伅锛�

路         Type

鍒楃殑绫诲瀷銆傝�ュ�煎彲浠ュ寘鍚�涓嬮潰鐨勪换浣曟弿杩扮�︼細

o        constant

鎵�鏈夎�屽叿鏈夌浉鍚岀殑鍊笺��

o        no endspace

涓嶄繚瀛樼粨灏剧┖鏍笺��

o        no endspace锛�not_always

涓嶄繚瀛樼粨灏剧┖鏍煎苟涓斿�逛簬鎵�鏈夌殑鍊间笉鍘嬬缉缁撳熬绌烘牸銆�

o        no endspace锛�no empty

涓嶄繚瀛樼粨灏剧┖鏍笺�備笉淇濆瓨绌哄�笺��

o        table-lookup

鍒楄��杞�鎹�涓轰竴涓�ENUM銆�

o        zerofill(n)

鍊间腑鏈�鏈夋剰涔夌殑n瀛楄妭鎬讳负0锛屽苟涓斾笉淇濆瓨銆�

o        no zeros

涓嶄繚瀛橀浂銆�

o        always zeros

鐢ㄤ竴涓�浣嶄繚瀛橀浂鍊笺��

路         Huff tree

鍒楃浉鍏崇殑鍝堝か鏇兼爲鐨勬暟閲忋��

路         Bits

鍝堝か鏇兼爲浣跨敤鐨勪綅鏁般��

杩愯��myisampack鍚庯紝蹇呴』杩愯��myisamchk浠ラ噸鏂板垱寤虹储寮曘�傛�ゆ椂锛屼綘涔熷彲浠ユ帓搴忕储寮曞潡骞跺垱寤�MySQL浼樺寲鍣ㄩ渶瑕佺殑缁熻�′俊鎭�浠ユ洿鏈夋晥鍦板伐浣滐細

shell> myisamchk -rq --sort-index --analyze tbl_name.MYI

灏嗗帇缂╃殑琛ㄥ畨瑁呭埌MySQL鏁版嵁搴撶洰褰曚腑鍚庯紝搴旀墽琛�mysqladmin flush-tables浠ュ己鍒�mysqld浣跨敤鏂扮殑琛ㄣ��

瑕佹兂瑙ｅ帇缂╀竴涓�鍘嬬缉鐨勮〃锛屼娇鐢�myisamchk鎴�isamchk鐨�--unpack閫夐」銆�

mysql鏄�涓�涓�绠�鍗曠殑SQL澶栧３(鏈�GNU readline鍔熻兘)銆傚畠鏀�鎸佷氦浜掑紡鍜岄潪浜や簰寮忎娇鐢ㄣ�傚綋浜や簰浣跨敤鏃讹紝鏌ヨ�㈢粨鏋滈噰鐢�ASCII琛ㄦ牸寮忋�傚綋閲囩敤闈炰氦浜掑紡(渚嬪�傦紝鐢ㄤ綔杩囨护鍣�)妯″紡鏃讹紝缁撴灉涓�tab鍒嗗壊绗︽牸寮忋�傚彲浠ヤ娇鐢ㄥ懡浠よ�岄�夐」鏇存敼杈撳嚭鏍煎紡銆�

濡傛灉鐢变簬缁撴灉杈冨ぇ鑰屽唴瀛樹笉瓒抽亣鍒伴棶棰橈紝浣跨敤--quick閫夐」銆傝繖鏍峰彲浠ュ己鍒�mysql浠庢湇鍔″櫒姣忔�′竴琛屾悳绱㈢粨鏋滐紝鑰屼笉鏄�妫�绱㈡暣涓�缁撴灉闆嗗苟鍦ㄦ樉绀轰箣鍓嶄笉寰椾笉灏嗗畠淇濆瓨鍒板唴瀛樹腑銆備娇鐢�mysql_use_result()鑰屼笉鏄�mysql_store_result()鏉ユ悳绱㈢粨鏋滈泦銆�

浣跨敤mysql寰堢畝鍗曘�備粠鍛戒护瑙ｉ噴绗︽彁绀烘潵璋冪敤瀹冿細

shell> mysql db_name

鎴栵細

shell> mysql --user=user_name --password=your_password db_name

杩欐牱杈撳叆涓�涓�SQL璇�鍙ワ紝鐢ㄢ��锛�鈥欍��\g鎴栬��\G缁撳熬骞舵寜鍥炶溅閿�銆�

浣犲彲浠ヨ繖鏍疯繍琛屼竴涓�鑴氭湰锛�

shell> mysql db_name < script.sql > output.tab

路                shell> ln -s /dev/null $HOME/.mysql_history

mysql> help

List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
?         (\?) Synonym for `help'.
clear     (\c) Clear command.
connect   (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter. NOTE: Takes the rest of the line as new delimiter.
edit      (\e) Edit command with $EDITOR.
ego       (\G) Send command to mysql server, display result vertically.
exit      (\q) Exit mysql. Same as quit.
go        (\g) Send command to mysql server.
help      (\h) Display this help.
nopager   (\n) Disable pager, print to stdout.
notee     (\t) Don't write into outfile.
pager     (\P) Set PAGER [to_pager]. Print the query results via PAGER.
print     (\p) Print current command.
prompt    (\R) Change your mysql prompt.
quit      (\q) Quit mysql.
rehash    (\#) Rebuild completion hash.
source    (\.) Execute a SQL script file. Takes a file name as an argument.
status    (\s) Get status information from the server.
system    (\!) Execute a system shell command.
tee       (\T) Set outfile [to_outfile]. Append everything into given outfile.
use       (\u) Use another database. Takes database name as argument.
warnings  (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.

路                mysql> pager cat > /tmp/log.txt

mysql> pager less -n -i -S

路                shell> man less

路                mysql> PAGER cat | tee /dr1/tmp/res.txt \

路                          | tee /dr2/tmp/res2.txt | less -n -i -S

shell> export MYSQL_PS1="(\u@\h) [\d]> "

[mysql]

prompt=(\\u@\\h) [\\d]>\\_

[mysql]

prompt="\\r:\\m:\\s> "

shell> mysql --prompt="(\u@\h) [\d]> "

(user@host) [database]>

mysql> prompt (\u@\h) [\d]>\_

PROMPT set to '(\u@\h) [\d]>\_'

(user@host) [database]>

(user@host) [database]> prompt

Returning to default PROMPT of mysql>

mysql>

shell> mysql db_name

shell> mysql db_name < text_file

shell> mysql < text_file

mysql> source filename

mysql> \. filename

SELECT '<info_to_display>' AS ' '锛�

mysql> SELECT * FROM mails WHERE LENGTH(txt) < 300 LIMIT 300,1\G
*************************** 1. row ***************************
  msg_nro: 3068
     date: 2000-03-01 23:29:50
time_zone: +0200
mail_from: Monty
    reply: monty@no.spam.com
  mail_to: "Thimble Smith" <tim@no.spam.com>
      sbj: UTF-8
      txt: >>>>> "Thimble" == Thimble Smith writes:

Thimble> Hi.  I think this is a good idea.  Is anyone familiar
Thimble> with UTF-8 or Unicode? Otherwise, I'll put this on my
Thimble> TODO list and see what happens.

Yes, please do that.

Regards,
Monty
     file: inbox-jani-1
     hash: 190402944
1 row in set (0.09 sec)

SET SQL_SAFE_UPDATES=1,SQL_SELECT_LIMIT=1000, SQL_MAX_JOIN_SIZE=1000000;

路                UPDATE tbl_name SET not_key_column=val WHERE key_column=val;

路                 

路                UPDATE tbl_name SET not_key_column=val LIMIT 1;

shell> mysql --safe-updates --select_limit=500 --max_join_size=10000

mysql> SET @a=1;

Query OK, 0 rows affected (0.05 sec)

mysql> INSERT INTO t VALUES(@a);

ERROR 2006: MySQL server has gone away

No connection. Trying to reconnect...

Connection id:    1

Current database: test

Query OK, 1 row affected (1.30 sec)

mysql> SELECT * FROM t;

+------+

| a    |

+------+

| NULL |

+------+

1 row in set (0.05 sec)

shell> mysqlaccess [host_name [user_name [db_name]]] [options]

$MYSQL     = '/usr/local/bin/mysql';    # path to mysql executable

mysqladmin鏄�涓�涓�鎵ц�岀�＄悊鎿嶄綔鐨勫�㈡埛绋嬪簭銆傚彲浠ョ敤瀹冩潵妫�鏌ユ湇鍔″櫒鐨勯厤缃�鍜屽綋鍓嶇殑鐘舵�侊紝鍒涘缓骞跺垹闄ゆ暟鎹�搴撶瓑绛夈��

杩欐牱璋冪敤mysqladmin锛�

shell> mysqladmin [options] command [command-options] [command [command-options]] ...

mysqladmin鏀�鎸佷笅闈㈢殑鍛戒护锛�

路         create db_name

鍒涘缓涓�涓�鍚嶄负db_name鐨勬柊鏁版嵁搴撱��

路         debug

鍛婅瘔鏈嶅姟鍣ㄥ悜閿欒��鏃ュ織鍐欏叆璋冭瘯淇℃伅銆�

路         drop db_name

鍒犻櫎鍚嶄负db_nam鐨勬暟鎹�搴撳拰鎵�鏈夎〃銆�

路         extended-status

鏄剧ず鏈嶅姟鍣ㄧ姸鎬佸彉閲忓強鍏跺�笺��

路         flush-hosts

鍒锋柊涓绘満缂撳瓨涓�鐨勬墍鏈変俊鎭�銆�

路         flush-logs

鍒锋柊鎵�鏈夋棩蹇椼��

路         flush-privileges

閲嶈浇鎺堟潈琛�(绫讳技reload)銆�

路         flush-status

娓呴櫎鐘舵�佸彉閲忋��

路         flush-tables

鍒锋柊鎵�鏈夎〃銆�

路         flush-threads

鍒锋柊绾跨▼缂撳瓨銆�

路         kill id,id,...

鏉�鎺夋湇鍔″櫒绾跨▼銆�

路         old-password new-password

绫讳技password浣嗕娇鐢ㄦ棫鐨�(pre-4.1)瀵嗙爜鍝堝笇鏍煎紡淇濆瓨 瀵嗙爜銆�(鍙傝��5.7.9鑺傦紝鈥淢ySQL 4.1涓�鐨勫瘑鐮佸搱甯屽�勭悊鈥�锛�銆�

路         password new-password

璁剧疆涓�涓�鏂板瘑鐮併�傚皢鐢�mysqladmin杩炴帴鏈嶅姟鍣ㄤ娇鐢ㄧ殑 璐︽埛鐨勫瘑鐮佹洿鏀逛负new-password銆�

濡傛灉new-password鍖呭惈绌烘牸鎴栧叾瀹冨懡浠よВ閲婄�︾殑鐗规畩瀛楃�︼紝闇�瑕佺敤寮曞彿灏嗗畠寮曡捣鏉ャ�傚湪Windows涓�锛屼竴瀹氳�佷娇鐢ㄥ弻寮曞彿鑰屼笉瑕佺敤鍗曞紩鍙凤紱鍗曞紩鍙蜂笉浼氫粠 瀵嗙爜涓�鍓ョ�诲嚭鏉ワ紝鑰屾槸瑙ｉ噴涓哄瘑鐮佺殑涓�閮ㄥ垎銆備緥濡傦細

shell> mysqladmin password "my new password"

路         ping

妫�鏌ユ湇鍔″櫒鏄�鍚︿粛娲诲姩銆傚�傛灉鏈嶅姟鍣ㄥ湪杩愯��mysqladmin杩斿洖鐘舵��0锛屽�傛灉涓嶈繍琛岃繑鍥�1銆傚嵆浣垮嚭鐜伴敊璇�渚嬪��Access denied涔熶负0锛屽洜涓鸿繖璇存槑鏈嶅姟鍣ㄥ湪杩愯�屼絾鎷掔粷浜嗚繛鎺ワ紝涓庢湇鍔″櫒涓嶅湪杩愯�屼笉鍚屻��

路         processlist

鏄剧ず娲诲姩鏈嶅姟鍣ㄧ嚎绋嬬殑鍒楄〃銆傜被浼�SHOW PROCESSLIST璇�鍙ョ殑杈撳嚭銆傚�傛灉缁欏嚭浜�--verbose閫夐」锛岃緭鍑虹被浼�SHOW FULL PROCESSLIST銆�(鍙傝��13.5.4.16鑺傦紝鈥淪HOW PROCESSLIST璇�娉曗��锛�銆�

路         reload

閲嶈浇鎺堟潈琛ㄣ��

路         refresh

鍒锋柊鎵�鏈夎〃骞跺叧闂�鍜屾墦寮�鏃ュ織鏂囦欢銆�

路         shutdown

鍋滄�㈡湇鍔″櫒銆�

路         start-slave

寮�濮嬩粠鏈嶅姟鍣ㄤ笂鐨勫�嶅埗銆�

路         status

鏄剧ず鐭�鏈嶅姟鍣ㄧ姸鎬佹秷鎭�銆�

路         stop-slave

鍋滄��浠庢湇鍔″櫒涓婄殑澶嶅埗銆�

路         variables

鏄剧ず鏈嶅姟鍣ㄧ郴缁熷彉閲忓強鍏跺�笺��

路         version

鏄剧ず鏈嶅姟鍣ㄧ殑鐗堟湰淇℃伅銆�

鎵�鏈夊懡浠ゅ彲浠ョ畝鍖栦负浠讳綍鍞�涓�鐨勫墠缂�銆備緥濡傦細

shell> mysqladmin proc stat

+----+-------+-----------+----+---------+------+-------+------------------+

| Id | User  | Host      | db | Command | Time | State | Info             |

+----+-------+-----------+----+---------+------+-------+------------------+

| 51 | monty | localhost |    | Query   | 0    |       | show processlist |

+----+-------+-----------+----+---------+------+-------+------------------+

Uptime: 1473624  Threads: 1  Questions: 39487  

Slow queries: 0  Opens: 541  Flush tables: 1  

Open tables: 19  Queries per second avg: 0.0268

mysqladmin status鍛戒护鐨勭粨鏋滄樉绀轰笅闈㈢殑鍊硷細

路         Uptime

MySQL鏈嶅姟鍣ㄥ凡缁忚繍琛岀殑绉掓暟銆�

路         Threads

娲诲姩绾跨▼(瀹㈡埛)鐨勬暟鐩�銆�

路         Questions

鏈嶅姟鍣ㄥ惎鍔ㄤ互鏉ュ�㈡埛鐨勯棶棰�(鏌ヨ��)鏁扮洰銆�

路         Slow queries

鎵ц�屾椂闂磋秴杩�long_query_time绉掔殑鏌ヨ�㈢殑鏁伴噺銆傚弬瑙�5.11.4鑺傦紝鈥滄參閫熸煡璇㈡棩蹇椻��銆�

路         Opens

鏈嶅姟鍣ㄥ凡缁忔墦寮�鐨勬暟鎹�搴撹〃鐨勬暟閲忋��

路         Flush tables

鏈嶅姟鍣ㄥ凡缁忔墽琛岀殑flush ...銆�refresh鍜�reload鍛戒护鐨勬暟閲忋��

路         Open tables

鐩�鍓嶆墦寮�鐨勮〃鐨勬暟閲忋��

路         Memory in use

mysqld浠ｇ爜鐩存帴鍒嗛厤鐨勫唴瀛樻暟閲忋�傚彧鏈夌敤--with--debug=full缂栬瘧浜�MySQL璇ュ�兼墠鏄剧ず銆�

路         Maximum memory used

mysqld浠ｇ爜鐩存帴鍒嗛厤鐨勬渶澶у唴瀛樻暟閲忋�傚彧鏈夌敤--with--debug=full缂栬瘧浜�MySQL璇ュ�兼墠鏄剧ず銆�

濡傛灉褰撲娇鐢�Unix濂楁帴瀛楁枃浠惰繛鎺ユ湰鍦版湇鍔″櫒鏃舵墽琛�mysqladmin shutdown锛�mysqladmin灏嗙瓑寰呯洿鍒版湇鍔″櫒鐨勮繘绋�ID鏂囦欢琚�鍒犻櫎锛屼互纭�淇濇湇鍔″櫒姝ｇ‘鍋滄��銆�

mysqladmin鏀�鎸佷笅闈㈢殑閫夐」锛�

路         ---help锛�-锛�

鏄剧ず甯�鍔╂秷鎭�骞堕��鍑恒��

路         --character-sets-dir=path

瀛楃�﹂泦鐨勫畨瑁呯洰褰曘�傚弬瑙�5.10.1鑺傦紝鈥滄暟鎹�鍜屾帓搴忕敤瀛楃�﹂泦鈥�銆�

路         --compress锛�-C

鍘嬬缉瀹㈡埛鍜屾湇鍔″櫒涔嬮棿鍙戦�佺殑鎵�鏈変俊鎭�锛堝�傛灉浜岃�呭潎鏀�鎸佸帇缂╋級銆�

路         --count=num锛�-c num

杩�浠ｆ暟鐩�銆傝�ラ�夐」鍙�鏈夌粨鍚�--sleep (-i)鎵嶈兘宸ヤ綔銆�

路         ---debug[=debug_options]锛�-# [debug_options]

鍐欒皟璇曟棩蹇椼��debug_options瀛楃�︿覆閫氬父涓�'d:t:o,file_name'銆� 榛樿�や负'd:t:o,/tmp/mysqladmin.trace'銆�

路         --default-character-set=charset

浣跨敤charsetas浣滀负榛樿�ゅ瓧绗﹂泦銆傚弬瑙�5.10.1鑺傦紝鈥滄暟鎹�鍜屾帓搴忕敤瀛楃�﹂泦鈥�銆�

路         --force锛�-f

涓嶅啀涓�drop database鍛戒护杩涜�岀‘璁ゃ�傚�逛簬澶氫釜鍛戒护锛屽嵆浣垮嚭鐜伴敊璇�涔熺户缁�銆�

路         --host=host_name锛�-h host_name

杩炴帴缁欏畾涓绘満涓婄殑MySQL鏈嶅姟鍣ㄣ��

路         --password[=password]锛�-p[password]

杩炴帴鏈嶅姟鍣ㄤ娇鐢ㄧ殑瀵嗙爜銆傚�傛灉浣跨敤鐭�閫夐」褰㈠紡(-p)锛岃�ラ�夐」鍜� 瀵嗙爜涔嬮棿涓嶈兘鏈夌┖鏍笺�傚�傛灉浣犲湪鍛戒护琛屼腑鍦�--password鎴�-p閫夐」鍚庨潰鐪佺暐 瀵嗙爜鍊硷紝灏嗘彁绀轰綘杈撳叆瀵嗙爜銆�

路         --port=port_num锛�-P port_num

鐢ㄤ簬杩炴帴鐨�TCP/IP绔�鍙ｅ彿銆�

路         --protocol={TCP | SOCKET | PIPE | MEMORY}

浣跨敤鐨勮繛鎺ュ崗璁�銆�

路         --relative锛�-r

褰撳甫-I浣跨敤鏃舵樉绀哄綋鍓嶅拰鍓嶉潰鍊肩殑宸�鍒�銆傜洰鍓嶏紝璇ラ�夐」鍙�鐢ㄤ簬extended-status鍛戒护銆�

路         --silent锛�-s

濡傛灉涓嶈兘寤虹珛涓庢湇鍔″櫒鐨勮繛鎺ュ垯浠ユ矇榛樻柟寮忛��鍑恒��

路         --sleep=delay锛�-i delay

姣忕潯鐪�delay绉掑悗鎵ц�屼竴娆″懡浠ゃ��

路         --socket=path锛�-S path

鐢ㄤ簬杩炴帴鐨勫�楁帴瀛楁枃浠躲��

路         --user=user_name锛�-u user_name

褰撹繛鎺ユ湇鍔″櫒鏃朵娇鐢ㄧ殑MySQL鐢ㄦ埛鍚嶃��

路         --verbose锛�-v

鍐楅暱妯″紡銆傛墦鍗板嚭绋嬪簭鎿嶄綔鐨勮�︾粏淇℃伅銆�

路         --version锛�-V

鏄剧ず鐗堟湰淇℃伅骞堕��鍑恒��

路         --vertical锛�-E

鍨傜洿鎵撳嵃杈撳嚭銆傜被浼间簬--relative锛屼絾鍨傜洿鎵撳嵃杈撳嚭銆�

路         --wait[=count]锛�-w[count]

濡傛灉杩炴帴涓嶈兘寤虹珛锛岀瓑寰呭苟閲嶈瘯鑰屼笉鏄�鏀惧純銆傚�傛灉缁欏嚭涓�涓�閫夐」鍊硷紝鍒欐寚绀洪噸璇曠殑娆℃暟銆傞粯璁ゆ槸涓�娆°��

涔熷彲浠ヤ娇鐢�--var_name=value閫夐」璁剧疆涓嬮潰鐨勫彉閲忥細

路         connect_timeout

杩炴帴瓒呮椂涔嬪墠鐨勬渶澶х�掓暟銆傞粯璁ゅ�间负43200(12灏忔椂)銆�

路         shutdown_timeout

绛夊�欏叧闂�鐨勬渶澶х�掓暟銆傞粯璁ゅ�间负3600(1灏忔椂)銆�

涔熷彲浠ヤ娇鐢�--set-variable=var_name=value鎴�-O var_name=value璇�娉曟潵璁剧疆鍙橀噺銆傜劧鑰岋紝鐜板湪涓嶈禐鎴愯�ヨ��娉曪紝骞朵笖涓嶅啀浣跨敤銆�

鏈嶅姟鍣ㄧ敓鎴愮殑浜岃繘鍒舵棩蹇楁枃浠跺啓鎴愪簩杩涘埗鏍煎紡銆傝�佹兂妫�鏌ヨ繖浜涙枃鏈�鏍煎紡鐨勬枃浠讹紝搴斾娇鐢�mysqlbinlog瀹炵敤宸ュ叿銆�

搴旇繖鏍疯皟鐢�mysqlbinlog锛�

shell> mysqlbinlog [options] log-files...

渚嬪�傦紝瑕佹兂鏄剧ず浜岃繘鍒舵棩蹇�binlog.000003鐨勫唴瀹癸紝浣跨敤涓嬮潰鐨勫懡浠わ細

shell> mysqlbinlog binlog.0000003

杈撳嚭鍖呮嫭鍦�binlog.000003涓�鍖呭惈鐨勬墍鏈夎��鍙ワ紝浠ュ強鍏跺畠淇℃伅渚嬪�傛瘡涓�璇�鍙ヨ姳璐圭殑鏃堕棿銆佸�㈡埛鍙戝嚭鐨勭嚎绋�ID銆佸彂鍑虹嚎绋嬫椂鐨勬椂闂存埑绛夌瓑銆�

閫氬父鎯呭喌锛屽彲浠ヤ娇鐢�mysqlbinlog鐩存帴璇诲彇浜岃繘鍒舵棩蹇楁枃浠跺苟灏嗗畠浠�鐢ㄤ簬鏈�鍦�MySQL鏈嶅姟鍣ㄣ�備篃鍙�浠ヤ娇鐢�--read-from-remote-server閫夐」浠庤繙绋嬫湇鍔″櫒璇诲彇浜岃繘鍒舵棩蹇椼��

褰撹�诲彇杩滅▼浜岃繘鍒舵棩蹇楁椂锛屽彲浠ラ�氳繃杩炴帴鍙傛暟閫夐」鏉ユ寚绀哄�備綍杩炴帴鏈嶅姟鍣�锛屼絾瀹冧滑缁忓父琚�蹇界暐鎺夛紝闄ら潪浣犺繕鎸囧畾浜�--read-from-remote-server閫夐」銆傝繖浜涢�夐」鏄�--host銆�--password銆�--port銆�--protocol銆�--socket鍜�--user銆�

杩樺彲浠ヤ娇鐢�mysqlbinlog鏉ヨ�诲彇鍦ㄥ�嶅埗杩囩▼涓�浠庢湇鍔″櫒鎵�鍐欑殑涓�缁ф棩蹇楁枃浠躲�備腑缁ф棩蹇楁牸寮忎笌浜岃繘鍒舵棩蹇楁枃浠剁浉鍚屻��

鍦�5.11.3鑺傦紝鈥滀簩杩涘埗鏃ュ織鈥�涓�璇︾粏璁ㄨ�轰簡浜岃繘鍒舵棩蹇椼��

mysqlbinlog鏀�鎸佷笅闈㈢殑閫夐」锛�

路         ---help锛�-锛�

鏄剧ず甯�鍔╂秷鎭�骞堕��鍑恒��

路         ---database=db_name锛�-d db_name

鍙�鍒楀嚭璇ユ暟鎹�搴撶殑鏉＄洰(鍙�鐢ㄦ湰鍦版棩蹇�)銆�

路         --force-read锛�-f

浣跨敤璇ラ�夐」锛屽�傛灉mysqlbinlog璇诲畠涓嶈兘璇嗗埆鐨勪簩杩涘埗鏃ュ織浜嬩欢锛屽畠浼氭墦鍗拌�﹀憡锛屽拷鐣ヨ�ヤ簨浠跺苟缁х画銆傛病鏈夎�ラ�夐」锛屽�傛灉mysqlbinlog璇诲埌姝ょ被浜嬩欢鍒欏仠姝�銆�

路         --hexdump锛�-H

鍦ㄦ敞閲婁腑鏄剧ず鏃ュ織鐨勫崄鍏�杩涘埗杞�鍌ㄣ�傝�ヨ緭鍑哄彲浠ュ府鍔╁�嶅埗杩囩▼涓�鐨勮皟璇曘�傚湪MySQL 5.1.2涓�娣诲姞浜嗚�ラ�夐」銆�

路         --host=host_name锛�-h host_name

鑾峰彇缁欏畾涓绘満涓婄殑MySQL鏈嶅姟鍣ㄧ殑浜岃繘鍒舵棩蹇椼��

路         --local-load=path锛�-l pat

涓烘寚瀹氱洰褰曚腑鐨�LOAD DATA INFILE棰勫�勭悊鏈�鍦颁复鏃舵枃浠躲��

路         --offset=N锛�-o N

璺宠繃鍓�N涓�鏉＄洰銆�

路         --password[=password]锛�-p[password]

褰撹繛鎺ユ湇鍔″櫒鏃朵娇鐢ㄧ殑瀵嗙爜銆傚�傛灉浣跨敤鐭�閫夐」褰㈠紡(-p)锛岄�夐」鍜� 瀵嗙爜涔嬮棿涓嶈兘鏈夌┖鏍笺�傚�傛灉鍦ㄥ懡浠よ�屼腑--password鎴�-p閫夐」鍚庨潰娌℃湁 瀵嗙爜鍊硷紝鍒欐彁绀鸿緭鍏ヤ竴涓�瀵嗙爜銆�

路         --port=port_num锛�-P port_num

鐢ㄤ簬杩炴帴杩滅▼鏈嶅姟鍣ㄧ殑TCP/IP绔�鍙ｅ彿銆�

路         --position=N锛�-j N

涓嶈禐鎴愪娇鐢�锛屽簲浣跨敤--start-position銆�

路         --protocol={TCP | SOCKET | PIPE | -position

浣跨敤鐨勮繛鎺ュ崗璁�銆�

路         --read-from-remote-server锛�-R

浠�MySQL鏈嶅姟鍣ㄨ�讳簩杩涘埗鏃ュ織銆傚�傛灉鏈�缁欏嚭璇ラ�夐」锛屼换浣曡繛鎺ュ弬鏁伴�夐」灏嗚��蹇界暐銆傝繖浜涢�夐」鏄�--host銆�--password銆�--port銆�--protocol銆�--socket鍜�--user銆�

路         --result-file=name, -r name

灏嗚緭鍑烘寚鍚戠粰瀹氱殑鏂囦欢銆�

路         --short-form锛�-s

鍙�鏄剧ず鏃ュ織涓�鍖呭惈鐨勮��鍙ワ紝涓嶆樉绀哄叾瀹冧俊鎭�銆�

路         --socket=path锛�-S path

鐢ㄤ簬杩炴帴鐨勫�楁帴瀛楁枃浠躲��

路         --start-datetime=datetime

浠庝簩杩涘埗鏃ュ織涓�绗�1涓�鏃ユ湡鏃堕棿绛変簬鎴栨櫄浜�datetime鍙傞噺鐨勪簨浠跺紑濮嬭�诲彇銆�datetime鍊肩浉瀵逛簬杩愯��mysqlbinlog鐨勬満鍣ㄤ笂鐨勬湰鍦版椂鍖�銆�璇�鍊兼牸寮忓簲绗﹀悎DATETIME鎴�TIMESTAMP鏁版嵁绫诲瀷銆備緥濡傦細

shell> mysqlbinlog --start-datetime="2004-12-25 11:25:56" binlog.000003

璇ラ�夐」鍙�浠ュ府鍔╃偣瀵圭偣鎭㈠�嶃��

路         --stop-datetime=datetime

浠庝簩杩涘埗鏃ュ織涓�绗�1涓�鏃ユ湡鏃堕棿绛変簬鎴栨櫄浜�datetime鍙傞噺鐨勪簨浠惰捣鍋滄�㈣�汇�傚叧浜�datetime鍊肩殑鎻忚堪鍙傝��--start-datetime閫夐」銆傝�ラ�夐」鍙�浠ュ府鍔╁強鏃舵仮澶嶃��

路         --start-position=N

浠庝簩杩涘埗鏃ュ織涓�绗�1涓�浣嶇疆绛変簬N鍙傞噺鏃剁殑浜嬩欢寮�濮嬭�汇��

路         --stop-position=N

浠庝簩杩涘埗鏃ュ織涓�绗�1涓�浣嶇疆绛変簬鍜屽ぇ浜�N鍙傞噺鏃剁殑浜嬩欢璧峰仠姝㈣�汇��

路         --to-last-logs锛�-t

鍦�MySQL鏈嶅姟鍣ㄤ腑璇锋眰鐨勪簩杩涘埗鏃ュ織鐨勭粨灏惧�勪笉鍋滄��锛岃�屾槸缁х画鎵撳嵃鐩村埌鏈�鍚庝竴涓�浜岃繘鍒舵棩蹇楃殑缁撳熬銆傚�傛灉灏嗚緭鍑哄彂閫佺粰鍚屼竴鍙�MySQL鏈嶅姟鍣�锛屼細瀵艰嚧鏃犻檺寰�鐜�銆傝�ラ�夐」瑕佹眰--read-from-remote-server銆�

路         --disable-logs-bin锛�-D

绂佺敤浜岃繘鍒舵棩蹇椼�傚�傛灉浣跨敤--to-last-logs閫夐」灏嗚緭鍑哄彂閫佺粰鍚屼竴鍙�MySQL鏈嶅姟鍣�锛屽彲浠ラ伩鍏嶆棤闄愬惊鐜�銆傝�ラ�夐」鍦ㄥ穿婧冩仮澶嶆椂涔熷緢鏈夌敤锛屽彲浠ラ伩鍏嶅�嶅埗宸茬粡璁板綍鐨勮��鍙ャ��娉ㄩ噴锛�璇ラ�夐」瑕佹眰鏈�SUPER鏉冮檺銆�

路         --user=user_name锛�-u user_name

杩炴帴杩滅▼鏈嶅姟鍣ㄦ椂浣跨敤鐨�MySQL鐢ㄦ埛鍚嶃��

路         --version锛�-V

鏄剧ず鐗堟湰淇℃伅骞堕��鍑恒��

杩樺彲浠ヤ娇鐢�--var_name=value閫夐」璁剧疆涓嬮潰鐨勫彉閲忥細

路         open_files_limit

鎸囧畾瑕佷繚鐣欑殑鎵撳紑鐨勬枃浠舵弿杩扮�︾殑鏁伴噺銆�

鍙�浠ュ皢mysqlbinlog鐨勮緭鍑轰紶鍒�mysql瀹㈡埛绔�浠ユ墽琛屽寘鍚�鍦ㄤ簩杩涘埗鏃ュ織涓�鐨勮��鍙ャ�傚�傛灉浣犳湁涓�涓�鏃х殑澶囦唤锛岃�ラ�夐」鍦ㄥ穿婧冩仮澶嶆椂涔熷緢鏈夌敤(鍙傝��5.9.1鑺傦紝鈥滄暟鎹�搴撳�囦唤鈥�)锛�

shell> mysqlbinlog hostname-bin.000001 | mysql

鎴栵細

shell> mysqlbinlog hostname-bin.[0-9]* | mysql

濡傛灉浣犻渶瑕佸厛淇�鏀瑰惈璇�鍙ョ殑鏃ュ織锛岃繕鍙�浠ュ皢mysqlbinlog鐨勮緭鍑洪噸鏂版寚鍚戜竴涓�鏂囨湰鏂囦欢銆�(渚嬪�傦紝鎯冲垹闄ょ敱浜庢煇绉嶅師鍥犺�屼笉鎯虫墽琛岀殑璇�鍙�)銆傜紪杈戝ソ鏂囦欢鍚庯紝灏嗗畠杈撳叆鍒�mysql绋嬪簭骞舵墽琛屽畠鍖呭惈鐨勮��鍙ャ��

mysqlbinlog鏈変竴涓�--position閫夐」锛屽彧鎵撳嵃閭ｄ簺鍦ㄤ簩杩涘埗鏃ュ織涓�鐨勫亸绉婚噺澶т簬鎴栫瓑浜庢煇涓�缁欏畾浣嶇疆鐨勮��鍙�(缁欏嚭鐨勪綅缃�蹇呴』鍖归厤涓�涓�浜嬩欢鐨勫紑濮�)銆傚畠杩樻湁鍦ㄧ湅瑙佺粰瀹氭棩鏈熷拰鏃堕棿鐨勪簨浠跺悗鍋滄�㈡垨鍚�鍔ㄧ殑閫夐」銆傝繖鏍峰彲浠ヤ娇鐢�--stop-datetime閫夐」杩涜�岀偣瀵圭偣鎭㈠��(渚嬪�傦紝鑳藉�熻�粹�滃皢鏁版嵁搴撳墠婊氬姩鍒颁粖澶�10:30 AM鐨勪綅缃�鈥�)銆�

濡傛灉MySQL鏈嶅姟鍣ㄤ笂鏈夊�氫釜瑕佹墽琛岀殑浜岃繘鍒舵棩蹇楋紝瀹夊叏鐨勬柟娉曟槸鍦ㄤ竴涓�杩炴帴涓�澶勭悊瀹冧滑銆備笅闈㈡槸涓�涓�璇存槑浠�涔堟槸涓嶅畨鍏�鐨勪緥瀛愶細

shell> mysqlbinlog hostname-bin.000001 | mysql # DANGER!!

shell> mysqlbinlog hostname-bin.000002 | mysql # DANGER!!

浣跨敤涓庢湇鍔″櫒鐨勪笉鍚岃繛鎺ユ潵澶勭悊浜岃繘鍒舵棩蹇楁椂锛屽�傛灉绗�1涓�鏃ュ織鏂囦欢鍖呭惈涓�涓�CREATE TEMPORARY TABLE璇�鍙ワ紝绗�2涓�鏃ュ織鍖呭惈涓�涓�浣跨敤璇ヤ复鏃惰〃鐨勮��鍙ワ紝鍒欎細閫犳垚闂�棰樸�傚綋绗�1涓�mysql杩涚▼缁撴潫鏃讹紝鏈嶅姟鍣ㄦ挙閿�涓存椂琛ㄣ�傚綋绗�2涓�mysql杩涚▼鎯充娇鐢ㄨ�ヨ〃鏃讹紝鏈嶅姟鍣ㄦ姤鍛� 鈥滀笉鐭ラ亾璇�琛�鈥濄��

瑕佹兂閬垮厤姝ょ被闂�棰橈紝浣跨敤涓�涓�杩炴帴鏉ユ墽琛屾兂瑕佸�勭悊鐨勬墍鏈変簩杩涘埗鏃ュ織涓�鐨勫唴瀹广�備笅闈㈡彁渚涗簡涓�绉嶆柟娉曪細

shell> mysqlbinlog hostname-bin.000001 hostname-bin.000002 | mysql

鍙︿竴涓�鏂规硶鏄�锛�

shell> mysqlbinlog hostname-bin.000001 >  /tmp/statements.sql

shell> mysqlbinlog hostname-bin.000002 >> /tmp/statements.sql

shell> mysql -e "source /tmp/statements.sql"

mysqlbinlog浜х敓鐨勮緭鍑哄彲浠ヤ笉闇�瑕佸師鏁版嵁鏂囦欢鍗冲彲閲嶆柊鐢熸垚涓�涓�LOAD DATA INFILE鎿嶄綔銆�mysqlbinlog灏嗘暟鎹�澶嶅埗鍒颁竴涓�涓存椂鏂囦欢骞跺啓涓�涓�寮曠敤璇ユ枃浠剁殑LOAD DATA LOCAL INFILE璇�鍙ャ�傜敱绯荤粺纭�瀹氬啓鍏ヨ繖浜涙枃浠剁殑鐩�褰曠殑榛樿�や綅缃�銆傝�佹兂鏄惧紡鎸囧畾涓�涓�鐩�褰曪紝浣跨敤--local-load閫夐」銆�

鍥犱负mysqlbinlog鍙�浠ュ皢LOAD DATA INFILE璇�鍙ヨ浆鎹�涓�LOAD DATA LOCAL INFILE璇�鍙�(涔熷氨鏄�璇达紝瀹冩坊鍔犱簡LOCAL)锛岀敤浜庡�勭悊璇�鍙ョ殑瀹㈡埛绔�鍜屾湇鍔″櫒蹇呴』閰嶇疆涓哄厑璁�LOCAL鎿嶄綔銆傚弬瑙�5.6.4鑺傦紝鈥淟OAD DATA LOCAL瀹夊叏闂�棰�鈥�銆�

璀﹀憡锛�涓�LOAD DATA LOCAL璇�鍙ュ垱寤虹殑涓存椂鏂囦欢涓嶄細鑷�鍔ㄥ垹闄わ紝鍥犱负鍦ㄥ疄闄呮墽琛屽畬閭ｄ簺璇�鍙ュ墠闇�瑕佸畠浠�銆備笉鍐嶉渶瑕佽��鍙ユ棩蹇楀悗搴旇嚜宸卞垹闄や复鏃舵枃浠躲�傛枃浠朵綅浜庝复鏃舵枃浠剁洰褰曚腑锛屾枃浠跺悕绫讳技original_file_name-#-#銆�

--hexdump閫夐」鍙�浠ュ湪娉ㄩ噴涓�浜х敓鏃ュ織鍐呭�圭殑鍗佸叚杩涘埗杞�鍌�锛�

shell> mysqlbinlog --hexdump master-bin.000001

涓婅堪鍛戒护鐨勮緭鍑哄簲绫讳技锛�

/*!40019 SET @@session.max_insert_delayed_threads=0*/;

/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;

# at 4

#051024 17:24:13 server id 1  end_log_pos 98

# Position  Timestamp   Type   Master ID        Size      Master Pos    Flags

# 00000004 9d fc 5c 43   0f   01 00 00 00   5e 00 00 00   62 00 00 00   00 00

# 00000017 04 00 35 2e 30 2e 31 35  2d 64 65 62 75 67 2d 6c |..5.0.15.debug.l|

# 00000027 6f 67 00 00 00 00 00 00  00 00 00 00 00 00 00 00 |og..............|

# 00000037 00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00 |................|

# 00000047 00 00 00 00 9d fc 5c 43  13 38 0d 00 08 00 12 00 |.......C.8......|

# 00000057 04 04 04 04 12 00 00 4b  00 04 1a                |.......K...|

#       Start: binlog v 4, server v 5.0.15-debug-log created 051024 17:24:13

#       at startup

ROLLBACK;

鍗佸叚杩涘埗杞�鍌ㄧ殑杈撳嚭鍖呭惈涓嬮潰鐨勫厓绱狅細

路         Position: The byte position within the log file.

路         Timestamp: The event timestamp. In the example just shown, '9d fc 5c 43' is the representation of '051024 17:24:13' in hexadecimal.

路         Type: The type of the log event. '0f' means that the example event is a FORMAT_DESCRIPTION_EVENT. The types are:

路                00  UNKNOWN_EVENT

路                    This event should never be present in the log.

路                01  START_EVENT_V3

路                    This indicates the start of a log file written by MySQL 4 or earlier.

路                02  QUERY_EVENT

路                    The most common type of events.  These contain queries executed

路                    on the master.

路                03  STOP_EVENT

路                    Indicates that master has stopped.

路                04  ROTATE_EVENT

路                    Written when the master switches to a new log file.

路                05  INTVAR_EVENT

路                    Used mainly for AUTO_INCREMENT values and if the LAST_INSERT_ID()

路                    function is used in the statement.

路                06  LOAD_EVENT

路                    Used for LOAD DATA INFILE in MySQL 3.23.

路                07  SLAVE_EVENT

路                    Reserved for future use.

路                08  CREATE_FILE_EVENT

路                    Used for LOAD DATA INFILE statements.  This indicates the start

路                    of execution of such a statement.  A temporary file is created

路                    on the slave.  Used in MySQL 4 only.

路                09  APPEND_BLOCK_EVENT

路                    Contains data for use in a LOAD DATA INFILE statement.  The

路                    data is stored in the temporary file on the slave.

路                0a  EXEC_LOAD_EVENT

路                    Used for LOAD DATA INFILE statements.  The contents of the

路                    temporary file is stored in the table on the slave.

路                    Used in MySQL 4 only.

路                0b  DELETE_FILE_EVENT

路                    Rollback of LOAD DATA INFILE statement.  The temporary file

路                    should be deleted on slave.

路                0c  NEW_LOAD_EVENT

路                    Used for LOAD DATA INFILE in MySQL 4 and earlier.

路                0d  RAND_EVENT

路                    Used to send information about random values if the RAND()

路                    function is used in the query.

路                0e  USER_VAR_EVENT

路                    Used to replicate user variables.

路                0f  FORMAT_DESCRIPTION_EVENT

路                    This indicates the start of a log file written by MySQL 5 or later.

路                10  XID_EVENT

路                    Event indicating commit of XA transaction

路                11  BEGIN_LOAD_QUERY_EVENT

路                    Used for LOAD DATA statements in MySQL 5 and later.

路                12  EXECUTE_LOAD_QUERY_EVENT

路                    Used for LOAD DATA statements in MySQL 5 and later.

路                13  TABLE_MAP_EVENT

路                    Reserved for future use

路                14  WRITE_ROWS_EVENT

路                    Reserved for future use

路                15  UPDATE_ROWS_EVENT

路                    Reserved for future use

路                16  DELETE_ROWS_EVENT

路                    Reserved for future use

路         Master ID: The server id of the master that created the event.

路         Size: The size in bytes of the event.

路         Master Pos: The position of the event in the original master log file.

路         Flags: 16 flags.

路                01  LOG_EVENT_BINLOG_IN_USE_F

路                    Log file correctly closed (Used only in FORMAT_DESCRIPTION_EVENT)

路                    If this flag is set (if the flags are e.g. '01 00') in an

路                    FORMAT_DESCRIPTION_EVENT, then the log file has not been

路                    properly closed.  Most probably because of a master crash (for

路                    example, due to power failure).

路                02  Reserved for future use.

路                04  LOG_EVENT_THREAD_SPECIFIC_F

路                    Set if the event is dependent on the connection it was

路                    executed in (example '04 00'), e.g. if the event uses

路                    temporary tables.

路                08  LOG_EVENT_SUPPRESS_USE_F

路                    Set in some circumstances when the event is not dependent on

路                    the current database

鍏跺畠鏍囧織淇濈暀鐢ㄤ簬灏嗘潵浣跨敤銆�

鍦ㄤ互鍚庣殑鐗堟湰涓�鍗佸叚杩涘埗杞�鍌ㄨ緭鍑虹殑鏍煎紡鍙�鑳戒細鏀瑰彉銆�

mysqlcheck瀹㈡埛绔�鍙�浠ユ��鏌ュ拰淇�澶�MyISAM琛ㄣ�傚畠杩樺彲浠ヤ紭鍖栧拰鍒嗘瀽琛ㄣ��

mysqlcheck鐨勫姛鑳界被浼�myisamchk锛屼絾鍏跺伐浣滀笉鍚屻�備富瑕佸樊鍒�鏄�褰�mysqld鏈嶅姟鍣ㄥ湪杩愯�屾椂蹇呴』浣跨敤mysqlcheck锛岃��myisamchk搴旂敤浜庢湇鍔″櫒娌℃湁杩愯�屾椂銆備娇鐢�mysqlcheck鐨�濂藉�勬槸涓嶉渶瑕佸仠姝㈡湇鍔″櫒鏉ユ��鏌ユ垨淇�澶嶈〃銆�

Mysqlcheck涓虹敤鎴锋彁渚涗簡涓�绉嶆柟渚跨殑浣跨敤SQL璇�鍙�CHECK TABLE銆�REPAIR TABLE銆�ANALYZE TABLE鍜�OPTIMIZE TABLE鐨勬柟寮忋�傚畠纭�瀹氬湪瑕佹墽琛岀殑鎿嶄綔涓�浣跨敤浣跨敤鍝�涓�璇�鍙ワ紝鐒跺悗灏嗚��鍙ュ彂閫佸埌瑕佹墽琛岀殑鏈嶅姟鍣ㄤ笂銆�

鏈�3绉嶆柟寮忔潵璋冪敤mysqlcheck锛�

shell> mysqlcheck[options] db_name [tables]

shell> mysqlcheck[options] ---database DB1 [DB2 DB3...]

shell> mysqlcheck[options] --all--database

濡傛灉娌℃湁鎸囧畾浠讳綍琛ㄦ垨浣跨敤---database鎴�--all--database閫夐」锛屽垯妫�鏌ユ暣涓�鏁版嵁搴撱��

鍚屽叾瀹冨�㈡埛绔�姣旇緝锛�mysqlcheck鏈変竴涓�鐗规畩鐗规�с�傞噸鏂板懡鍚嶄簩杩涘埗鍙�浠ユ洿鏀规��鏌ヨ〃鐨勯粯璁よ�屼负(--check)銆傚�傛灉浣犳兂瑕佷竴涓�宸ュ叿榛樿�ゅ彲浠ヤ慨澶嶈〃鐨勫伐鍏凤紝鍙�闇�瑕佸皢mysqlcheck閲嶆柊澶嶅埗涓�mysqlrepair锛屾垨鑰呬娇鐢ㄤ竴涓�绗﹀彿閾炬帴mysqlrepair閾炬帴mysqlcheck銆傚�傛灉璋冪敤mysqlrepair锛屽彲鎸夌収鍛戒护淇�澶嶈〃銆�

涓嬮潰鐨勫悕鍙�鐢ㄦ潵鏇存敼mysqlcheck鐨勯粯璁よ�屼负锛�

mysqlcheck鏀�鎸佷笅闈㈢殑閫夐」锛�

路         ---help锛�-锛�

鏄剧ず甯�鍔╂秷鎭�骞堕��鍑恒��

路         --all--database锛�-A

妫�鏌ユ墍鏈夋暟鎹�搴撲腑鐨勬墍鏈夎〃銆備笌浣跨敤---database閫夐」鐩稿悓锛屽湪鍛戒护琛屼腑鍛藉悕鎵�鏈夋暟鎹�搴撱��

路         --all-in-1锛�-1

涓嶆槸涓烘瘡涓�琛ㄥ彂鍑轰竴涓�璇�鍙ワ紝鑰屾槸涓哄懡鍚嶆暟鎹�搴撲腑寰呭�勭悊鐨勬墍鏈夎〃鐨勬瘡涓�鏁版嵁搴撴墽琛屼竴涓�璇�鍙ャ��

路         --analyze锛�-a

鍒嗘瀽琛ㄣ��

路         --auto-repair

濡傛灉鏌愪釜琚�妫�鏌ョ殑琛ㄧ牬鍧忎簡锛岃嚜鍔ㄤ慨澶嶅畠銆傛��鏌ュ畬鎵�鏈夎〃鍚庤嚜鍔ㄨ繘琛屾墍鏈夐渶瑕佺殑淇�澶嶃��

路         --character-sets-dir=path

瀛楃�﹂泦鐨勫畨瑁呯洰褰曘�傚弬瑙�5.10.1鑺傦紝鈥滄暟鎹�鍜屾帓搴忕敤瀛楃�﹂泦鈥�銆�

路         --check锛�-c

妫�鏌ヨ〃鐨勯敊璇�銆�

路         --check-only-changed锛�-C

鍙�妫�鏌ヤ笂娆℃��鏌ヤ互鏉ュ凡缁忔洿鏀圭殑鎴栨病鏈夋�ｇ‘鍏抽棴鐨勮〃銆�

路         --compress

鍘嬬缉鍦ㄥ�㈡埛绔�鍜屾湇鍔″櫒涔嬮棿鍙戦�佺殑鎵�鏈変俊鎭�锛堝�傛灉浜岃�呭潎鏀�鎸佸帇缂╋級銆�

路         ---database锛�-B

澶勭悊鏁版嵁搴撲腑鍛藉悕鐨勬墍鏈夎〃銆備娇鐢ㄨ�ラ�夐」锛屾墍鏈夊瓧鍚嶅弬閲忚��鐪嬩綔鏁版嵁搴撳悕锛岃�屼笉鏄�琛ㄥ悕銆�

路         ---debug[=debug_options]锛�-# [debug_options]

鍐欒皟璇曟棩蹇椼��debug_options瀛楃�︿覆閫氬父涓�'d:t:o,file_name'銆�

路         --default-character-set=charset

浣跨敤charsetas榛樿�ゅ瓧绗﹂泦銆傚弬瑙�5.10.1鑺傦紝鈥滄暟鎹�鍜屾帓搴忕敤瀛楃�﹂泦鈥�銆�

路         --extended锛�-e

濡傛灉浣犳�ｄ娇鐢ㄨ�ラ�夐」鏉ユ��鏌ヨ〃锛屽彲浠ョ‘淇濆畠浠�100%鍦颁竴鑷达紝浣嗛渶瑕佸緢闀跨殑鏃堕棿銆�

濡傛灉浣犳�ｄ娇鐢ㄨ�ラ�夐」鏉ヤ慨澶嶈〃锛屽垯杩愯�屾墿灞曚慨澶嶏紝涓嶄絾鎵ц�岀殑鏃堕棿寰堥暱锛岃�屼笖杩樹細浜х敓澶ч噺鐨勫瀮鍦捐��!

路         --fast锛�-F

鍙�妫�鏌ユ病鏈夋�ｇ‘鍏抽棴鐨勮〃銆�

路         --force锛�-f

鍗充娇鍑虹幇SQL閿欒��涔熺户缁�銆�

路         --host=host_name锛�-h host_name

杩炴帴缁欏畾涓绘満涓婄殑MySQL鏈嶅姟鍣ㄣ��

路         --medium-check锛�-m

鎵ц�屾瘮--extended鎿嶄綔鏇村揩鐨勬��鏌ャ�傚彧鑳藉彂鐜�99.99%鐨勯敊璇�锛屽湪澶у�氭暟鎯呭喌涓嬭繖宸茬粡瓒冲�熶簡銆�

路         --optimize锛�-o

浼樺寲琛ㄣ��

路         --password[=password]锛�-p[password]

褰撹繛鎺ユ湇鍔″櫒鏃朵娇鐢ㄧ殑瀵嗙爜銆傚�傛灉浣跨敤鐭�閫夐」褰㈠紡(-p)锛岄�夐」鍜� 瀵嗙爜涔嬮棿涓嶈兘鏈夌┖鏍笺�傚�傛灉鍦ㄥ懡浠よ�屼腑--password鎴�-p閫夐」鍚庨潰娌℃湁 瀵嗙爜鍊硷紝鍒欐彁绀鸿緭鍏ヤ竴涓�瀵嗙爜銆�

路         --port=port_num锛�-P port_num

鐢ㄤ簬杩炴帴鐨�TCP/IP绔�鍙ｅ彿銆�

路         --protocol={TCP | SOCKET | PIPE | MEMORY}

浣跨敤鐨勮繛鎺ュ崗璁�銆�

路         --quick锛�-q

濡傛灉浣犳�ｄ娇鐢ㄨ�ラ�夐」鍦ㄦ��鏌ヨ〃锛屽畠闃叉�㈡壂鎻忚�屼互妫�鏌ラ敊璇�閾炬帴鐨勬��鏌ャ�傝繖鏄�鏈�蹇�鐨勬��鏌ユ柟娉曘��

濡傛灉浣犳�ｄ娇鐢ㄨ�ラ�夐」鍦ㄤ慨澶嶈〃锛屽畠灏濊瘯鍙�淇�澶嶇储寮曟爲銆傝繖鏄�鏈�蹇�鐨勪慨澶嶆柟娉曘��

路         --repair锛�-r

鎵ц�屽彲浠ヤ慨澶嶅ぇ閮ㄥ垎闂�棰樼殑淇�澶嶏紝鍙�鏄�鍞�涓�鍊间笉鍞�涓�鏃朵笉鑳戒慨澶嶃��

路         --silent锛�-s

娌夐粯妯″紡銆傚彧鎵撳嵃閿欒��娑堟伅銆�

路         --socket=path锛�-S path

鐢ㄤ簬杩炴帴鐨勫�楁帴瀛楁枃浠躲��

路         --tables

瑕嗙洊---database鎴�-B閫夐」銆傞�夐」鍚庨潰鐨勬墍鏈夊弬閲忚��瑙嗕负琛ㄥ悕銆�

路         --user=user_name锛�-u user_name

褰撹繛鎺ユ湇鍔″櫒鏃朵娇鐢ㄧ殑MySQL鐢ㄦ埛鍚嶃��

路         --verbose锛�-v

鍐楅暱妯″紡銆傛墦鍗板叧浜庡悇闃舵�电▼搴忔搷浣滅殑淇℃伅銆�

路         --version锛�-V

鏄剧ず鐗堟湰淇℃伅骞堕��鍑恒��

mysqldump瀹㈡埛绔�鍙�鐢ㄦ潵杞�鍌ㄦ暟鎹�搴撴垨鎼滈泦鏁版嵁搴撹繘琛屽�囦唤鎴栧皢鏁版嵁杞�绉诲埌鍙︿竴涓�SQL鏈嶅姟鍣�(涓嶄竴瀹氭槸涓�涓�MySQL鏈嶅姟鍣�)銆傝浆鍌ㄥ寘鍚�鍒涘缓琛ㄥ拰/鎴栬�呰浇琛ㄧ殑SQL璇�鍙ャ��

濡傛灉浣犲湪鏈嶅姟鍣ㄤ笂杩涜�屽�囦唤锛屽苟涓旇〃鍧囦负MyISAM琛�锛屽簲鑰冭檻浣跨敤mysqlhotcopy锛屽洜涓哄彲浠ユ洿蹇�鍦拌繘琛屽�囦唤鍜屾仮澶嶃�傚弬瑙�8.9鑺傦紝鈥渕ysqlhotcopy锛氭暟鎹�搴撳�囦唤绋嬪簭鈥�銆�

鏈�3绉嶆柟寮忔潵璋冪敤mysqldump锛�

shell> mysqldump [options] db_name [tables]

shell> mysqldump [options] ---database DB1 [DB2 DB3...]

shell> mysqldump [options] --all--database

濡傛灉娌℃湁鎸囧畾浠讳綍琛ㄦ垨浣跨敤浜�---database鎴�--all--database閫夐」锛屽垯杞�鍌ㄦ暣涓�鏁版嵁搴撱��

瑕佹兂鑾峰緱浣犵殑鐗堟湰鐨�mysqldump鏀�鎸佺殑閫夐」锛屾墽琛�mysqldump ---help銆�

濡傛灉杩愯��mysqldump娌℃湁--quick鎴�--opt閫夐」锛�mysqldump鍦ㄨ浆鍌ㄧ粨鏋滃墠灏嗘暣涓�缁撴灉闆嗚�呭叆鍐呭瓨銆傚�傛灉杞�鍌ㄥぇ鏁版嵁搴撳彲鑳戒細鍑虹幇闂�棰樸�傝�ラ�夐」榛樿�ゅ惎鐢�锛屼絾鍙�浠ョ敤--skip-opt绂佺敤銆�

濡傛灉浣跨敤鏈�鏂扮増鏈�鐨�mysqldump绋嬪簭鐢熸垚涓�涓�杞�鍌ㄩ噸瑁呭埌寰堟棫鐗堟湰鐨�MySQL鏈嶅姟鍣ㄤ腑锛屼笉搴斾娇鐢�--opt鎴�-e閫夐」銆�

mysqldump鏀�鎸佷笅闈㈢殑閫夐」锛�

路         ---help锛�-锛�

鏄剧ず甯�鍔╂秷鎭�骞堕��鍑恒��

路         --add-drop--database

鍦ㄦ瘡涓�CREATE DATABASE璇�鍙ュ墠娣诲姞DROP DATABASE璇�鍙ャ��

路         --add-drop-tables

鍦ㄦ瘡涓�CREATE TABLE璇�鍙ュ墠娣诲姞DROP TABLE璇�鍙ャ��

路         --add-locking

鐢�LOCK TABLES鍜�UNLOCK TABLES璇�鍙ュ紩鐢ㄦ瘡涓�琛ㄨ浆鍌ㄣ�傞噸杞借浆鍌ㄦ枃浠舵椂鎻掑叆寰楁洿蹇�銆傚弬瑙�7.2.16鑺傦紝鈥淚NSERT璇�鍙ョ殑閫熷害鈥�銆�

路         --all--database锛�-A

杞�鍌ㄦ墍鏈夋暟鎹�搴撲腑鐨勬墍鏈夎〃銆備笌浣跨敤---database閫夐」鐩稿悓锛屽湪鍛戒护琛屼腑鍛藉悕鎵�鏈夋暟鎹�搴撱��

路         --allow-keywords

鍏佽�稿垱寤哄叧閿�瀛楀垪鍚嶃�傚簲鍦ㄦ瘡涓�鍒楀悕鍓嶉潰鍔犱笂琛ㄥ悕鍓嶇紑銆�

路         ---comments[={0|1}]

濡傛灉璁剧疆涓� 0锛岀�佹�㈣浆鍌ㄦ枃浠朵腑鐨勫叾瀹冧俊鎭�锛屼緥濡傜▼搴忕増鏈�銆佹湇鍔″櫒鐗堟湰鍜屼富鏈恒��--skip鈥�comments涓�---comments=0鐨勭粨鏋滅浉鍚屻�� 榛樿�ゅ�间负1锛屽嵆鍖呮嫭棰濆�栦俊鎭�銆�

路         --compact

浜х敓灏戦噺杈撳嚭銆傝�ラ�夐」绂佺敤娉ㄩ噴骞跺惎鐢�--skip-add-drop-tables銆�--no-set-names銆�--skip-disable-keys鍜�--skip-add-locking閫夐」銆�

路         --compatible=name

浜х敓涓庡叾瀹冩暟鎹�搴撶郴缁熸垨鏃х殑MySQL鏈嶅姟鍣ㄦ洿鍏煎�圭殑杈撳嚭銆傚�煎彲浠ヤ负ansi銆�mysql323銆�mysql40銆�postgresql銆�oracle銆�mssql銆�db2銆�maxdb銆�no_key_options銆�no_tables_options鎴栬��no_field_options銆傝�佷娇鐢ㄥ嚑涓�鍊硷紝鐢ㄩ�楀彿灏嗗畠浠�闅斿紑銆傝繖浜涘�间笌璁剧疆鏈嶅姟鍣�SQL妯″紡鐨勭浉搴旈�夐」鏈夌浉鍚岀殑鍚�涔夈�傚弬瑙�5.3.2鑺傦紝鈥淪QL鏈嶅姟鍣ㄦā寮忊��銆�

璇ラ�夐」涓嶈兘淇濊瘉鍚屽叾瀹冩湇鍔″櫒涔嬮棿鐨勫吋瀹规�с�傚畠鍙�鍚�鐢ㄩ偅浜涚洰鍓嶈兘澶熶娇杞�鍌ㄨ緭鍑烘洿鍏煎�圭殑SQL妯″紡鍊笺�備緥濡傦紝--compatible=oracle 涓嶆槧灏�Oracle绫诲瀷鎴栦娇鐢�Oracle娉ㄩ噴璇�娉曠殑鏁版嵁绫诲瀷銆�

路         --complete-insert锛�-c

浣跨敤鍖呮嫭鍒楀悕鐨勫畬鏁寸殑INSERT璇�鍙ャ��

路         --compress锛�-C

鍘嬬缉鍦ㄥ�㈡埛绔�鍜屾湇鍔″櫒涔嬮棿鍙戦�佺殑鎵�鏈変俊鎭�锛堝�傛灉浜岃�呭潎鏀�鎸佸帇缂╋級銆�

路         --create-option

鍦�CREATE TABLE璇�鍙ヤ腑鍖呮嫭鎵�鏈�MySQL琛ㄩ�夐」銆�

路         ---database锛�-B

杞�鍌ㄥ嚑涓�鏁版嵁搴撱�傞�氬父鎯呭喌锛�mysqldump灏嗗懡浠よ�屼腑鐨勭��1涓�鍚嶅瓧鍙傞噺鐪嬩綔鏁版嵁搴撳悕锛屽悗闈㈢殑鍚嶇湅浣滆〃鍚嶃�備娇鐢ㄨ�ラ�夐」锛屽畠灏嗘墍鏈夊悕瀛楀弬閲忕湅浣滄暟鎹�搴撳悕銆�CREATE DATABASE IF NOT EXISTS db_name鍜�USE db_name璇�鍙ュ寘鍚�鍦ㄦ瘡涓�鏂版暟鎹�搴撳墠鐨勮緭鍑轰腑銆�

路         ---debug[=debug_options]锛�-# [debug_options]

鍐欒皟璇曟棩蹇椼��debug_options瀛楃�︿覆閫氬父涓�'d:t:o,file_name'銆�

路         --default-character-set=charset

浣跨敤charsetas榛樿�ゅ瓧绗﹂泦銆傚弬瑙�5.10.1鑺傦紝鈥滄暟鎹�鍜屾帓搴忕敤瀛楃�﹂泦鈥�銆傚�傛灉娌℃湁鎸囧畾锛�mysqldump浣跨敤utf8銆�

路         --delayed-insert

浣跨敤INSERT DELAYED璇�鍙ユ彃鍏ヨ�屻��

路         --delete-master-logs

鍦ㄤ富澶嶅埗鏈嶅姟鍣ㄤ笂锛屽畬鎴愯浆鍌ㄦ搷浣滃悗鍒犻櫎浜岃繘鍒舵棩蹇椼�傝�ラ�夐」鑷�鍔ㄥ惎鐢�--master-data銆�

路         --disable-keys锛�-K

瀵逛簬姣忎釜琛�锛岀敤/*!40000 ALTER TABLE tbl_name DISABLE KEYS */;鍜�/*!40000 ALTER TABLE tbl_name ENABLE KEYS */;璇�鍙ュ紩鐢�INSERT璇�鍙ャ�傝繖鏍峰彲浠ユ洿蹇�鍦拌�呰浇杞�鍌ㄦ枃浠讹紝鍥犱负鍦ㄦ彃鍏ユ墍鏈夎�屽悗鍒涘缓绱㈠紩銆傝�ラ�夐」鍙�閫傚悎MyISAM琛ㄣ��

路         --extended-insert锛�-e

浣跨敤鍖呮嫭鍑犱釜VALUES鍒楄〃鐨勫�氳��INSERT璇�娉曘�傝繖鏍蜂娇杞�鍌ㄦ枃浠舵洿灏忥紝閲嶈浇鏂囦欢鏃跺彲浠ュ姞閫熸彃鍏ャ��

路         --fields-terminated-by=...锛�--fields-enclosed-by=...锛�--fields-optionally-enclosed-by=...锛�--fields-escaped-by=...锛�--琛�-terminated-by=...

杩欎簺閫夐」缁撳悎-T閫夐」浣跨敤锛屼笌LOAD DATA INFILE鐨勭浉搴斿瓙鍙ユ湁鐩稿悓鐨勫惈涔夈�傚弬瑙�13.2.5鑺傦紝鈥淟OAD DATA INFILE璇�娉曗��銆�

路         --first-slave锛�-x

涓嶈禐鎴愪娇鐢�锛岀幇鍦ㄩ噸鏂板懡鍚嶄负--lock-all-tables銆�

路         --flush-logs锛�-F

寮�濮嬭浆鍌ㄥ墠鍒锋柊MySQL鏈嶅姟鍣ㄦ棩蹇楁枃浠躲�傝�ラ�夐」瑕佹眰RELOAD鏉冮檺銆傝�锋敞鎰忓�傛灉缁撳悎--all--database(鎴�-A)閫夐」浣跨敤璇ラ�夐」锛�鏍规嵁姣忎釜杞�鍌ㄧ殑鏁版嵁搴�鍒锋柊鏃ュ織銆備緥澶栨儏鍐垫槸褰撲娇鐢�--lock-all-tables鎴�--master-data鐨勬椂鍊欙細鍦ㄨ繖绉嶆儏鍐典笅锛屾棩蹇楀彧鍒锋柊涓�娆★紝鍦ㄦ墍鏈� 琛ㄨ��閿佸畾鍚庡埛鏂般�傚�傛灉浣犳兂瑕佸悓鏃惰浆鍌ㄥ拰鍒锋柊鏃ュ織锛屽簲浣跨敤--flush-logs杩炲悓--lock-all-tables鎴�--master-data銆�

路         --force锛�-f

鍦ㄨ〃杞�鍌ㄨ繃绋嬩腑锛屽嵆浣垮嚭鐜�SQL閿欒��涔熺户缁�銆�

路         --host=host_name锛�-h host_name

浠庣粰瀹氫富鏈虹殑MySQL鏈嶅姟鍣ㄨ浆鍌ㄦ暟鎹�銆傞粯璁や富鏈烘槸localhost銆�

路         --hex-blob

浣跨敤鍗佸叚杩涘埗绗﹀彿杞�鍌ㄤ簩杩涘埗瀛楃�︿覆鍒�(渚嬪�傦紝'abc' 鍙樹负0x616263)銆傚奖鍝嶅埌鐨勫垪鏈�BINARY銆�VARBINARY銆�BLOB銆�

路         --lock-all-tables锛�-x

鎵�鏈夋暟鎹�搴撲腑鐨勬墍鏈夎〃鍔犻攣銆傚湪鏁翠綋杞�鍌ㄨ繃绋嬩腑閫氳繃鍏ㄥ眬璇婚攣瀹氭潵瀹炵幇銆傝�ラ�夐」鑷�鍔ㄥ叧闂�--single-transaction鍜�--lock-tables銆�

路         --lock-tables锛�-l

寮�濮嬭浆鍌ㄥ墠閿佸畾鎵�鏈夎〃銆傜敤READ LOCAL閿佸畾琛ㄤ互鍏佽�稿苟琛屾彃鍏�MyISAM琛ㄣ�傚�逛簬浜嬪姟琛ㄤ緥濡�InnoDB鍜�BDB锛�--single-transaction鏄�涓�涓�鏇村ソ鐨勯�夐」锛屽洜涓哄畠涓嶆牴鏈�闇�瑕侀攣瀹氳〃銆�

璇锋敞鎰忓綋杞�鍌ㄥ�氫釜鏁版嵁搴撴椂锛�--lock-tables鍒嗗埆涓烘瘡涓�鏁版嵁搴撻攣瀹氳〃銆傚洜姝わ紝璇ラ�夐」涓嶈兘淇濊瘉杞�鍌ㄦ枃浠朵腑鐨勮〃鍦ㄦ暟鎹�搴撲箣闂寸殑閫昏緫涓�鑷存�с�備笉鍚屾暟鎹�搴撹〃鐨勮浆鍌ㄧ姸鎬佸彲浠ュ畬鍏ㄤ笉鍚屻��

路         --master-data[=value]

璇ラ�夐」灏嗕簩杩涘埗鏃ュ織鐨勪綅缃�鍜屾枃浠跺悕鍐欏叆鍒拌緭鍑轰腑銆傝�ラ�夐」瑕佹眰鏈�RELOAD鏉冮檺锛屽苟涓斿繀椤诲惎鐢ㄤ簩杩涘埗鏃ュ織銆傚�傛灉璇ラ�夐」鍊肩瓑浜�1锛屼綅缃�鍜屾枃浠跺悕琚�鍐欏叆CHANGE MASTER璇�鍙ュ舰寮忕殑杞�鍌ㄨ緭鍑猴紝濡傛灉浣犱娇鐢ㄨ��SQL杞�鍌ㄤ富鏈嶅姟鍣ㄤ互璁剧疆浠庢湇鍔″櫒锛屼粠鏈嶅姟鍣ㄤ粠涓绘湇鍔″櫒浜岃繘鍒舵棩蹇楃殑姝ｇ‘浣嶇疆寮�濮嬨�傚�傛灉閫夐」鍊肩瓑浜�2锛�CHANGE MASTER璇�鍙ヨ��鍐欐垚SQL娉ㄩ噴銆傚�傛灉value琚�鐪佺暐锛岃繖鏄�榛樿�ゅ姩浣溿��

--master-data閫夐」鍚�鐢�--lock-all-tables锛岄櫎闈炶繕鎸囧畾--single-transaction(鍦ㄨ繖绉嶆儏鍐典笅锛屽彧鍦ㄥ垰寮�濮嬭浆鍌ㄦ椂鐭�鏃堕棿鑾峰緱鍏ㄥ眬璇婚攣瀹氥�傚張瑙�--single-transaction銆傚湪浠讳綍涓�绉嶆儏鍐典笅锛屾棩蹇楃浉鍏冲姩浣滃彂鐢熷湪杞�鍌ㄦ椂銆傝�ラ�夐」鑷�鍔ㄥ叧闂�--lock-tables銆�

路         --no-create-db锛�-n

璇ラ�夐」绂佺敤CREATE DATABASE /*!32312 IF NOT EXISTS*/ db_name璇�鍙ワ紝濡傛灉缁欏嚭---database鎴�--all--database閫夐」锛屽垯鍖呭惈鍒拌緭鍑轰腑銆�

路         --no-create-info锛�-t

涓嶅啓閲嶆柊鍒涘缓姣忎釜杞�鍌ㄨ〃鐨�CREATE TABLE璇�鍙ャ��

路         --no-data锛�-d

涓嶅啓琛ㄧ殑浠讳綍琛屼俊鎭�銆傚�傛灉浣犲彧鎯宠浆鍌ㄨ〃鐨勭粨鏋勮繖寰堟湁鐢ㄣ��

路         --opt

璇ラ�夐」鏄�閫熻�帮紱绛夊悓浜庢寚瀹� --add-drop-tables--add-locking --create-option --disable-keys--extended-insert --lock-tables --quick --set-charset銆傚畠鍙�浠ョ粰鍑哄緢蹇�鐨勮浆鍌ㄦ搷浣滃苟浜х敓涓�涓�鍙�浠ュ緢蹇�瑁呭叆MySQL鏈嶅姟鍣ㄧ殑杞�鍌ㄦ枃浠躲��璇ラ�夐」榛樿�ゅ紑鍚�锛屼絾鍙�浠ョ敤--skip-opt绂佺敤銆傝�佹兂鍙�绂佺敤纭�淇＄敤-opt鍚�鐢ㄧ殑閫夐」锛屼娇鐢�--skip褰㈠紡锛涗緥濡傦紝--skip-add-drop-tables鎴�--skip-quick銆�

路         --password[=password]锛�-p[password]

杩炴帴鏈嶅姟鍣ㄦ椂浣跨敤鐨勫瘑鐮併�傚�傛灉浣犱娇鐢ㄧ煭閫夐」褰㈠紡(-p)锛�涓嶈兘鍦ㄩ�夐」鍜屽瘑鐮佷箣闂存湁涓�涓�绌烘牸銆傚�傛灉鍦ㄥ懡浠よ�屼腑锛屽拷鐣ヤ簡--password鎴�-p閫夐」鍚庨潰鐨� 瀵嗙爜鍊硷紝灏嗘彁绀轰綘杈撳叆涓�涓�銆�

路         --port=port_num锛�-P port_num

鐢ㄤ簬杩炴帴鐨�TCP/IP绔�鍙ｅ彿銆�

路         --protocol={TCP | SOCKET | PIPE | MEMORY}

浣跨敤鐨勮繛鎺ュ崗璁�銆�

路         --quick锛�-q

璇ラ�夐」鐢ㄤ簬杞�鍌ㄥぇ鐨勮〃銆傚畠寮哄埗mysqldump浠庢湇鍔″櫒涓�娆′竴琛屽湴妫�绱㈣〃涓�鐨勮�岃�屼笉鏄�妫�绱㈡墍鏈夎�屽苟鍦ㄨ緭鍑哄墠灏嗗畠缂撳瓨鍒板唴瀛樹腑銆�

路         --quote-names锛�-Q

鐢ㄢ��`鈥欏瓧绗﹀紩鐢ㄦ暟鎹�搴撱�佽〃鍜屽垪鍚嶃�傚�傛灉鏈嶅姟鍣�SQL妯″紡鍖呮嫭ANSI_QUOTES閫夐」锛岀敤鈥�"鈥欏瓧绗﹀紩鐢ㄥ悕銆傞粯璁ゅ惎鐢ㄨ�ラ�夐」銆傚彲浠ョ敤--skip-quote-names绂佺敤锛屼絾璇ラ�夐」搴旇窡鍦ㄥ叾瀹冮�夐」鍚庨潰锛屼緥濡傚彲浠ュ惎鐢�--quote-names鐨�--compatible銆�

路         --result-file=file锛�-r file

灏嗚緭鍑鸿浆鍚戠粰瀹氱殑鏂囦欢銆傝�ラ�夐」搴旂敤鍦�Windows涓�锛屽洜涓哄畠绂佹�㈠皢鏂拌�屸��\n鈥欏瓧绗﹁浆鎹�涓衡��\r\n鈥欏洖杞︺�佽繑鍥�/鏂拌�屽簭鍒椼��

路         --routines锛�-R

鍦ㄨ浆鍌ㄧ殑鏁版嵁搴撲腑杞�鍌ㄥ瓨鍌ㄧ▼搴�(鍑芥暟鍜岀▼搴�)銆備娇鐢�---routines浜х敓鐨勮緭鍑哄寘鍚�CREATE PROCEDURE鍜�CREATE FUNCTION璇�鍙ヤ互閲嶆柊鍒涘缓瀛愮▼搴忋�備絾鏄�锛岃繖浜涜��鍙ヤ笉鍖呮嫭灞炴�э紝渚嬪�傚瓙绋嬪簭瀹氫箟鑰呮垨鍒涘缓鍜屼慨鏀规椂闂存埑銆傝繖璇存槑褰撻噸杞藉瓙绋嬪簭鏃讹紝瀵瑰畠浠�杩涜�屽垱寤烘椂瀹氫箟鑰呭簲璁剧疆涓洪噸杞界敤鎴凤紝鏃堕棿鎴崇瓑浜庨噸杞芥椂闂淬��

濡傛灉浣犻渶瑕佸垱寤虹殑瀛愮▼搴忎娇鐢ㄥ師鏉ョ殑瀹氫箟鑰呭拰鏃堕棿鎴冲睘鎬э紝涓嶄娇鐢�--routines銆傜浉鍙嶏紝浣跨敤涓�涓�鍏锋湁mysql鏁版嵁搴撶浉搴旀潈闄愮殑MySQL璐︽埛鐩存帴杞�鍌ㄥ拰閲嶈浇mysql.proc琛ㄧ殑鍐呭�广��

璇ラ�夐」鍦�MySQL 5.1.2涓�娣诲姞杩涙潵銆傚湪姝や箣鍓嶏紝瀛樺偍绋嬪簭涓嶈浆鍌ㄣ��

路         --set-charset

灏�SET NAMES default_character_set鍔犲埌杈撳嚭涓�銆傝�ラ�夐」榛樿�ゅ惎鐢ㄣ�傝�佹兂绂佺敤SET NAMES璇�鍙ワ紝浣跨敤--skip-set-charset銆�

路         --single-transaction

璇ラ�夐」浠庢湇鍔″櫒杞�鍌ㄦ暟鎹�涔嬪墠鍙戝嚭涓�涓�BEGIN SQL璇�鍙ャ�傚畠鍙�閫傜敤浜庝簨鍔¤〃锛屼緥濡�InnoDB鍜�BDB锛屽洜涓虹劧鍚庡畠灏嗗湪鍙戝嚭BEGIN鑰屾病鏈夐樆濉炰换浣曞簲鐢ㄧ▼搴忔椂杞�鍌ㄤ竴鑷寸殑鏁版嵁搴撶姸鎬併��

褰撲娇鐢ㄨ�ラ�夐」鏃讹紝搴旇�颁綇鍙�鏈�InnoDB琛ㄨ兘浠ヤ竴鑷寸殑鐘舵�佽��杞�鍌ㄣ�備緥濡傦紝浣跨敤璇ラ�夐」鏃朵换浣曡浆鍌ㄧ殑MyISAM鎴�HEAP琛ㄤ粛鐒跺彲浠ユ洿鏀圭姸鎬併��

--single-transaction閫夐」鍜�--lock-tables閫夐」鏄�浜掓枼鐨勶紝鍥犱负LOCK TABLES浼氫娇浠讳綍鎸傝捣鐨勪簨鍔￠殣鍚�鎻愪氦銆�

瑕佹兂杞�鍌ㄥぇ鐨勮〃锛屽簲缁撳悎--quick浣跨敤璇ラ�夐」銆�

路         --socket=path锛�-S path

褰撹繛鎺�localhost(涓洪粯璁や富鏈�)鏃朵娇鐢ㄧ殑濂楁帴瀛楁枃浠躲��

路         --skip--comments

鍙傝��---comments閫夐」鐨勬弿杩般��

路         --tab=path锛�-T path

浜х敓tab鍒嗗壊鐨勬暟鎹�鏂囦欢銆傚�逛簬姣忎釜杞�鍌ㄧ殑琛�锛�mysqldump鍒涘缓涓�涓�鍖呭惈鍒涘缓琛ㄧ殑CREATE TABLE璇�鍙ョ殑tbl_name.sql鏂囦欢锛屽拰涓�涓�鍖呭惈鍏舵暟鎹�鐨�tbl_name.txt鏂囦欢銆傞�夐」鍊间负鍐欏叆鏂囦欢鐨勭洰褰曘��

榛樿�ゆ儏鍐碉紝.txt鏁版嵁鏂囦欢鐨勬牸寮忔槸鍦ㄥ垪鍊煎拰姣忚�屽悗闈㈢殑鏂拌�屼箣闂翠娇鐢�tab瀛楃�︺�傚彲浠ヤ娇鐢�--fields-xxx鍜�--琛�--xxx閫夐」鏄庢樉鎸囧畾鏍煎紡銆�

娉ㄩ噴锛�璇ラ�夐」鍙�閫傜敤浜�mysqldump涓�mysqld鏈嶅姟鍣ㄥ湪鍚屼竴鍙版満鍣ㄤ笂杩愯�屾椂銆備綘蹇呴』鍏锋湁FILE鏉冮檺锛屽苟涓旀湇鍔″櫒蹇呴』鏈夊湪浣犳寚瀹氱殑鐩�褰曚腑鏈夊啓鏂囦欢鐨勮�稿彲銆�

路         --tables

瑕嗙洊---database鎴�-B閫夐」銆傞�夐」鍚庨潰鐨勬墍鏈夊弬閲忚��鐪嬩綔琛ㄥ悕銆�

路         --triggers

涓烘瘡涓�杞�鍌ㄧ殑琛ㄨ浆鍌ㄨЕ鍙戝櫒銆傝�ラ�夐」榛樿�ゅ惎鐢�锛涚敤--skip-triggers绂佺敤瀹冦��

路         --tz-utc

鍦ㄨ浆鍌ㄦ枃浠朵腑鍔犲叆SET TIME_ZONE='+00:00'浠ヤ究TIMESTAMP鍒楀彲浠ュ湪鍏锋湁涓嶅悓鏃跺尯鐨勬湇鍔″櫒涔嬮棿杞�鍌ㄥ拰閲嶈浇銆�(涓嶄娇鐢ㄨ�ラ�夐」锛�TIMESTAMP鍒楀湪鍏锋湁鏈�鍦版椂鍖虹殑婧愭湇鍔″櫒鍜岀洰鐨勬湇鍔″櫒涔嬮棿杞�鍌ㄥ拰閲嶈浇锛�銆�--tz-utc涔熷彲浠ヤ繚鎶ょ敱浜庡�忎护鏃跺甫鏉ョ殑鏇存敼銆�--tz-utc榛樿�ゅ惎鐢ㄣ�傝�佹兂绂佺敤瀹冿紝浣跨敤--skip-tz-utc銆傝�ラ�夐」鍦�MySQL 5.1.2涓�鍔犲叆銆�

路         --user=user_name锛�-u user_name

杩炴帴鏈嶅姟鍣ㄦ椂浣跨敤鐨�MySQL鐢ㄦ埛鍚嶃��

路         --verbose锛�-v

鍐楅暱妯″紡銆傛墦鍗板嚭绋嬪簭鎿嶄綔鐨勮�︾粏淇℃伅銆�

路         --version锛�-V

鏄剧ず鐗堟湰淇℃伅骞堕��鍑恒��

路         --where='where-condition', -w 'where-condition'

鍙�杞�鍌ㄧ粰瀹氱殑WHERE鏉′欢閫夋嫨鐨勮�板綍銆傝�锋敞鎰忓�傛灉鏉′欢鍖呭惈鍛戒护瑙ｉ噴绗︿笓鐢ㄧ┖鏍兼垨瀛楃�︼紝涓�瀹氳�佸皢鏉′欢寮曠敤璧锋潵銆�

渚嬪�傦細

"--where=user='jimf'"

"-wuserid>1"

"-wuserid<1"

路         --xml锛�-X

灏嗚浆鍌ㄨ緭鍑哄啓鎴�XML銆�

杩樺彲浠ヤ娇鐢�--var_name=value閫夐」璁剧疆涓嬮潰鐨勫彉閲忥細

路         max_allowed_packet

瀹㈡埛绔�/鏈嶅姟鍣ㄤ箣闂撮�氫俊鐨勭紦瀛樺尯鐨勬渶澶уぇ灏忋�傛渶澶т负1GB銆�

路         net_buffer_length

瀹㈡埛绔�/鏈嶅姟鍣ㄤ箣闂撮�氫俊鐨勭紦瀛樺尯鐨勫垵濮嬪ぇ灏忋�傚綋鍒涘缓澶氳�屾彃鍏ヨ��鍙ユ椂(濡傚悓浣跨敤閫夐」--extended-insert鎴�--opt)锛�mysqldump鍒涘缓闀垮害杈�net_buffer_length鐨勮�屻�傚�傛灉澧炲姞璇ュ彉閲忥紝杩樺簲纭�淇濆湪MySQL鏈嶅姟鍣ㄤ腑鐨�net_buffer_length鍙橀噺鑷冲皯杩欎箞澶с��

杩樺彲浠ヤ娇鐢�--set-variable=var_name=value鎴�-O var_name=value璇�娉曡�剧疆鍙橀噺銆傜劧鑰岋紝鐜板湪涓嶈禐鎴愪娇鐢ㄨ�ヨ��娉曘��

mysqldump鏈�甯哥敤浜庡�囦唤涓�涓�鏁翠釜鐨勬暟鎹�搴擄細

shell> mysqldump --opt db_name > backup-file.sql

浣犲彲浠ヨ繖鏍峰皢杞�鍌ㄦ枃浠惰�诲洖鍒版湇鍔″櫒锛�

shell> mysql db_name < backup-file.sql

鎴栬�呬负锛�

shell> mysql -e "source /path-to--backup/backup-file.sql" db_name

mysqldump涔熷彲鐢ㄤ簬浠庝竴涓�MySQL鏈嶅姟鍣ㄥ悜鍙︿竴涓�鏈嶅姟鍣ㄥ�嶅埗鏁版嵁鏃惰�呰浇鏁版嵁搴擄細

shell> mysqldump --opt db_name | mysql --host=remote_host -C db_name

鍙�浠ョ敤涓�涓�鍛戒护杞�鍌ㄥ嚑涓�鏁版嵁搴擄細

shell> mysqldump ---database db_name1 [db_name2 ...] > my_databases.sql

濡傛灉浣犳兂瑕佽浆鍌ㄦ墍鏈夋暟鎹�搴擄紝浣跨敤--all--database閫夐」锛�

shell> mysqldump --all-databases > all_databases.sql

濡傛灉琛ㄤ繚瀛樺湪InnoDB瀛樺偍寮曟搸涓�锛�mysqldump鎻愪緵浜嗕竴绉嶈仈鏈哄�囦唤鐨勯�斿緞(鍙傝�佷笅闈㈢殑鍛戒护)銆傝�ュ�囦唤鍙�闇�瑕佸湪寮�濮嬭浆鍌ㄦ椂瀵规墍鏈夎〃杩涜�屽叏灞�璇婚攣瀹�(浣跨敤FLUSH TABLES WITH READ LOCK)銆傝幏寰楅攣瀹氬悗锛岃�诲彇浜岃繘鍒舵棩蹇楃殑鐩稿簲鍐呭�瑰苟灏嗛攣閲婃斁銆傚洜姝ゅ�傛灉骞朵笖鍙�鏈夊綋鍙戝嚭FLUSH...鏃舵�ｆ墽琛屼竴涓�闀跨殑鏇存柊璇�鍙ワ紝MySQL鏈嶅姟鍣ㄦ墠鍋滄�㈢洿鍒伴暱璇�鍙ョ粨鏉燂紝鐒跺悗杞�鍌ㄥ垯閲婃斁閿併�傚洜姝ゅ�傛灉MySQL鏈嶅姟鍣ㄥ彧鎺ユ敹鍒扮煭("鐭�鎵ц�屾椂闂�")鐨勬洿鏂拌��鍙ワ紝鍗充娇鏈夊ぇ閲忕殑璇�鍙ワ紝涔熶笉浼氭敞鎰忓埌閿佹湡闂淬��

shell> mysqldump --all-databases --single-transaction > all_databases.sql

瀵逛簬鐐瑰�圭偣鎭㈠��(涔熺О涓衡�滃墠婊氣�濓紝褰撲綘闇�瑕佹仮澶嶆棫鐨勫�囦唤骞堕噸鏀捐�ュ�囦唤浠ュ悗鐨勬洿鏀规椂)锛屽惊鐜�浜岃繘鍒舵棩蹇�(鍙傝��5.11.3鑺傦紝鈥滀簩杩涘埗鏃ュ織鈥�)鎴栬嚦灏戠煡閬撹浆鍌ㄥ�瑰簲鐨勪簩杩涘埗鏃ュ織鍐呭�瑰緢鏈夌敤锛�

shell> mysqldump --all-databases --master-data=2 > all_databases.sql

鎴�

shell> mysqldump --all-databases --flush-logs --master-data=2 > all_databases.sql

濡傛灉琛ㄤ繚瀛樺湪InnoDB瀛樺偍寮曟搸涓�锛屽悓鏃朵娇鐢�--master-data鍜�--single-transaction鎻愪緵浜嗕竴涓�寰堟柟渚跨殑鏂瑰紡鏉ヨ繘琛岄�傚悎鐐瑰�圭偣鎭㈠�嶇殑鑱旀満澶囦唤銆�

鍏充簬澶囦唤鐨勮�︾粏淇℃伅锛屽弬瑙�5.9.1鑺傦紝鈥滄暟鎹�搴撳�囦唤鈥�銆�

mysqlhotcopy鏄�涓�涓�Perl鑴氭湰锛屾渶鍒濈敱Tim Bunce缂栧啓骞舵彁渚涖�傚畠浣跨敤LOCK TABLES銆�FLUSH TABLES鍜�cp鎴�scp鏉ュ揩閫熷�囦唤鏁版嵁搴撱�傚畠鏄�澶囦唤鏁版嵁搴撴垨鍗曚釜琛ㄧ殑鏈�蹇�鐨勯�斿緞锛屼絾瀹冨彧鑳借繍琛屽湪鏁版嵁搴撶洰褰曟墍鍦ㄧ殑鏈哄櫒涓娿��mysqlhotcopy鍙�鐢ㄤ簬澶囦唤MyISAM銆傚畠杩愯�屽湪Unix鍜�NetWare涓�銆�

shell> mysqlhotcopy db_name [/path/to/new_directory]

shell> mysqlhotcopy db_name_1 ... db_name_n /path/to/new_directory

澶囦唤缁欏畾鏁版嵁搴撲腑鐨勫尮閰嶆�ｅ垯琛ㄨ揪寮忕殑琛�锛�

shell> mysqlhotcopy db_name./regex/

鍔犱笂鍙戦煶绗�(鈥�~鈥�)鍓嶇紑锛岃〃鍚嶇殑姝ｅ垯琛ㄨ揪寮忓彲浠ヨ��鍚﹀畾锛�

shell> mysqlhotcopy db_name./~regex/

mysqlhotcopy鏀�鎸佷笅闈㈢殑閫夐」锛�

路         ---help锛�-锛�

鏄剧ず甯�鍔╂秷鎭�骞堕��鍑恒��

路         --allowold

濡傛灉鐩�鏍囧瓨鍦ㄤ笉鏀惧純(鍔犱笂涓�涓�_old鍚庣紑閲嶆柊鍛藉悕瀹�)銆�

路         --checkpoint=db_name.tbl_name

鍦ㄦ寚瀹氱殑db_name.tbl_name鎻掑叆妫�鏌ョ偣鏉＄洰銆�

路         ---debug

鍚�鐢ㄨ皟璇曡緭鍑恒��

路         --dryrun锛�-n

鎶ュ憡鍔ㄤ綔鑰屼笉鎵ц�屽畠浠�銆�

路         --flushlog

鎵�鏈夎〃閿佸畾鍚庡埛鏂版棩蹇椼��

路         --keepold

瀹屾垚鍚庝笉鍒犻櫎浠ュ墠(閲嶆柊鍛藉悕鐨�)鐨勭洰鏍囥��

路         -- method=command

澶嶅埗鏂规硶(cp鎴�scp)銆�

路         --noindices

澶囦唤涓�涓嶅寘鎷�鍏ㄩ儴绱㈠紩鏂囦欢銆傝繖鏍蜂娇澶囦唤鏇村皬銆佹洿蹇�銆傚彲浠ュ湪浠ュ悗鐢�myisamchk -rq閲嶆柊鏋勫缓绱㈠紩銆�

路         --password=password锛�-p password

褰撹繛鎺ユ湇鍔″櫒鏃朵娇鐢ㄧ殑瀵嗙爜銆傝�锋敞鎰忚�ラ�夐」鐨勫瘑鐮佸�兼槸涓嶅彲閫夌殑锛屼笉璞″叾瀹�MySQL绋嬪簭銆�

路         --port=port_num锛�-P port_num

褰撹繛鎺ユ湰鍦版湇鍔″櫒鏃朵娇鐢ㄧ殑TCP/IP绔�鍙ｅ彿銆�

路         --quiet锛�-q

闄や簡鍑虹幇閿欒��鏃朵繚鎸佹矇榛樸��

路         --regexp=expr

澶嶅埗鎵�鏈夋暟鎹�搴撳悕鍖归厤缁欏嚭鐨勬�ｅ垯琛ㄨ揪寮忕殑鏁版嵁搴撱��

路         --socket=path锛�-S path

鐢ㄤ簬杩炴帴鐨�Unix濂楁帴瀛楁枃浠躲��

路         --suffix=str

鎵�澶嶅埗鐨勬暟鎹�搴撳悕鐨勫悗缂�銆�

路         --tmpdir=path

涓存椂鐩�褰�(浠ｆ浛/tmp)銆�

路         --user=user_name锛�-u user_name

褰撹繛鎺ユ湇鍔″櫒鏃朵娇鐢ㄧ殑MySQL鐢ㄦ埛鍚嶃��

mysqlhotcopy浠庨�夐」鏂囦欢璇诲彇[client]鍜�[mysqlhotcopy]閫夐」缁勩��

瑕佹兂鎵ц��mysqlhotcopy锛屼綘蹇呴』鍙�浠ヨ�块棶澶囦唤鐨勮〃鏂囦欢锛屽叿鏈夐偅浜涜〃鐨�SELECT鏉冮檺鍜�RELOAD鏉冮檺(浠ヤ究鑳藉�熸墽琛�FLUSH TABLES)銆�

浣跨敤perldoc璋冪敤鍏跺畠mysqlhotcopy鏂囨。锛�

shell> perldoc mysqlhotcopy

mysqlimport瀹㈡埛绔�鎻愪緵浜�LOAD DATA INFILEQL璇�鍙ョ殑涓�涓�鍛戒护琛屾帴鍙ｃ��mysqlimport鐨勫ぇ澶氭暟閫夐」鐩存帴瀵瑰簲LOAD DATA INFILE瀛愬彞銆傚弬瑙�13.2.5鑺傦紝鈥淟OAD DATA INFILE璇�娉曗��銆�

杩欐牱璋冪敤mysqlimport锛�

shell> mysqlimport [options] db_name textfile1 [textfile2 ...]

瀵逛簬鍦ㄥ懡浠よ�屼腑鍛藉悕鐨勬瘡涓�鏂囨湰鏂囦欢锛�mysqlimport鍘绘帀鏂囦欢鍚嶇殑鎵╁睍鍚嶅苟浣跨敤缁撴灉鏉ョ‘瀹氬皢瀵煎叆鏂囦欢鍐呭�圭殑琛ㄥ悕銆備緥濡傦紝鏂囦欢 patient.txt銆�patient.text鍜�patient鍧囧皢瀵煎叆琛�patient銆�

mysqlimport鏀�鎸佷笅闈㈢殑閫夐」锛�

路         ---help锛�-锛�

鏄剧ず甯�鍔╂秷鎭�骞堕��鍑恒��

路         --columns=column_list, -c column_list

璇ラ�夐」閲囩敤鐢ㄩ�楀彿鍒嗛殧鐨勫垪鍚嶄綔涓哄叾鍊笺�傚垪鍚嶇殑椤哄簭鎸囩ず濡備綍鍖归厤鏁版嵁鏂囦欢鍒楀拰琛ㄥ垪銆�

路         --compress锛�-C

鍘嬬缉鍦ㄥ�㈡埛绔�鍜屾湇鍔″櫒涔嬮棿鍙戦�佺殑鎵�鏈変俊鎭�锛堝�傛灉浜岃�呭潎鏀�鎸佸帇缂╋級銆�

路         ---debug[=debug_options]锛�-# [debug_options]

鍐欒皟璇曟棩蹇椼��debug_options瀛楃�︿覆閫氬父鏄�'d:t:o,file_name'銆�

路         --delete锛�-D

瀵煎叆鏂囨湰鏂囦欢鍓嶆竻绌鸿〃銆�

路         --fields-terminated-by=...锛�--fields-enclosed-by=...锛�--fields-optionally-enclosed-by=...锛�--fields-escaped-by=...锛�--lines-terminated-by=...

杩欎簺閫夐」涓�LOAD DATA INFILE鐩稿簲瀛愬彞鐨勫惈涔夌浉鍚屻�傚弬瑙�13.2.5鑺傦紝鈥淟OAD DATA INFILE璇�娉曗��銆�

路         --force锛�-f

蹇借�嗛敊璇�銆備緥濡傦紝濡傛灉鏌愪釜鏂囨湰鏂囦欢鐨勮〃涓嶅瓨鍦�锛岀户缁�澶勭悊鍏跺畠鏂囦欢銆備笉浣跨敤--force锛屽�傛灉琛ㄤ笉瀛樺湪鍒�mysqlimport閫�鍑恒��

路         --host=host_name锛�-h host_name

灏嗘暟鎹�瀵煎叆缁欏畾涓绘満涓婄殑MySQL鏈嶅姟鍣ㄣ�傞粯璁や富鏈烘槸localhost銆�

路         --ignore锛�-i

鍙傝��--replace閫夐」鐨勬弿杩般��

路         --ignore-lines=n

蹇借�嗘暟鎹�鏂囦欢鐨勫墠n琛屻��

路         --local锛�-L

浠庢湰鍦板�㈡埛绔�璇诲叆杈撳叆鏂囦欢銆�

路         --lock-tables锛�-l

澶勭悊鏂囨湰鏂囦欢鍓嶉攣瀹氭墍鏈夎〃浠ヤ究鍐欏叆銆傝繖鏍峰彲浠ョ‘淇濇墍鏈夎〃鍦ㄦ湇鍔″櫒涓婁繚鎸佸悓姝ャ��

路         --password[=password]锛�-p[password]

褰撹繛鎺ユ湇鍔″櫒鏃朵娇鐢ㄧ殑瀵嗙爜銆傚�傛灉浣跨敤鐭�閫夐」褰㈠紡(-p)锛岄�夐」鍜� 瀵嗙爜涔嬮棿涓嶈兘鏈夌┖鏍笺�傚�傛灉鍦ㄥ懡浠よ�屼腑--password鎴�-p閫夐」鍚庨潰娌℃湁 瀵嗙爜鍊硷紝鍒欐彁绀鸿緭鍏ヤ竴涓�瀵嗙爜銆�

路         --port=port_num锛�-P port_num

鐢ㄤ簬杩炴帴鐨�TCP/IP绔�鍙ｅ彿銆�

路         --protocol={TCP | SOCKET | PIPE | MEMORY}

浣跨敤鐨勮繛鎺ュ崗璁�銆�

路         --replace锛�-r

--replace鍜�--ignore閫夐」鎺у埗澶嶅埗鍞�涓�閿�鍊煎凡鏈夎�板綍鐨勮緭鍏ヨ�板綍鐨勫�勭悊銆傚�傛灉鎸囧畾--replace锛屾柊琛屾浛鎹㈡湁鐩稿悓鐨勫敮涓�閿�鍊肩殑宸叉湁琛屻�傚�傛灉鎸囧畾--ignore锛屽�嶅埗宸叉湁鐨勫敮涓�閿�鍊肩殑杈撳叆琛岃��璺宠繃銆傚�傛灉涓嶆寚瀹氳繖涓や釜閫夐」锛屽綋鍙戠幇涓�涓�澶嶅埗閿�鍊兼椂浼氬嚭鐜颁竴涓�閿欒��锛屽苟涓斿拷瑙嗘枃鏈�鏂囦欢鐨勫墿浣欓儴鍒嗐��

路         --silent锛�-s

娌夐粯妯″紡銆傚彧鏈夊嚭鐜伴敊璇�鏃舵墠杈撳嚭銆�

路         --socket=path锛�-S path

褰撹繛鎺�localhost鏃朵娇鐢ㄧ殑濂楁帴瀛楁枃浠�(涓洪粯璁や富鏈�)銆�

路         --user=user_name锛�-u user_name

褰撹繛鎺ユ湇鍔″櫒鏃�MySQL浣跨敤鐨勭敤鎴峰悕銆�

路         --verbose锛�-v

鍐楅暱妯″紡銆傛墦鍗板嚭绋嬪簭鎿嶄綔鐨勮�︾粏淇℃伅銆�

路         --version锛�-V

鏄剧ず鐗堟湰淇℃伅骞堕��鍑恒��

杩欓噷鏄�涓�涓�绀轰緥浼氳瘽锛屾樉绀哄�備綍浣跨敤mysqlimport锛�

shell> mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test

shell> ed

a

100     Max Sydow

101     Count Dracula

.

w imptest.txt

32

q

shell> od -c imptest.txt

0000000   1   0   0  \t   M   a   x       S   y   d   o   w  \n   1   0

0000020   1  \t   C   o   u   n   t       D   r   a   c   u   l   a  \n

0000040

shell> mysqlimport --local test imptest.txt

test.imptest: Records: 2  Deleted: 0  Skipped: 0  Warnings: 0

shell> mysql -e 'SELECT * FROM imptest' test

+------+---------------+

| id   | n             |

+------+---------------+

|  100 | Max Sydow     |

|  101 | Count Dracula |

+------+---------------+

mysqlshow瀹㈡埛鍙�鐢ㄦ潵寰堝揩鍦版煡鎵惧瓨鍦ㄥ摢浜涙暟鎹�搴擄紝鏁版嵁搴撲腑鐨勮〃锛岃〃涓�鐨勫垪鎴栫储寮曘��

mysqlshow涓轰竴浜�SQL鏄剧ず璇�鍙ユ彁渚涗簡涓�涓�鍛戒护琛岀晫闈�銆傜浉鍚岀殑淇℃伅鍙�浠ラ�氳繃鐩存帴浣跨敤閭ｄ簺璇�鍙ヨ幏寰椼�備緥濡傦紝浣犲彲浠ヤ粠mysql瀹㈡埛绋嬪簭鍙戝嚭瀹冧滑銆傚弬瑙�13.5.4鑺傦紝鈥淪HOW璇�娉曗��銆�

璞¤繖鏍疯皟鐢�mysqlshow锛�

shell> mysqlshow[閫夐」] [db_name [tbl_name [col_name]]]

路         濡傛灉娌℃湁缁欏嚭鏁版嵁搴擄紝鏄剧ず鎵�鏈夊尮閰嶇殑鏁版嵁搴撱��

路         濡傛灉娌℃湁缁欏嚭琛�锛屾樉绀烘暟鎹�搴撲腑鎵�鏈夊尮閰嶇殑琛ㄣ��

路         濡傛灉娌℃湁缁欏嚭鍒楋紝鏄剧ず琛ㄤ腑鎵�鏈夊尮閰嶇殑鍒楀拰鍒楃被鍨嬨��

璇锋敞鎰忥紝鍦�MySQL鐨勬柊鐗堟湰涓�锛屼綘鍙�鑳界湅鍒版湁閮ㄥ垎鏉冮檺鐨勯偅浜涙暟鎹�搴撱�佽〃鎴栬�呭垪銆�

濡傛灉鏈�鍚庣殑鍙傛暟鍖呭惈shell鎴�SQL閫氱敤瀛楃�� (鈥�*鈥欍�佲��?鈥欍�佲��%鈥欐垨鑰呪��_鈥�)锛屽彧鏄剧ず閭ｄ簺鍚嶅尮閰嶉�氱敤瀛楃�︾殑鍚嶅瓧銆傚�傛灉涓�涓�鏁版嵁搴撳悕鍖呭惈涓嬪垝绾匡紝搴旇�ヤ娇鐢ㄤ竴涓�鍙嶆枩绾匡紙閮ㄥ垎Unix shells闇�瑕佸弻鍙嶆枩绾匡級瀵瑰畠浠�杩涜�岃浆涔夛紝浠ヤ究寰楀埌涓�涓�姝ｇ‘鐨勮〃鎴栧垪鐨勫垪琛ㄣ�傗��*鈥欏拰鈥�?鈥欏瓧绗﹁��杞�鎹�涓�SQL鐨勨��%鈥欏拰鈥�_鈥欓�氱敤瀛楃�︺�備綘璇曞浘鐢ㄢ��_鈥欐樉绀轰竴涓�琛ㄧ殑鍒楀悕鏃讹紝杩欏彲鑳戒細閫犳垚涓�浜涙贩娣嗭紝鍥犱负鍦ㄨ繖绉嶆儏鍐典笅 mysqlshow鏄剧ず涓庢ā寮忕浉鍖归厤鐨勮〃鍚嶃�傝繖寰堝�规槗閫氳繃鍦ㄥ懡浠よ�屾坊鍔犱竴涓�鈥�%鈥欏弬閲忔潵瑙ｅ喅銆�

mysqlshow鏀�鎸佷笅闈㈢殑閫夐」锛�

路         ---help锛�-锛�

鏄剧ず涓�涓�甯�鍔╂秷鎭�骞堕��鍑恒��

路         --character-sets-dir=path

瀛楃�﹂泦瀹夎�呯洰褰曘�傚弬瑙�5.10.1鑺傦紝鈥滄暟鎹�鍜屾帓搴忕敤瀛楃�﹂泦鈥�銆�

路         --compress锛�-C

鍘嬬缉鎵�鏈夌殑瀹㈡埛鍜屾湇鍔″櫒涔嬮棿鍙戦�佺殑淇℃伅锛堝�傛灉瀹冧滑閮芥敮鎸佸帇缂╋級銆�

路         ---debug[=debug_options]锛�-# [debug_options]

鍐欒皟璇曟棩蹇椼��debug_options瀛楃�︿覆閫氬父鏄�'d:t:o,file_name'銆�

路         --default-character-set=charset

浣跨敤charset涓洪粯璁ゅ瓧绗﹂泦銆傚弬瑙�5.10.1鑺傦紝鈥滄暟鎹�鍜屾帓搴忕敤瀛楃�﹂泦鈥�銆�

路         --host=host_name锛�-h host_name

鍦ㄧ粰鍑虹殑涓绘満涓婅繛鎺� MySQL鏈嶅姟鍣ㄣ��

路         --keys, -k

鏄剧ず琛ㄧ储寮曘��

路         --password[=password]锛�-p[password]

杩炴帴鏈嶅姟鍣ㄦ椂浣跨敤鐨勫瘑鐮併�傚�傛灉浣犱娇鐢ㄧ煭閫夐」褰㈠紡(-p)锛�涓嶈兘鍦ㄩ�夐」鍜� 瀵嗙爜涔嬮棿鏈変竴涓�绌烘牸銆傚�傛灉鍦ㄥ懡浠よ�屼腑锛屼綘蹇界暐浜�--password鎴�-p閫夐」鍚庨潰鐨� 瀵嗙爜鍊硷紝灏嗘彁绀轰綘杈撳叆涓�涓�銆�

路         --port=port_num, -P port_num

杩炴帴鏃朵娇鐢ㄧ殑TCP/IP绔�鍙ｅ彿銆�

路         --protocol={TCP | SOCKET | PIPE | MEMORY}

杩炴帴鏃朵娇鐢ㄧ殑鍗忚��銆�

路         --show-table-type

鏄剧ず涓�鍒楁潵鎸囩ず琛ㄧ被鍨嬶紝涓�SHOW FULL TABLES璇�鍙ユ樉绀虹浉鍚屻��

路         --socket=path锛�-S path

褰撹繛鎺�localhost鏃朵娇鐢ㄧ殑濂楁帴瀛楁枃浠讹紙瀹冩椂榛樿�や富鏈猴級銆�

路         --status, -i

鏄剧ず鍏充簬姣忎釜琛ㄧ殑棰濆�栦俊鎭�銆�

路         --user=user_name锛�-u user_name

杩炴帴鏈嶅姟鍣ㄦ椂浣跨敤鐨�MySQL鐢ㄦ埛鍚嶃��

路         --verbose锛�-v

鍐楅暱妯″紡銆傛墦鍗板嚭绋嬪簭鎿嶄綔鐨勮�︾粏淇℃伅銆傝�ラ�夐」鍙�浠ュ�氭�′娇鐢ㄤ互渚垮�炲姞淇℃伅鎬婚噺銆�

路         --version锛�-V

鏄剧ず鐗堟湰淇℃伅骞堕��鍑恒��

shell> perror [options] errorcode ...

shell> perror13 64

shell> perror --ndb errorcode

replace瀹炵敤宸ュ叿鍙�浠ュ強鏃舵洿鏀规枃浠舵垨鏍囧噯杈撳叆涓�鐨勫瓧绗︿覆銆傚畠棣栧厛浣跨敤鏈夐檺鐘舵�佹満鏉ュ尮閰嶉暱鐨勫瓧绗︿覆銆傝�ュ伐鍏峰彲浠ョ敤鏉ヤ氦鎹㈠瓧绗︿覆銆備緥濡傦紝涓嬮潰鐨勫懡浠や氦鎹㈢粰瀹氭枃浠�file1鍜�file2涓�鐨�a鍜�b锛�

shell> replace a b b a -- file1 file2 ...

浣跨敤--閫夐」鏉ユ寚绀哄瓧绗︿覆-鏇挎崲鍒楄〃鐨勭粨鏉熶綅缃�鍜屽紑濮嬬殑鏂囦欢鍚嶃��

鍦ㄥ懡浠よ�屼腑鐨勪换浣曟枃浠跺悕琚�鍙婃椂淇�鏀癸紝鍥犳�ゅ湪杞�鎹�涔嬪墠锛屽彲鑳借�佸�规簮鏂囦欢杩涜�屽�囦唤銆�

濡傛灉鍦ㄥ懡浠よ�屼腑娌℃湁鎸囧畾鏂囦欢鍚嶏紝replace璇诲彇鏍囧噯杈撳叆骞跺啓鍒版爣鍑嗚緭鍑轰腑銆傚湪杩欑�嶆儏鍐典笅锛屼笉闇�瑕�--閫夐」銆�

replace绋嬪簭鐢ㄤ簬msql2mysql銆�鍙傝��25.9.1鑺傦紝鈥渕sql2mysql锛氳浆鎹�mSQL绋嬪簭浠ョ敤浜嶮ySQL鈥�銆�

replace鏀�鎸佷笅闈㈢殑閫夐」锛�

路         -?锛�-I

鏄剧ず涓�鏉″府鍔╂秷鎭�骞堕��鍑恒��

路         -# debug_options

鍐欒皟璇曟棩蹇椼��debug_options瀛楃�︿覆閫氬父鏄�'d:t:o,file_name'銆�

路         -s

娌夐粯妯″紡銆傛墦鍗板嚭绋嬪簭鎵ц�岀殑灏戦噺淇℃伅銆�

路         -v

鍐楅暱妯″紡銆傛墦鍗板嚭绋嬪簭鎵ц�岀殑澶ч噺淇℃伅銆�

路         -V

鏄剧ず鐗堟湰淇℃伅骞堕��鍑恒��

mysql_zap鏉�姝诲尮閰嶆煇涓�妯″紡鐨勮繘绋嬨�傝薄杩欐牱璋冪敤瀹冿細

shell> mysql_zap [-signal] [-?Ift] pattern

濡傛灉杩涚▼鐨�ps鍛戒护鐨勮緭鍑鸿�屽寘鍚�璇ユā寮忥紝鍒欒�や负鍏跺尮閰嶃�傞粯璁ゆ儏鍐碉紝mysql_zap瀵规瘡涓�杩涚▼璇锋眰纭�璁ゃ�傚搷搴�y鍒欐潃姝昏�ヨ繘绋嬶紝鎴栬��q閫�鍑� mysql_zap銆傚�逛簬鍏跺畠鍝嶅簲锛�mysql_zap涓嶈瘯鍥炬潃姝昏繘绋嬨��

濡傛灉缁欏嚭-signal閫夐」锛屽畠鎸囧畾鍙戦�佸埌姣忎釜杩涚▼鐨勪俊鍙峰悕鎴栦俊鍙风紪鍙枫�傚惁鍒欙紝mysql_zap棣栧厛灏濊瘯TERM锛堜俊鍙�15锛夌劧鍚庣敤KILL锛堜俊鍙�9锛夈��

mysql_zap鐞嗚В涓嬮潰鐨勯�濆�栭�夐」锛�

路         ---help锛�-?锛�-I

鏄剧ず涓�鏉″府鍔╂秷鎭�骞堕��鍑恒��

路         -f

寮哄埗妯″紡銆�mysql_zap 瑙嗗浘鏉�姝绘瘡涓�鍖归厤鐨勮繘绋嬭�屼笉闇�瑕佺‘璁ゃ��

路         -t

娴嬭瘯妯″紡銆傛樉绀烘瘡涓�杩涚▼鐨勪俊鎭�浣嗕笉鏉�姝诲畠銆�