{"id":803,"date":"2015-05-18T15:54:23","date_gmt":"2015-05-19T00:54:23","guid":{"rendered":"http:\/\/blog.box.kr\/?p=803"},"modified":"2015-05-18T15:54:23","modified_gmt":"2015-05-19T00:54:23","slug":"scrapmysqldump-%ec%98%b5%ec%85%98-%eb%b0%8f-%ec%82%ac%ec%9a%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/blog.box.kr\/?p=803","title":{"rendered":"[scrap]mysqldump \uc635\uc158 \ubc0f \uc0ac\uc6a9\ubc95"},"content":{"rendered":"

http:\/\/egloos.zum.com\/simonshin\/v\/2247509<\/a><\/p>\n

 <\/p>\n

1. mysqldump \uc635\uc158 \uc911 binary log \uc758 \ud3ec\uc9c0\uc158 \uc815\ubcf4 \uac19\uc774 dump \ud558\uae30<\/p>\n

\/usr\/local\/mysql\/bin\/mysqldump -uroot -p –master-data=2\u00a0 > \/data\/\u2026\/backup.sql
\n\uc774 \uba85\ub839\uc5b4 \uc911\uc5d0\uc11c “–master-data=2” \uc635\uc158\uc744 \uc8fc\uac8c \ub418\uba74 \ub364\ud504 \uc2dc\uc810\uc758 binary log\uc758 \ud3ec\uc9c0\uc158 \uc815\ubcf4\uac00 \uac19\uc774 Dump \ub418\uac8c \ub41c\ub2e4.
\nDump\ub41c \ud30c\uc77c\uc744 \uc5d0\ub514\ud130\ub85c \uc5f4\uc5b4\ubcf4\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \ub0b4\uc6a9\uc774 \ub098\uc628\ub2e4.<\/p>\n

2. Table Lock \uac78\uae30<\/p>\n

FLUSH TABLES WITH READ LOCK; \/\/Table Lock \uac78\uae30<\/p>\n

UNLOCK TABLES; \/\/Table Lock \ud480\uae30<\/p>\n

3. Mysqldump options<\/p>\n

mysqldump\u00a0 Ver 10.9 Distrib 4.1.18, for pc-linux-gnu (i686)
\nBy Igor Romanenko, Monty, Jani & Sinisa
\nThis software comes with ABSOLUTELY NO WARRANTY. This is free software,
\nand you are welcome to modify and redistribute it under the GPL license
\nDumping definition and data mysql database or table
\nUsage: mysqldump [OPTIONS] database [tables]
\nOR\u00a0\u00a0\u00a0\u00a0 mysqldump [OPTIONS] –databases [OPTIONS] DB1 [DB2 DB3…]
\nOR\u00a0\u00a0\u00a0\u00a0 mysqldump [OPTIONS] –all-databases [OPTIONS]
\nDefault options are read from the following files in the given order:
\n\/etc\/my.cnf \/home\/irteam\/naver\/mysql-4.1.18\/var\/my.cnf ~\/.my.cnf
\nThe following groups are read: mysqldump client
\nThe following options may be given as the first argument:
\n–print-defaults
\nPrint the program argument list and exit
\nx
\n–no-defaults
\nDon’t read default options from any options file
\nx
\n–defaults-file=#
\nOnly read default options from the given file
\nx
\n–defaults-extra-file=
\nRead this file after the global files are read
\nx
\n-a, –all
\nDeprecated. Use –create-options instead.
\ndefault
\n-A, –all-databases
\nDump all the databases. This will be same as \u2013databases with all databases selected.<\/p>\n

–add-drop-database
\nAdd a ‘DROP DATABASE’ before each create.<\/p>\n

–add-drop-table
\nAdd a ‘drop table’ before each create.
\ndefault
\n–add-locks
\nAdd locks around insert statements.
\ndefault
\n–allow-keywords
\nAllow creation of column names that are keywords.<\/p>\n

–character-sets-dir=name
\nDirectory where character sets are.<\/p>\n

-i, –comments
\nWrite additional information.
\ndefault
\n–compatible=name
\nChange the dump to be compatible with a given mode. By default tables are dumped in a format optimized for MySQL. Legal modes are: ansi, mysql323, mysql40, postgresql, oracle, mssql, db2, maxdb, no_key_options, no_table_options, no_field_options. One can use several modes separated by commas. Note: Requires MySQL server version 4.1.0 or higher. This option is ignored with earlier server versions.<\/p>\n

–compact
\nGive less verbose output (useful for debugging). Disables structure comments and header\/footer constructs.\u00a0 Enables options –skip-add-drop-table –no-set-names –skip-disable-keys –skip-add-locks<\/p>\n

-c, –complete-insert
\nUse complete insert statements.<\/p>\n

-C, –compress
\nUse compression in server\/client protocol.<\/p>\n

–create-options
\nInclude all MySQL specific create options.
\ndefault
\n-B, –databases
\nTo dump several databases. Note the difference in usage;
\nIn this case no tables are given. All name arguments are regarded as databasenames. ‘USE db_name;’ will be included in the output.<\/p>\n

-#, –debug[=#]
\nThis is a non-debug version. Catch this and exit
\nx
\n–default-character-set=name
\nSet the default character set.
\nutf8
\n–delayed-insert
\nInsert rows with INSERT DELAYED.<\/p>\n

–delete-master-logs
\nDelete logs on master after backup. This automatically enables –master-data.<\/p>\n

-K, –disable-keys<\/p>\n

‘\/*!40000 ALTER TABLE tb_name DISABLE KEYS *\/; and
\n‘\/*!40000 ALTER TABLE tb_name ENABLE KEYS *\/; will be put\u00a0 in the output.
\ndefault
\n-e, –extended-insert
\nAllows utilization of the new, much faster INSERT syntax.
\ndefault
\n–fields-terminated-by=name
\nFields in the textfile are terminated by …<\/p>\n

–fields-enclosed-by=name
\nFields in the importfile are enclosed by …<\/p>\n

–fields-optionally-enclosed-by=name
\nFields in the i.file are opt. enclosed by …<\/p>\n

–fields-escaped-by=name
\nFields in the i.file are escaped by …<\/p>\n

-x, –first-slave
\nDeprecated, renamed to –lock-all-tables.<\/p>\n

-F, –flush-logs
\nFlush logs file in server before starting dump. Note that if you dump many databases at once (using the option –databases= or –all-databases), the logs will be flushed for each database dumped. The exception is when using –lock-all-tables or –master-data: in this case the logs will be flushed only once, corresponding to the moment all tables are locked. So if you want your dump and the log flush to happen at the same exact moment you
\nshould use –lock-all-tables or –master-data with –flush-logs<\/p>\n

-f, –force
\nContinue even if we get an sql-error.<\/p>\n

-?, –help
\nDisplay this help message and exit.<\/p>\n

–hex-blob
\nDump binary strings (BINARY, VARBINARY, BLOB) in hexadecimal format.<\/p>\n

-h, –host=name
\nConnect to host.<\/p>\n

–ignore-table=name
\nDo not dump the specified table. To specify more than one table to ignore, use the directive multiple times, once for each table.\u00a0 Each table must be specified with both database and table names, e.g.\u00a0 –ignore-table=database.table<\/p>\n

–insert-ignore
\nInsert rows with INSERT IGNORE.<\/p>\n

–lines-terminated-By=name<\/p>\n

Lines in the i.file are terminated by …<\/p>\n

-x, –lock-all-tables
\nLocks all tables across all databases. This is achieved by taking a global read lock for the duration of the whole dump. Automatically turns –single-transaction and –lock-tables off.<\/p>\n

-l, –lock-tables
\nLock all tables for read.
\ndefault
\n–master-data[=#]
\nThis causes the binary log position and filename to be appended to the output. If equal to 1, will print it as a CHANGE MASTER command; if equal to 2, that command will be prefixed with a comment symbol. This option will turn –lock-all-tables on, unless –single-transaction is specified too (in which case a global read lock is only taken a short time at the beginning of the dump – don’t forget to read about –single-transaction below). In all cases any action on logs will happen at the exact moment of the dump.Option automatically turns –lock-tables off.
\n0
\n–max_allowed_packet<\/p>\n

16776192
\n–net_buffer_length=<\/p>\n

1047551
\n–no-autocommit
\nWrap tables with autocommit\/commit statements.<\/p>\n

-n, –no-create-db
\n‘CREATE DATABASE \/*!32312 IF NOT EXISTS*\/ db_name;’ will not be put in the output. The above line will be added otherwise, if –databases or –all-databases option was
\ngiven.}.<\/p>\n

-t, –no-create-info
\nDon’t write table creation info.<\/p>\n

-d, –no-data
\nNo row information.<\/p>\n

-N, –no-set-names
\nDeprecated. Use –skip-set-charset instead.<\/p>\n

–opt
\nSame as –add-drop-table, –add-locks, –create-options, –quick, –extended-insert, –lock-tables, –set-charset, and –disable-keys. Enabled by default, disable with –skip-opt.<\/p>\n

–order-by-primary
\nSorts each table’s rows by primary key, or first unique key, if such a key exists.\u00a0 Useful when dumping a MyISAM table to be loaded into an InnoDB table, but will make the dump itself take considerably longer.<\/p>\n

-p, –password[=name]
\nPassword to use when connecting to server. If password is not given it’s solicited on the tty.<\/p>\n

-P, –port=#
\nPort number to use for connection.
\n3306
\n–protocol=name
\nThe protocol of connection (tcp, socket, pipe, memory)<\/p>\n

-q, –quick
\nDon’t buffer query, dump directly to stdout.
\ndefault
\n-Q, –quote-names
\nQuote table and column names with backticks (`).
\ndefault
\n-r, –result-file=name
\nDirect output to a given file. This option should be used in MSDOS, because it prevents new line ‘n’ from being converted to ‘rn’ (carriage return + line feed).<\/p>\n

–set-charset
\nAdd ‘SET NAMES default_character_set’ to the output. Enabled by default; suppress with –skip-set-charset.
\ndefault
\n-O, –set-variable=name
\nChange the value of a variable. Please note that this option is deprecated; you can set variables directly with –variable-name=value.<\/p>\n

–single-transaction
\nCreates a consistent snapshot by dumping all tables in a single transaction. Works ONLY for tables stored in storage engines which support multiversioning (currently only InnoDB does); the dump is NOT guaranteed to be consistent for other storage engines. Option automatically turns off –lock-tables.<\/p>\n

–skip-opt
\nDisable –opt. Disables –add-drop-table, –add-locks, –create-options, –quick, –extended-insert, –lock-tables, –set-charset, and –disable-keys.<\/p>\n

-S, –socket=name
\nSocket file to use for connection.<\/p>\n

-T, –tab=name
\nCreates tab separated textfile for each table to given path. (creates .sql and .txt files). NOTE: This only works if mysqldump is run on the same machine as the mysqld daemon.<\/p>\n

–tables
\nOverrides option –databases (-B).<\/p>\n

-u, –user=name
\nUser for login if not current user.<\/p>\n

-v, –verbose
\nPrint info about the various stages.<\/p>\n

-V, –version
\nOutput version information and exit.<\/p>\n

-w, –where=name
\nDump only selected records; QUOTES mandatory!<\/p>\n

-X, –xml
\nDump a database as well formed XML.<\/p>\n

=============================================<\/p>\n

** DETAIL SECTION<\/p>\n

-a, –all
\nMySQL \uace0\uc720\uc758 \uc791\uc131 \uc635\uc158\uc744 \ubaa8\ub450 \ud3ec\ud568\ud55c\ub2e4.<\/p>\n

-A, –all-databases
\n\ubaa8\ub4e0 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\ub97c \ub364\ud504 \ud55c\ub2e4. \uc774\uac83\uc740 , \ubaa8\ub4e0 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud55c \uc0c1\ud0dc\ub85c –databases \ub97c \uc2e4\ud589\ud558\ub294 \uac83\uacfc \uac19\ub2e4.<\/p>\n

–add-drop-database
\n\/*!40000 DROP DATABASE IF EXISTS `db_char`*\/; \uad6c\ubb38 \ucd94\uac00<\/p>\n

–add-drop-table
\nDROP TABLE IF EXISTS `test`;
\n\uac01 \uc791\uc131 \uc2a4\ud14c\uc774\ud2b8\uba3c\ud2b8\uc758 \uc804\uc5d0 drop table \ub97c \ucd94\uac00\ud55c\ub2e4.<\/p>\n

–add-locks
\nLOCK TABLES `test` WRITE;
\nINSERT INTO `test` VALUES (‘\u523a’,1);
\nUNLOCK TABLES;
\n\uac01 \ud14c\uc774\ube14 \ub364\ud504\uc758 \uc804\uc5d0 LOCK TABLES \ub97c \ucd94\uac00\ud574 , \ud6c4 \uc5d0 UNLOCK TABLE \ub97c \ucd94\uac00\ud55c\ub2e4 (MySQL \uc5d0\uc758 \uc0bd\uc785\uc744 \ube60\ub974\uac8c\ud558\uae30 \uc704\ud574<\/p>\n

–allow-keywords
\n`test`
\n\ud0a4\uc6cc\ub4dc\uc778 \uceec\ub7fc\uba85\uc758 \uc791\uc131\uc744 \uc778\uc815\ud55c\ub2e4. \uac01 \uceec\ub7fc\uba85\uc758 \uc120\ub450\uc5d0 \ud14c\uc774\ube14\uba85\uc744 \ub367\ubd99\uc774\ub294 \uac83\uc774 \ud544\uc694.<\/p>\n

–character-sets-dir=name
\n\ucf00\ub9ad\ud130\uc14b \ub514\ub809\ud1a0\ub9ac\ub97c \uc9c0\uc815\ud55c\ub2e4.<\/p>\n

-i, –comments
\n— MySQL dump 10.9
\n—
\n— Host: localhost\u00a0\u00a0\u00a0 Database: xien
\n— ——————————————————
\n— Server version\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4.1.18
\n\u2018–\u2018\ub85c \uc2dc\uc791\ud558\ub294 \ud504\ub85c\uadf8\ub7a8 \ubc84\uc804, \uc11c\ubc84 \ubc84\uc804, \uadf8\ub9ac\uace0 \ud638\uc2a4\ud2b8 information comments
\n–skip-comments
\n\u2018–\u2018\ub85c \uc2dc\uc791\ud558\ub294 information comments \uac00 \uc5c6\uc5b4\uc9c4\ub2e4.<\/p>\n

–compatible=name
\n\uad6c\ubd84\uc790\uac00 “test”\ub85c \ub5a8\uc5b4\uc9c0\uba70 oracle,db2,mssql\ub4f1 \ub2e4\ub978 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \uc548\uc815\uc801\uc73c\ub85c \uc635\ud2f0\ub9c8\uc774\uc988 \ub41c\ub2e4.<\/p>\n

–compact
\nCREATE TABLE `test` (
\n`zzang` char(1) default NULL,
\n`good` int(1) default NULL
\n) ENGINE=MyISAM DEFAULT CHARSET=euckr;
\nINSERT INTO `test` VALUES (‘\u523a’,1);<\/p>\n

verbose(\uc0c1\uc138\uc124\uba85)\uc744 \uc81c\uc678\ud558\uc5ec \uac04\ub2e8\ud55c \uc815\ubcf4\ub9cc \ub098\ud0c0\ub09c\ub2e4. –skip-add-drop-table –no-set-names –skip-disable-keys –skip-add-locks
\n\ub514\ubc84\uae45\uc5d0 \uc720\uc6a9\ud558\ub2e4.<\/p>\n

-c, –complete-insert
\n\uc644\uc804\ud55c \uc0bd\uc785 \uc2a4\ud14c\uc774\ud2b8\uba3c\ud2b8(\uceec\ub7fc\uba85\ub3c4 \uc9c0\uc815) \ub97c \uc0ac\uc6a9\ud55c\ub2e4.
\nINSERT INTO `test` (`zzang`, `good`) VALUES (‘\u523a’,1);<\/p>\n

-C, –compress
\n\ud074\ub77c\uc774\uc5b8\ud2b8\uc640 \uc11c\ubc84\uc758 \uc591\ucabd \ubaa8\ub450\uac00 \uc555\ucd95\uc744 \uc11c\ud3ec\ud2b8\ud558\ub294 \uacbd\uc6b0 , \ud074\ub77c\uc774\uc5b8\ud2b8\uc640 \uc11c\ubc84\uac04\uc758 \uc815\ubcf4\ub97c \ubaa8\ub450 \uc555\ucd95\ud55c\ub2e4.<\/p>\n

–create-options
\nCREATE TABLE `test` (
\n`zzang` char(1) default NULL,
\n`good` int(1) default NULL
\n) ENGINE=MyISAM DEFAULT CHARSET=euckr;
\ncreate \uc635\uc158\uc774 \ucd94\uac00\ub41c\ub2e4.<\/p>\n

-B, –databases
\n\uba87\uac1c\uc758 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\ub97c \ub364\ud504 \ud55c\ub2e4. \uc8fc\uc758:\uc5ec\uae30\uc5d0\uc11c\ub294 , \ud14c\uc774\ube14\uba85\uc744 \uc9c0\uc815\ud558\uc9c0 \uc54a\ub294\ub2e4. \uc774\ub984\uc758 \uc778\uc218\ub294 \ubaa8\ub450 , \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uba85\uc73c\ub85c\uc11c \ub2e4\ub8e8\uc5b4\uc9c4\ub2e4. \ucd9c\ub825\ub418\ub294 \uac01 \uc2e0\uaddc \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uc758 \uc804\uc5d0 USE db_name; \uac00 \ucd94\uac00\ub41c\ub2e4.<\/p>\n

-#, –debug[=#]
\n\ub514\ubc84\uae45 \ub85c\uadf8\ub97c \uc791\uc131\ud55c\ub2e4. debug_options \uc2a4\ud2b8\ub9c1\uc740 \uc885\uc885 ‘d:t:o,file_name’\uac00 \ub41c\ub2e4. \ub514\ud3f4\ud2b8\ub294 ‘d:t:o,\/tmp\/mysqldump.trace’.<\/p>\n

–default-character-set=name (default utf8)
\n–default-character-set=euckr
\nINSERT INTO `test` VALUES (‘\ud669’,1);<\/p>\n

–delayed-insert
\nINSERT DELAYED \ucee4\uba58\ub4dc\ub85c \ub808\ucf54\ub4dc\ub97c \uc0bd\uc785\ud55c\ub2e4.
\nINSERT\u00a0 DELAYED INTO test (zzang, good) VALUES (‘\u523a’,1);<\/p>\n

–delete-master-logs
\n\ub9c8\uc2a4\ud130 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc11c\ubc84\uc5d0\uc11c, \ub364\ud504 \uc5f0\uc0b0\uc744 \uc2e4\ud589\ud55c \ud6c4\uc5d0 \ubc14\uc774\ub108\ub9ac \ub85c\uadf8\ub97c \uc0ad\uc81c\ud55c\ub2e4. \uc774 \uc635\uc158\uc740 \uc790\ub3d9\uc73c\ub85c –master-data\ub97c \ud65c\uc131\ud654 \uc2dc\ud0a8\ub2e4.<\/p>\n

-K , –disable-keys
\n\/*!40000 ALTER TABLE test DISABLE KEYS *\/;
\nINSERT\u00a0 DELAYED INTO test (zzang, good) VALUES (‘\u523a’,1);
\n\/*!40000 ALTER TABLE test ENABLE KEYS *\/;
\n\uc774\uac83\uc5d0 \uc758\ud574 , \uc778\ub371\uc2a4\uac00 , \ubaa8\ub4e0 \ub370\uc774\ud130\uac00 \uc0bd\uc785 \ube57\ub098\uac04 \ud6c4 \uc5d0 \uc791\uc131\ub418\uae30 \ub54c\ubb38\uc5d0 ,MySQL \uc11c\ubc84\uc5d0\uc758 \ub370\uc774\ud130\uc758 \ub85c\ub4dc\uac00 \ube68\ub77c\uc9c4\ub2e4. \uc774 \uc635\uc158\uc740 MyISAM \ud14c\uc774\ube14\uc5d0 \ub300\ud574\uc11c\ub9cc \ud6a8\uacfc\uac00 \uc788\ub2e4.<\/p>\n

-e, –extended-insert
\n\uc5ec\ub7ec \uac1c\uc758 VALUES \ub9ac\uc2a4\ud2b8\ub97c \uac00\uc9c0\uace0 \uc788\ub294 \ub2e4\uc911-\uc5f4 INSERT \uc2e0\ud14d\uc2a4\ub97c \uc0ac\uc6a9\ud55c\ub2e4. \uc774\ub807\uac8c \ud558\uba74 \ub364\ud504 \ud30c\uc77c\uc774 \uc791\uc544\uc9c0\uace0 \ud30c\uc77c\uc744 \ub2e4\uc2dc \uc77d\uc5b4 \uc62c \ub54c \uc0bd\uc785 \uc18d\ub3c4\ub97c \ube60\ub974\uac8c \ud560 \uc218\uac00 \uc788\ub2e4.<\/p>\n

–fields-terminated-by=name
\n–fields-enclosed-by=name
\n–fields-optionally-enclosed-by=name
\n–fields-escaped-by=name
\n–lines-terminated-By=name
\n\uc774\ub7ec\ud55c \uc635\uc158\uc740 -T \uc635\uc158\uacfc \ud568\uaed8 \uc0ac\uc6a9\ud55c\ub2e4. LOAD DATA INFILE \uc758 \ub300\uc751\ud558\ub294 \ub9c8\ub514\uc640 \uac19\uc740 \uc758\ubbf8\ub97c \uac00\uc9c4\ub2e4.<\/p>\n

-x, –first-slave
\n\ubaa8\ub4e0 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uc758 \ubaa8\ub4e0 \ud14c\uc774\ube14\uc744 \ub77d.
\n\uae30\ub2a5 \uc0ad\uc81c\ub428. \ud604\uc7ac\ub294 –lock-all-tables\ub85c \ubc14\ub00c\uc5c8\uc74c.<\/p>\n

-F, –flush-logs
\n\ub364\ud504\ub97c \uac1c\uc2dc\ud558\uae30 \uc804\uc5d0 ,MySQL \uc11c\ubc84\ub0b4\uc758 \ub85c\uadf8 \ud30c\uc77c\uc744 \ud50c\ub798\uc2dc \ud55c\ub2e4. \uc8fc\uc758: \uc774 \uc635\uc158\uc744 –all-databases(\ub610\ub294 -A) \uc635\uc158\uacfc \uc870\ud569\ud574 \uc0ac\uc6a9\ud588\uc744 \uacbd\uc6b0 , \ub85c\uadf8\ub294\uac01 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uc758 \ub364\ud504 \ub9c8\ub2e4\ud50c\ub798\uc2dc \ub41c\ub2e4.
\n\ud55c\uac00\uc9c0 \uc608\uc678\ub294 –lock-all-tables \ub610\ub294 –master-data\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\uc774\ub2e4: \uc774\uc640 \uac19\uc740 \uacbd\uc6b0, \ub85c\uadf8\ub294 \ubaa8\ub4e0 \ud14c\uc774\ube14\uc774 \uc7a0\uae30\ub294 \uc2dc\uc810\uc5d0 \uc624\uc9c1 \ud55c\ubc88\ub9cc \ud50c\ub7ec\uc2dc\ub41c\ub2e4. \ub9cc\uc77c \ub3d9\uc77c\ud55c \uc2dc\uc810\uc5d0 \ub364\ud504 \ubc0f \ub85c\uadf8 \ud50c\ub7ec\uc2dc\uac00 \uc77c\uc5b4\ub098\ub3c4\ub85d \ud558\uae30 \uc704\ud574\uc11c\ub294, –flush-logs\ub97c –lock-all-tables \ub610\ub294 –master-data\uc640 \ud568\uaed8 \uc0ac\uc6a9\ud558\ub3c4\ub85d \ud55c\ub2e4.<\/p>\n

-f, –force
\n\ud14c\uc774\ube14 \ub364\ud504\uc911\uc5d0SQL \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud574\ub3c4 \uc18d\ud589\ud55c\ub2e4.<\/p>\n

-?, –help
\n\ud5ec\ud504 \uba54\uc138\uc9c0\ub97c \ud45c\uc2dc\ud574 \uc885\ub8cc\ud55c\ub2e4.<\/p>\n

–hex-blob
\n16\uc9c4\ubc95(hexadecimal)\uc744 \uc0ac\uc6a9\ud574\uc11c \ubc14\uc774\ub108\ub9ac \uceec\ub7fc\uc744 \ub364\ud504\ud55c\ub2e4 (\uc608\ub97c \ub4e4\uba74, ‘abc’\ub294 0x616263\uac00 \ub41c\ub2e4). \uc774\ub807\uac8c \ud560 \uc218 \uc788\ub294 \ub370\uc774\ud130 \ud0c0\uc785\uc740 BINARY, VARBINARY, BLOB \uc774\ub2e4. MySQL 5.0.13\uae4c\uc9c0\ub294, BIT \uceec\ub7fc\ub3c4 \ud574\ub2f9\ub41c\ub2e4.<\/p>\n

-h, –host=name
\n\uc9c0\uc815\ud55c \ud638\uc2a4\ud2b8\uc758 MySQL \uc11c\ubc84\ub85c\ubd80\ud130 \ub370\uc774\ud130\ub97c \ub364\ud504 \ud55c\ub2e4. \ub514\ud3f4\ud2b8\uc758 \ud638\uc2a4\ud2b8\ub294 localhost.<\/p>\n

–ignore-table=xien.test
\nxien db\uc758 test table \uc740 dump\ud558\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n

–insert-ignore
\nINSERT \uba85\ub839\ubb38\uc744 IGNORE \uc635\uc158\uacfc \ud568\uaed8 \uc791\uc131\ud55c\ub2e4.<\/p>\n

-x, –lock-all-tables
\n\ubaa8\ub4e0 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc5d0 \uac78\uccd0\uc11c \ubaa8\ub4e0 \ud14c\uc774\ube14\uc744 \uc7a0\uadfc\ub2e4. \uc774\uac83\uc740 \uc804\uccb4 \ub364\ud504 \uc8fc\uae30\uc5d0 \ub300\ud55c \uae00\ub85c\ubc8c\uc77d\uae30 \uc7a0\uae08\uc744 \ud1b5\ud574 \uc5bb\uc744 \uc218 \uc788\ub2e4. \uc774 \uc635\uc158\uc740 \uc790\ub3d9\uc73c\ub85c –single-transaction –lock-tables\ub97c \uc624\ud504(Off)\uc2dc\ud0a8\ub2e4.<\/p>\n

-l, –lock-tables
\n\ub364\ud504\ub97c \ud558\uae30 \uc804\uc5d0 \ubaa8\ub4e0 \ud14c\uc774\ube14\uc744 \uc7a0\uadfc\ub2e4. MyISAM \ud14c\uc774\ube14\uc758 \uacbd\uc6b0\uc5d0\ub294 \ub3d9\uc2dc \uc0bd\uc785\uc744 \ud5c8\uc6a9\ud558\uae30 \uc704\ud574\uc11c \ud14c\uc774\ube14\uc744 READ LOCAL\ub85c \uc7a0\uadfc\ub2e4. InnoDB \ubc0f BDB\uc640 \uac19\uc740 \ud2b8\ub79c\uc81d\uc158\uc774 \ub418\ub294 \ud14c\uc774\ube14\uc758 \uacbd\uc6b0, –single-transaction\uc774 \ubcf4\ub2e4 \uc88b\uc740 \uc635\uc158\uc774 \ub418\ub294\ub370, \uadf8 \uc774\uc720\ub294 \uc774\uac83\uc740 \ud14c\uc774\ube14\uc744 \uc804\ud600 \uc7a0\uae00 \ud544\uc694\uac00 \uc5c6\uae30 \ub54c\ubb38\uc774\ub2e4.
\n\uc5ec\ub7ec \uac1c\uc758 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\ub97c \ub364\ud504\ud560 \ub54c\uc5d0\ub294, –lock-tables\uc740 \uac01\uac01\uc758 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc5d0 \ub300\ud574\uc11c \ud14c\uc774\ube14\uc744 \uac1c\ubcc4\uc801\uc73c\ub85c \uc7a0\uadfc\ub2e4\ub294 \uc810\uc744 \uc54c\uc544\ub450\uae30 \ubc14\ub780\ub2e4. \ub530\ub77c\uc11c, \uc774 \uc635\uc158\uc740 \ub364\ud504 \ud30c\uc77c\uc5d0 \uc788\ub294 \ud14c\uc774\ube14\uc774 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\uac04\uc5d0 \ub17c\ub9ac\uc801\uc73c\ub85c \uc77c\uad00\uc131\uc744 \uac00\uc9c0\ub294 \uac83\uc5d0 \ub300\ud574\uc11c\ub294 \ubcf4\uc7a5\uc744 \ud558\uc9c0 \uc54a\ub294\ub2e4. \uc11c\ub85c \ub2e4\ub978 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc5d0 \uc788\ub294 \ud14c\uc774\ube14\ub4e4\uc740 \uc644\ubcbd\ud558\uac8c \ud2c0\ub9b0 \uc0c1\ud0dc\uc5d0\uc11c \ub364\ud504\uac00 \ub41c\ub2e4.
\n–master-data[=#]
\n\ubc14\uc774\ub108\ub9ac \ub85c\uadf8 \ud30c\uc77c \uc774\ub984\uacfc \uc704\uce58(position)\uc744 \uacb0\uacfc\uc5d0 \uc791\uc131\ud55c\ub2e4. \uc774 \uc635\uc158\uc740 RELOAD \uad8c\ud55c\uc774 \ud544\uc694\ud558\uace0 \ubc14\uc774\ub108\ub9ac \ub85c\uadf8\ub294 \ubc18\ub4dc\uc2dc \ud65c\uc131\ud654 \ub418\uc5b4\uc57c \ud55c\ub2e4. \ub9cc\uc77c \uc774 \uc635\uc158 \uac12\uc774 1 \uc774\uba74, \uadf8 \uc704\uce58 \ubc0f \ud30c\uc77c \uc774\ub984\uc740 CHANGE MASTER \uba85\ub839\ubb38 \ud615\ud0dc\ub85c \ub364\ud504 \uacb0\uacfc\uc5d0 \uc791\uc131\ub418\ub294\ub370, \uc774\uac83\uc740 \uc2ac\ub808\uc774\ube0c\ub97c \uc124\uc815\ud558\uae30 \uc704\ud574 \uc774 SQL \ub364\ud504\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\uc5d0 \uc2ac\ub808\uc774\ube0c \uc11c\ubc84\ub85c \ud558\uc5ec\uae08 \ub9c8\uc2a4\ud130\uc758 \ubc14\uc774\ub108\ub9ac \ub85c\uadf8\uc5d0 \uc788\ub294 \uc62c\ubc14\ub978 \uc704\uce58\uc5d0\uc11c \uc2dc\uc791\uc744 \ud558\ub3c4\ub85d \ub9cc\ub4e0\ub2e4. \ub9cc\uc77c \uc774 \uc635\uc158 \uac12\uc774 2\uc640 \uac19\ub2e4\uba74, CHANGE MASTER \uba85\ub839\ubb38\uc740 SQL \ucf54\uba58\ud2b8\ucc98\ub7fc \uc791\uc131\ub41c\ub2e4. \ub9cc\uc77c \uac12\uc774 \uc0dd\ub7b5\ub418\uba74, \uc774\uac83\uc774 \ub514\ud3f4\ud2b8 \ub3d9\uc791\uc774 \ub41c\ub2e4.
\n–master-data \uc635\uc158\uc740 –single-transaction\uc744 \ud568\uaed8 \uc9c0\uc815\ud558\uc9c0 \uc54a\ub294 \ud55c, –lock-all-tables\ub97c \uc628(ON) \uc2dc\ud0a8\ub2e4 (\uc774\uc640 \uac19\uc740 \uacbd\uc6b0, \uae00\ub85c\ubc8c \uc77d\uae30 \uc7a0\uae08\uc740 \ub364\ud504\uac00 \uc2dc\uc791\ub418\ub294 \uc9e7\uc740 \uc2dc\uc810\uc5d0\ub9cc \uc5bb\uc744 \uc218 \uc788\ub2e4). –single-transaction\uc5d0 \ub300\ud55c \uc124\uba85\uc744 \ud568\uaed8 \ucc38\uc870\ud55c\ub2e4. \ubaa8\ub4e0 \uacbd\uc6b0\uc5d0, \ub85c\uadf8 \uc0c1\uc758 \ubaa8\ub4e0 \ub3d9\uc791\uc740 \uc815\ud655\ud788 \ub364\ud504\uac00 \uc77c\uc5b4\ub098\ub294 \uc2dc\uc810\uc5d0 \ubc1c\uc0dd\uc744 \ud55c\ub2e4. \uc774 \uc635\uc158\uc740 \uc790\ub3d9\uc73c\ub85c –lock-tables\ub97c \uc624\ud504(Off) \uc2dc\ud0a8\ub2e4.
\n–max_allowed_packet
\n\ud074\ub77c\uc774\uc5b8\ud2b8\/\uc11c\ubc84 \ud1b5\uc2e0\uc6a9 \ubc84\ud37c\uc758 \ucd5c\ub300 \ud06c\uae30. \ucd5c\ub300 \ud06c\uae30\ub294 1GB.<\/p>\n

–net_buffer_length=
\n\ubcf5\uc218 \ub808\ucf54\ub4dc \uc0bd\uc785 \uc2a4\ud14c\uc774\ud2b8\uba3c\ud2b8\ub97c \uc791\uc131\ud588\uc744 \ub54c\uc5d0 (–extended-insert \uc635\uc158 \ub610\ub294 –opt \uc635\uc158\uacfc \uac19\uc774 ) ,mysqldump \ub294 net_buffer_length \uae4c\uc9c0 \uc758 \uae38\uc774\uc758 \ub808\ucf54\ub4dc\ub97c \uc791\uc131\ud55c\ub2e4. \uc774 \ubcc0\uc218\ub97c \ud06c\uac8c \ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 ,MySQL \uc11c\ubc84\uc758 max_allowed_packet \ubcc0\uc218\uac00 net_buffer_length \ubcf4\ub2e4 \ud070 \uac83\uc744 \ud655\uc778\ud55c\ub2e4.<\/p>\n

–no-autocommit
\nset autocommit=0;
\nINSERT INTO `test` VALUES (‘\u523a’,1);
\ncommit;
\n\uac01\uac01\uc758 \ub364\ud504\ub41c \ud14c\uc774\ube14\uc5d0 \ub300\ud55c INSERT \uba85\ub839\ubb38\uc744 SET AUTOCOMMIT=0 \uacfcCOMMIT \uba85\ub839\ubb38\uc548\uc5d0 \ub123\ub294\ub2e4.<\/p>\n

-n, –no-create-db ( -A \uc0ac\uc6a9\uc758 \uacbd\uc6b0 )
\nCREATE DATABASE \/*!32312 IF NOT EXISTS*\/ `db_char` \/*!40100 DEFAULT CHARACTER SET latin1 *\/; \uc774 \uc5c6\uc5b4\uc9c4\ub2e4.
\n\ud558\uc9c0\ub9cc –databases \uc635\uc158 \ub610\ub294 –all-databases \uc635\uc158\uc744 \uc9c0\uc815\ud588\uc744 \uacbd\uc6b0\ub294 , \uc0c1\uae30\uc758 \ud589\uc774 \ucd94\uac00\ub41c\ub2e4.<\/p>\n

-t, –no-create-info
\n\ud14c\uc774\ube14 \uc791\uc131 \uc815\ubcf4(CREATE TABLE \uc2a4\ud14c\uc774\ud2b8\uba3c\ud2b8) \ub97c \uae30\uc785\ud558\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n

-d, –no-data
\n\ud14c\uc774\ube14\uc758 \ub808\ucf54\ub4dc \uc815\ubcf4\ub97c \ubaa8\ub450 \uae30\uc785\ud558\uc9c0 \uc54a\ub294\ub2e4. \ud14c\uc774\ube14\uc758 \uad6c\uc870\ub9cc\uc744 \ub364\ud504 \ud558\ub294 \uacbd\uc6b0 , \ub9e4\uc6b0 \ud3b8\ub9ac\ud558\ub2e4.<\/p>\n

-N, –no-set-names<\/p>\n

–opt
\n–quick –add-drop-table –add-locks –extended-insert –lock-tables \uc640 \uac19\ub2e4. MySQL \uc11c\ubc84\uc5d0 \uc77d\uc5b4\ub4e4\uc774\uae30 \uc704\ud55c \ucd5c\uace0 \uc18d\ub3c4 \ub364\ud504\ub97c \uc81c\uacf5\ud55c\ub2e4.<\/p>\n

–order-by-primary
\n\uc8fc\uc694(primary) \ud0a4 \ub610\ub294 \ub9e8 \ucc98\uc74c\uc758 \uc720\ub2c8\ud06c \uc778\ub371\uc2a4(\ub9cc\uc77c \uc778\ub371\uc2a4\uac00 \uc874\uc7ac\ud55c\ub2e4\uba74)\ub97c \uc0ac\uc6a9\ud574\uc11c \uac01\uac01\uc758 \ud14c\uc774\ube14 \uc5f4\uc744 \uc815\ub82c\ud55c\ub2e4. \uc774\uac83\uc740 InnoDB \ud14c\uc774\ube14 \uc548\uc73c\ub85c \uc9d1\uc5b4\ub123\uc744 MyISAM \ud14c\uc774\ube14\uc744 \ub364\ud504\ud560 \ub54c \uc720\uc6a9\ud558\uac8c \uc0ac\uc6a9\ub418\uc9c0\ub9cc, \ub364\ud504 \uc790\uccb4\ub97c \ub9e4\uc6b0 \uc624\ub798 \uac78\ub9ac\uac8c \ud55c\ub2e4.<\/p>\n

-p, –password[=name]
\n\uc11c\ubc84 \uc811\uc18d\uc2dc\uc5d0 \uc0ac\uc6a9\ud558\ub294 \ud328\uc2a4\uc6cc\ub4dc. ‘=your_pass’ \ubd80\ubd84\uc744 \uc9c0\uc815\ud558\uc9c0 \uc54a\uc73c\uba74 ,mysqldump \uc5d0 \uc758\ud574 \ud328\uc2a4\uc6cc\ub4dc\uc758 prompt\uac00 \ud45c\uc2dc\ub41c\ub2e4.<\/p>\n

-P, –port=#
\nTCP\/IP \uc811\uc18d\uc5d0 \uc0ac\uc6a9\ud558\ub294 \ud3ec\ud1a0 \ubc88\ud638<\/p>\n

–protocol=name
\n\uc0ac\uc6a9\ud558\ub294 \uc811\uc18d \ud504\ub85c\ud1a0\ucf5c\uc744 \uc9c0\uc815\ud55c\ub2e4.<\/p>\n

-q, –quick
\n\ucffc\ub9ac\ub97c \ubc84\ud37c \ud558\uc9c0 \uc54a\uace0 ,stdou \uc5d0 \uc9c1\uc811 \ub364\ud504 \ud55c\ub2e4. \uc774\uac83\uc744 \uc2e4\uc2dc\ud558\ub824\uba74,mysql_use_result() \ub97c \uc0ac\uc6a9\ud55c\ub2e4. \ud070 \ub364\ud504 \uc2dc\uc5d0 \ud2b9\ud788 \ud3b8\ub9ac\ud558\ub2e4.<\/p>\n

-Q, –quote-names
\nCREATE TABLE `test` (
\n`zzang` char(1) default NULL,
\n`good` int(1) default NULL
\n);
\n\ud14c\uc774\ube14\uba85 \ubc0f \uceec\ub7fc\uba85\uc744 \u2018`\uff07 \ubb38\uc790\ub85c \ub458\ub7ec\uc2fc\ub2e4.<\/p>\n

–skip-quote-name
\nCREATE TABLE test (
\nzzang char(1) default NULL,
\ngood int(1) default NULL
\n);<\/p>\n

-r, –result-file=name
\nmysqldump db > db.sql \uc774\ub807\uac8c \ud558\uc9c0 \uc54a\uc544\ub3c4
\nmysqldump db \u2013result-file=db \uc774\ub807\uac8c \ud30c\uc77c\ub85c \ub5a8\uc5b4\ub728\ub9b4 \uc218 \uc788\ub2e4.<\/p>\n

\uc9c0\uc815\ud55c \ud30c\uc77c\uc5d0\uc758 \uc9c1\uc811 \ucd9c\ub825. \uc774 \uc635\uc158\uc740 MSDOS \uc73c\ub85c \uc0ac\uc6a9\ud55c\ub2e4. \uac1c\ud589 ‘n’ \uc774 ‘nr'(\uac1c\ud589 + \ubcf5\uadc0) \uc5d0 \ubcc0\ud658\ub418\ub294 \uac83\uc744 \ub9c9\uae30 \ub54c\ubb38\uc5d0 \uc788\ub2e4.<\/p>\n

–set-charset
\n\/*!40101 SET NAMES utf8 *\/;
\nSET NAMES default_character_set\ub97c \uacb0\uacfc\uc5d0 \ucd94\uac00\ud55c\ub2e4. \uc774 \uc635\uc158\uc740 \ub514\ud3f4\ud2b8\ub85c \ud65c\uc131\ud654 \ub41c\ub2e4. SET NAMES \uba85\ub839\ubb38\uc744 \ubb34\uc2dc\ud558\uae30 \uc704\ud574\uc11c\ub294, –skip-set-charset\ub97c \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n

–skip-set-charset
\n\/*!40101 SET NAMES utf8 *\/; \ubd80\ubd84\uc774 \uc5c6\uc5b4\uc9c4\ub2e4.<\/p>\n

-O, –set-variable=name
\n\ubcc0\uc218\uc758 \uac12\uc744 \uc9c0\uc815\ud55c\ub2e4. \uc9c0\uc815 \uac00\ub2a5\ud55c \ubcc0\uc218\ub294 \uc774\ud558\uc5d0 \ub098\ud0c0\ub0b8\ub2e4.
\n\uc8fc\uc758: –set-variable=name=value \ubc0f -O name=value \uad6c\ubb38\uc740 ,MySQL 4.0\ubd80\ud130 \ud3d0\uc9c0. \ub300\uc2e0\uc5d0 –name=value \ub97c \uc0ac\uc6a9\ud558\ub294 \uac83.<\/p>\n

–single-transaction
\n\uc774 \uc635\uc158\uc740 , \uc11c\ubc84\ub85c\ubd80\ud130 \ub370\uc774\ud130\ub97c \ub364\ud504 \ud558\uae30 \uc804\uc5d0 ,BEGIN SQL \ucee4\uba58\ub4dc\ub97c \ubc1c\ud589\ud55c\ub2e4. \uc774\uac83\uc740 ,InnoDB \ud14c\uc774\ube14\uacfc READ_COMMITTED \ud2b8\ub79c\uc7ad\uc158(transaction) \ubd84\ub9ac \ub808\ubca8\ub85c \ud2b9\ubcc4\ud788 \ub3c4\uc6c0\uc774 \ub41c\ub2e4. \uc774 \ubaa8\ub4dc\uc5d0\uc11c\ub294 , \uc5b4\ub290 \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\ub3c4 \ube14\ub85d \ud558\ub294 \uc77c \uc5c6\uc774 ,BEGIN \uac00 \ubc1c\ud589\ub418\uc5c8\uc744 \ub54c\uc758 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uc758 \uc815\ud569\ud55c \uc0c1\ud0dc\ub97c \ub364\ud504 \ud560 \uc218 \uc788\ub2e4.<\/p>\n

\uc774 \uc635\uc158\uc744 \uc0ac\uc6a9\ud560 \ub54c\ub294 , \ud2b8\ub79c\uc7ad\uc158(transaction) \ud14c\uc774\ube14\ub9cc\uc774 \uc815\ud569 \uc0c1\ud0dc\ub85c \ub364\ud504 \ub418\ub294 \uac83\uc5d0 \uc8fc\uc758\ud55c\ub2e4. \uc608\ub97c \ub4e4\uba74 , \uc774 \uc635\uc158\uc73c\ub85c \ub364\ud504 \ub41c MyISAM \ud14c\uc774\ube14 \ub610\ub294 HEAP \ud14c\uc774\ube14\uc740 , \ubcc0\uacbd\ub418\uace0 \uc788\uc744 \uac00\ub2a5\uc131\uc774 \uc788\ub2e4.<\/p>\n

–single-transaction \uc635\uc158\uc740 \ubc84\uc83c 4.0.2 \uc73c\ub85c \ucd94\uac00\ub418\uc5c8\ub2e4. \uc774 \uc635\uc158\uc740 –lock-tables \uc635\uc158\uacfc\ub294 \uc0c1\ud638 \ubc30\ud0c0\uc801\uc774\ub2e4. LOCK TABLES (\uc740)\ub294 , \uc804\uc758 \ud2b8\ub79c\uc7ad\uc158(transaction)\ub97c \ubc8c\uc368 \uc704\ud0c1\ud558\uace0 \uc788\uae30 \ub54c\ubb38\uc5d0 \uc788\ub2e4.<\/p>\n

–skip-opt<\/p>\n

-S, –socket=name
\nlocalhost(\ub514\ud3f4\ud2b8 \ud638\uc2a4\ud2b8) (\uc640)\uacfc\uc758 \uc811\uc18d\uc5d0 \uc0ac\uc6a9\ud558\ub294 \uc18c\ucf13 \ud30c\uc77c<\/p>\n

-T, –tab=name
\n\uac01 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c SQL CREATE \ucee4\uba58\ub4dc\uac00 \ud3ec\ud568\ub418\ub294 table_name.sql \ud30c\uc77c , \ubc0f \uac01 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \ub370\uc774\ud130\uac00 \ud3ec\ud568\ub418\ub294 table_name.txt \ud30c\uc77c\uc744 \uc791\uc131\ud55c\ub2e4. .txt \ud30c\uc77c\uc758 \ud615\uc2dd\uc740 ,–fields-xxx \uc635\uc158 \ubc0f –lines–xxx \uc635\uc158\uc5d0 \uadfc\uac70\ud55c\ub2e4. \uc8fc\uc758: \uc774 \uc635\uc158\uc740 ,mysqldump \uc774 mysqld demon\uc640 \uac19\uc740 \uba38\uc2e0\uc73c\ub85c \uc2e4\ud589\ud558\uace0 \uc788\ub294 \uacbd\uc6b0\ub9cc \uc720\ud6a8. FILE \uad8c\ud55c\uc774 \uc788\ub294 MySQL \uc5b4\uce74\uc6b4\ud2b8\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \ud544\uc694. \uadf8\ub9ac\uace0 ,mysqld \ub97c \uc2e4\ud589\ud558\uace0 \uc788\ub294 \ub85c\uadf8\uc778 \uc720\uc800 \ub610\ub294 \uadf8\ub8f9(\ud1b5\uc0c1\uc740 \uc720\uc800 mysql, \uadf8\ub8f9 mysql) \uc5d0 , \uc9c0\uc815\ud55c \uc7a5\uc18c\uc5d0\uc11c\uc758 \ud30c\uc77c\uc758 \uc791\uc131 \ubc0f \uae30\uc785\ud574 \uad8c\ud55c\uc774 \ud544\uc694<\/p>\n

–tables
\n–databases(-B) \uc635\uc158\uc744 \ub367\uc4f0\uae30\ud55c\ub2e4<\/p>\n

-u, –user=name
\n\uc11c\ubc84\uc640\uc758 \uc811\uc18d\uc5d0 \uc0ac\uc6a9\ud558\ub294 MySQL \uc720\uc800\uba85. \ub514\ud3f4\ud2b8\uce58\ub294 \uc720\uc800\uc758 Unix \ub85c\uadf8\uc778\uba85<\/p>\n

-v, –verbose
\n\ud504\ub85c\uadf8\ub7a8\uc758 \uc2e4\ud589 \ub0b4\uc6a9\uc5d0 \uad00\ud55c \uc0c1\uc138 \uc815\ubcf4\ub97c \ucd9c\ub825\ud55c\ub2e4.<\/p>\n

-V, –version
\nmysqldump\u00a0 Ver 10.9 Distrib 4.1.18, for pc-linux-gnu (i686)
\n\ubc84\uc83c \uc815\ubcf4\ub97c \ucd9c\ub825\ud574 \uc885\ub8cc\ud55c\ub2e4.<\/p>\n

-w, –where=name<\/p>\n

–where=good<\/p>\n

— Dumping data for table `test`
\n—
\n— WHERE:\u00a0 good
\nINSERT INTO `test` VALUES (‘\u523a’,1);
\n\uc120\ud0dd\ud55c \ub808\ucf54\ub4dc\ub9cc\uc744 \ub364\ud504 \ud55c\ub2e4. \uc8fc\uc758: \ubc18\ub4dc\uc2dc \uc778\uc6a9\ubd80\ud638\ub85c \ub458\ub7ec\uc2f8\ub294 \uac83<\/p>\n

-X, –xml
\n1 \uac1c\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc815\ud615\uc2dd\uc758 XML\ub85c \ub364\ud504.
\n<?xml version=”1.0″?>
\n<mysqldump xmlns:xsi=”http:\/\/www.w3.org\/2001\/XMLSchema-instance<\/u><\/a>“>
\n<database name=”xien”>
\n<table_structure name=”test”>
\n<field Field=”zzang” Type=”char(1)” Null=”YES” Key=”” Extra=”” \/>
\n<field Field=”good” Type=”int(1)” Null=”YES” Key=”” Extra=”” \/>
\n<\/table_structure>
\n<table_data name=”test”>
\n<row>
\n<field name=”zzang”>\u523a<\/field>
\n<field name=”good”>1<\/field>
\n<\/row>
\n<\/table_data>
\n<\/database>
\n<\/mysqldump><\/p>\n

–tz-utc
\nSET TIME_ZONE=’+00:00’\ub97c \ub364\ud504 \ud30c\uc77c\uc5d0 \ucd94\uac00\ud574\uc11c TIMESTAMP \uceec\ub7fc\uc774 \uc11c\ub85c \ub2e4\ub978 \ud0c0\uc784 \uc874\uc5d0 \uc788\ub294 \uc11c\ubc84\uac04\uc5d0 \ub364\ud504\ub418\uace0 \ub9ac\ub85c\ub4dc\ub420 \uc218 \uc788\ub3c4\ub85d \ud55c\ub2e4. \uc774 \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc73c\uba74, TIMESTAMP \uceec\ub7fc\uc740 \ub85c\uceec \ubc0f \ubaa9\uc801 \uc11c\ubc84\uc758 \ud0c0\uc784 \uc874\uc5d0 \ub364\ud504 \ubc0f \ub9ac\ub85c\ub4dc \ub418\uace0, \uc774 \uacb0\uacfc\ub85c \uc778\ud574 \uac12\uc774 \ubcc0\ud558\uac8c \ub41c\ub2e4. –tz-utc\ub294 \ub514\ud3f4\ud2b8\ub85c \ud65c\uc131\ud654 \ub418\uc5b4 \uc788\uace0, –skip-tz-utc\ub97c \uc0ac\uc6a9\ud574\uc11c \ube44\ud65c\uc131\ud654 \uc2dc\ud0ac \uc218\uac00 \uc788\ub2e4. \uc774 \uc635\uc158\uc740 MySQL 5.0.15 \uc5d0\uc11c \ucd94\uac00 \ub418\uc5c8\ub2e4
\n–triggers
\n\uac01\uac01\uc758 \ub364\ud504 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \ud2b8\ub9ac\uac70\ub97c \ub364\ud504\ud55c\ub2e4. \uc774 \uc635\uc158\uc740 \ub514\ud3f4\ud2b8\ub85c \ud65c\uc131\ud654 \ub418\uc5b4 \uc788\ub2e4; –skip-triggers\ub85c \ube44 \ud65c\uc131\ud654 \uc2dc\ud0ac \uc218 \uc788\ub2e4.\uc774 \uc635\uc158\uc740 MySQL 5.0.11 \uc5d0 \ucd94\uac00 \ub418\uc5c8\ub2e4. \uc774\uc804\uc5d0\ub294, \ud2b8\ub9ac\uac70\ub97c \ub364\ud504\ud560 \uc218 \uc5c6\uc5c8\ub2e4.
\n–routines, -R
\n\ub364\ud504\ub41c \ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc5d0\uc11c \uc2a4\ud1a0\uc5b4\ub4dc \ub8e8\ud2f4(\ud568\uc218 \ubc0f \ud504\ub85c\uc2dc\uc800)\ub97c \ub364\ud504\ud55c\ub2e4. –routines\uc744 \uc0ac\uc6a9\ud574\uc11c \ub9cc\ub4e4\uc5b4\uc9c0\ub294 \uacb0\uacfc\ub294 CREATE PROCEDURE \ub8e8\ud2f4\uc744 \uc7ac \uc0dd\uc131\ud558\uae30 \uc704\ud55c CREATE FUNCTION \uba85\ub839\ubb38\uc744 \uac16\uac8c \ub41c\ub2e4. \ud558\uc9c0\ub9cc, \uc774\ub7ec\ud55c \uba85\ub839\ubb38\ub4e4\uc740 \ub8e8\ud2f4 \uc0dd\uc131 \ubc0f \uc218\uc815 \ud0c0\uc784 \uc2a4\ud0ec\ud504\uc640 \uac19\uc740 \uc18d\uc131\uc744 \uac00\uc9c0\uc9c0 \uc54a\ub294\ub2e4. \uc774\uac83\uc740 \ub8e8\ud2f4\uc774 \ub9ac\ub85c\ub4dc(reload)\ub420 \ub54c, \ub9ac\ub85c\ub4dc \uc2dc\uac04\uacfc \ub3d9\uc77c\ud55c \ud0c0\uc784 \uc2a4\ud0ec\ud504\ub97c \uac00\uc9c0\uace0\uc11c \uc0dd\uc131\ub41c\ub2e4\ub294 \uac83\uc744 \uc758\ubbf8\ud55c\ub2e4.
\n\ub9cc\uc77c \uc7ac \uc0dd\uc131\ub420 \ub8e8\ud2f4\uc774 \uc6d0\ub798\uc758 \ud0c0\uc784 \uc2a4\ud0ec\ud504 \uc18d\uc131\uc744 \uac00\uc9c0\ub3c4\ub85d \ud558\uae30 \uc704\ud574\uc11c\ub294, –routines\ub97c \uc0ac\uc6a9\ud558\uc9c0 \ub9d0\ub3c4\ub85d \ud55c\ub2e4. \ub300\uc2e0\uc5d0, mysql \ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc5d0 \ub300\ud574 \uc801\uc808\ud55c \uad8c\ud55c\uc744 \uac00\uc9c0\uace0 \uc788\ub294 MySQL \uacc4\uc815\uc744 \uc0ac\uc6a9\ud574\uc11c mysql.proc \ud14c\uc774\ube14\uc758 \ub0b4\uc6a9\ubb3c\uc744 \uc9c1\uc811 \ub364\ud504 \ubc0f \ub9ac\ub85c\ub4dc \ud558\ub3c4\ub85d \ud55c\ub2e4.
\n\uc774 \uc635\uc158\uc740 MySQL 5.0.13 \uc5d0 \ucd94\uac00\ub418\uc5c8\ub2e4. \uc774 \ubc84\uc804 \uc774\uc804\uc5d0\ub294 \uc2a4\ud1a0\uc5b4\ub4dc \ub8e8\ud2f4\uc744 \ub364\ud504\ud560 \uc218\uac00 \uc5c6\uc5c8\ub2e4. \ub8e8\ud2f4 DEFINER \uac12\uc740 5.0.20 \uc774\ud6c4\uc5d0 \ub364\ud504\uac00 \ub418\uc5c8\ub2e4. \uc774\uac83\uc740 5.0.20 \uc774\uc804\uc5d0\ub294, \ub8e8\ud2f4\uc774 \ub9ac\ub85c\ub4dc\ub420 \ub54c, \ub9ac\ub85c\ub529 \uc0ac\uc6a9\uc790\uc5d0 \ub300\ud574\uc11c \ub514\ud30c\uc774\ub108(definer) \uc14b\uc744 \uac00\uc9c0\uace0 \uc0dd\uc131\ub41c\ub2e4\ub294 \uac83\uc744 \uc758\ubbf8\ud558\ub294 \uac83\uc774\ub2e4. \ub9cc\uc77c \ub8e8\ud2f4\uc774 \uc6d0\ub798\uc758 \ub514\ud30c\uc774\ub108\ub97c \uac00\uc9c0\uace0 \uc7ac \uc0dd\uc131\ub418\ub3c4\ub85d \ud558\uace0\uc790 \ud55c\ub2e4\uba74, \uc55e\uc5d0\uc11c \uc124\uba85\ud55c \ubc29\uc2dd\uc73c\ub85c mysql.proc \ud14c\uc774\ube14\uc758 \ub0b4\uc6a9\ubb3c\uc744 \uc9c1\uc811 \ub364\ud504 \ubc0f \ub85c\ub4dc\ud55c\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"

http:\/\/egloos.zum.com\/simonshin\/v\/2247509   1. mysqldump \uc635\uc158 \uc911 binary log \uc758 \ud3ec\uc9c0\uc158 \uc815\ubcf4 \uac19\uc774 dump \ud558\uae30 \/usr\/local\/mysql\/bin\/mysqldump -uroot -p –master-data=2\u00a0 > \/data\/\u2026\/backup.sql \uc774 \uba85\ub839\uc5b4 \uc911\uc5d0\uc11c “–master-data=2” \uc635\uc158\uc744 \uc8fc\uac8c \ub418\uba74 \ub364\ud504 \uc2dc\uc810\uc758 binary log\uc758 \ud3ec\uc9c0\uc158 \uc815\ubcf4\uac00 \uac19\uc774 Dump \ub418\uac8c \ub41c\ub2e4. Dump\ub41c \ud30c\uc77c\uc744 \uc5d0\ub514\ud130\ub85c \uc5f4\uc5b4\ubcf4\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \ub0b4\uc6a9\uc774 \ub098\uc628\ub2e4. 2. Table Lock \uac78\uae30 FLUSH TABLES WITH READ LOCK; \/\/Table Lock \uac78\uae30 UNLOCK TABLES; \/\/Table Lock \ud480\uae30 3. Mysqldump options mysqldump\u00a0 Ver 10.9 Distrib 4.1.18, for pc-linux-gnu (i686) By Igor Romanenko, Monty, Jani & Sinisa This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Dumping definition and data mysql database or table Usage: mysqldump [OPTIONS] database [tables] OR\u00a0\u00a0\u00a0\u00a0 mysqldump [OPTIONS] –databases [OPTIONS] DB1 [DB2 DB3…] OR\u00a0\u00a0\u00a0\u00a0 mysqldump [OPTIONS] –all-databases [OPTIONS] Default options are read from the following files in the given order: \/etc\/my.cnf \/home\/irteam\/naver\/mysql-4.1.18\/var\/my.cnf ~\/.my.cnf The following groups are read: mysqldump client The following options may be given as the first argument: –print-defaults Print the program argument list and exit x –no-defaults Don’t read default options from any options file x –defaults-file=# Only read default options from the given file x –defaults-extra-file= Read this file after the global files are […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"ngg_post_thumbnail":0,"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[12,5],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5q9Zn-cX","jetpack-related-posts":[{"id":801,"url":"https:\/\/blog.box.kr\/?p=801","url_meta":{"origin":803,"position":0},"title":"[scrap] MySQL Replication \uc124\uc815\uacfc \uba87 \uac00\uc9c0 \ud14c\uc2a4\ud2b8","date":"2015-05-18","format":false,"excerpt":"http:\/\/blog.hibrainapps.net\/130 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 MySQL\uc744 DB\ub85c \uc0ac\uc6a9\ud558\uba74\uc11c \uc11c\ubc84\uc758 \ubd80\ud558 \ubd84\uc0b0\uc744 \uc704\ud55c \ubc29\ubc95 \uc911 \ud558\ub098\ub85c Replication \uc744 \uc0ac\uc6a9\ud55c\ub2e4. Replication \uc740 Master \ud558\ub098\uc5d0 n\uac1c\uc758 Slave\ub85c \uc9c0\uc815\uc774 \uac00\ub2a5\ud558\ub2e4. Slave\ub294 \ub2e4\uc2dc Master \uc5ed\ud560\uc744 \ud560\uc218 \uc788\uc73c\uba70 \uc5ed\uc2dc \ub610 \ub2e4\ub978 n\uac1c\uc758 Slave\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4. \ubd80\ud558 \ubd84\uc0b0\uc758 \ud6a8\uacfc\ub294 inser,update \ub4f1 \ubcc0\uacbd\uacfc \uad00\ub828\ub41c \ubaa8\ub4e0 \uc791\uc5c5\uc740\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":687,"url":"https:\/\/blog.box.kr\/?p=687","url_meta":{"origin":803,"position":1},"title":"[\ud38c]MariaDB \uc124\uc815 \ud30c\uc77c my.cnf","date":"2015-04-13","format":false,"excerpt":"http:\/\/www.programkr.com\/blog\/MUDM5ADMwYT2.html \u00a0 \u00a0 # MariaDB database server configuration file. # # You can copy this file to one of: # - \"\/etc\/mysql\/my.cnf\" to set global options, # - \"~\/.my.cnf\" to set user-specific options. # # One can use all long options that the program supports. # Run program with --help\u2026","rel":"","context":"In "\uae30\uc220\uc790\ub8cc"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":809,"url":"https:\/\/blog.box.kr\/?p=809","url_meta":{"origin":803,"position":2},"title":"[scrap] Replication Startup Options","date":"2015-05-18","format":false,"excerpt":"http:\/\/simonshin.egloos.com\/2247545 \u00a0 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc2a4\ud0c0\ud2b8\uc5c5 \uc635\uc158\ub4e4 \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \uc5ec\ub7ec\ubd84\uc774 \uc2ac\ub808\uc774\ube0c \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc11c\ubc84\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc635\uc158\ub4e4\uc5d0 \ub300\ud574 \uc124\uba85\ud558\uae30\ub85c \ud55c\ub2e4. \uc774 \uc635\uc158\ub4e4\uc740 \uba85\ub839\uc5b4 \ub77c\uc778 \ub610\ub294 \uc635\uc158 \ud30c\uc77c\uc5d0\uc11c \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4. \ub9c8\uc2a4\ud130\uc640 \uac01 \uc2ac\ub808\uc774\ube0c\uc5d0\uc11c, \uc5ec\ub7ec\ubd84\uc740 \uace0\uc720\uc758 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 ID\ub97c \uc124\uc815\ud558\uae30 \uc704\ud574\uc11c \ubc18\ub4dc\uc2dc server-id\uc635\uc158\uc744 \uc0ac\uc6a9\ud574\uc57c \ud55c\ub2e4. \uac01 \uc11c\ubc84\uc758 \uacbd\uc6b0, \uc5ec\ub7ec\ubd84\uc740 1 \uc5d0\uc11c 232 \u2013 1\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1161,"url":"https:\/\/blog.box.kr\/?p=1161","url_meta":{"origin":803,"position":3},"title":"POCO \ub77c\uc774\ube0c\ub7ec\ub9ac\ub85c MYSQL Query\uc2dc\uc5d0 “unknown field type” \uc624\ub958","date":"2016-08-31","format":false,"excerpt":"\uc6d0\uc778\uc740.. \u00a0POCO\uc5d0\uc11c\u00a0MYSQL\uc758 TIMESTAMP \ud0c0\uc785\uc744 \uc9c0\uc6d0 \ud558\uc9c0 \uc54a\uc544\uc11c \uc0dd\uae34 \ubb38\uc81c. \uc774\ub97c \ud574\uacb0 \ud558\uae30 \uc704\ud574\uc11c POCO\ub77c\uc774\ube0c\ub7ec\ub9ac \uc18c\uc2a4\ub97c \uc544\ub798\uc640 \uac19\uc774 \uc218\uc815 \ud55c \ud6c4\uc5d0 \uc7ac \ucef4\ud30c\uc77c \ud574\uc900\ub2e4. POCO \uc18c\uc2a4 \ud3f4\ub354\uc5d0\uc11c Data\/MySQL\/src\/ResultMetadata.cpp \uc758 \ub0b4\uc6a9\uc744 \uc544\ub798\uc640 \uac19\uc774 \uc218\uc815 std::size_t fieldSize(const MYSQL_FIELD& field) \/\/\/ Convert field MySQL-type and field MySQL-length to actual field length { ... case\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":746,"url":"https:\/\/blog.box.kr\/?p=746","url_meta":{"origin":803,"position":4},"title":"How to find MySQL binary logs, error logs, temporary files?","date":"2015-05-08","format":false,"excerpt":"Have you ever spent a lot of time trying to locate where MySQL keeps some file? Here is a quick way to find all this information in one place. The obvious way is through examining database options in\u00a0my.cnf\u00a0or looking at the output of\u00a0SHOW GLOBAL VARIABLES. But not every path may\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":521,"url":"https:\/\/blog.box.kr\/?p=521","url_meta":{"origin":803,"position":5},"title":"MYSql \uc811\uc18d \ud504\ub85c\ud1a0\ucf5c \ubb38\uc81c","date":"2014-12-29","format":false,"excerpt":"Q1. \u00a0Mysql \uc811\uc18d\uc2dc\uc5d0 \"\u00a0MYSQL ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option 'secure_auth' enabled)\u00a0\" \uc624\ub958 \ubc1c\uc0dd \uc6d0\uc778: \uc0ac\uc6a9\uc790 \uc554\ud638 \ud574\uc26c\uac12\uc744 \uc608\uc804 \uac83\uc744 \uc0ac\uc6a9\ud574\uc11c \uc0dd\uae30\ub294 \ubb38\uc81c \ud574\uacb0 1 : \u00a0\u00a0--skip-secure-auth \u00a0\uc635\uc158 \uc0ac\uc6a9 => \uc811\uc18d \ud560\ub54c Mysql\uc758 \ud074\ub77c\uc774\uc5b8\ud2b8\uc758 \uc554\ud638 Hash\uc218\uc900\uc744 \ub0ae \ucdb0\uc11c \uc811\uc18d ( \uc784\uc2dc\uc801\uc778 \ubc29\ubc95 )\u00a0\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/803"}],"collection":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=803"}],"version-history":[{"count":0,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/803\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=803"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=803"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=803"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}