mysqldump --help (윈도우) > MYSQL Q&A

본문 바로가기
사이트 내 전체검색

MYSQL Q&A


mysqldump --help (윈도우)

페이지 정보

작성자 no_profile 이즈 쪽지보내기 자기소개 아이디로 검색 전체게시물 댓글 0건 조회 3,955회 작성일 06-03-23 19:46

본문

mysqldump  Ver 9.11 Distrib 4.0.26, for Win32 (ia32)
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    mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR    mysqldump [OPTIONS] --all-databases [OPTIONS]

Default options are read from the following files in the given order:
C:\WINDOWS\my.ini C:\WINDOWS\my.cnf C:\my.ini C:\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
--no-defaults          Don't read default options from any options file
--defaults-file=#      Only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read
  -A, --all-databases Dump all the databases. This will be same as --databases
                      with all databases selected.
  -a, --all          Include all MySQL specific create options.
  --add-drop-table    Add a 'drop table' before each create.
  --add-locks        Add locks around insert statements.
  --allow-keywords    Allow creation of column names that are keywords.
  --character-sets-dir=name
                      Directory where character sets are
  -i, --comments      Write additional information.
  -c, --complete-insert
                      Use complete insert statements.
  -C, --compress      Use compression in server/client protocol.
  -B, --databases    To dump several databases. Note the difference in usage;
                      In this case no tables are given. All name arguments are
                      regarded as databasenames. 'USE db_name;' will be
                      included in the output.
  -#, --debug[=name]  Output debug log. Often this is 'd:t:o,filename'.
  --default-character-set=name
                      Set the default character set.
  --delayed-insert    Insert rows with INSERT DELAYED.
  --delete-master-logs
                      Delete logs on master after backup. This automatically
                      enables --first-slave.
  -K, --disable-keys  '/*!40000 ALTER TABLE tb_name DISABLE KEYS */; and
                      '/*!40000 ALTER TABLE tb_name ENABLE KEYS */; will be put
                      in the output.
  -e, --extended-insert
                      Allows utilization of the new, much faster INSERT syntax.
  --fields-terminated-by=name
                      Fields in the textfile are terminated by ...
  --fields-enclosed-by=name
                      Fields in the importfile are enclosed by ...
  --fields-optionally-enclosed-by=name
                      Fields in the i.file are opt. enclosed by ...
  --fields-escaped-by=name
                      Fields in the i.file are escaped by ...
  -x, --first-slave  Locks all tables across all databases.
  -F, --flush-logs    Flush 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.
  -f, --force        Continue even if we get an sql-error.
  -?, --help          Display this help message and exit.
  --hex-blob          Dump binary strings (CHAR BINARY, VARCHAR BINARY, BLOB)
                      in hexadecimal format.
  -h, --host=name    Connect to host.
  --lines-terminated-by=name
                      Lines in the i.file are terminated by ...
  -l, --lock-tables  Lock all tables for read.
  --master-data      This causes the master position and filename to be
                      appended to your output. This automatically enables
                      --first-slave.
  --no-autocommit    Wrap tables with autocommit/commit statements.
  -n, --no-create-db  '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
                      given.}
  -t, --no-create-info
                      Don't write table creation info.
  -d, --no-data      No row information.
  --opt              Same as --add-drop-table --add-locks --all --quick
                      --extended-insert --lock-tables --disable-keys
  -p, --password[=name]
                      Password to use when connecting to server. If password is
                      not given it's solicited on the tty.
  -W, --pipe          Use named pipes to connect to server
  -P, --port=#        Port number to use for connection.
  -q, --quick        Don't buffer query, dump directly to stdout.
  -Q, --quote-names  Quote table and column names with a `
  -r, --result-file=name
                      Direct output to a given file. This option should be used
                      in MSDOS, because it prevents new line '\n' from being
                      converted to '\r\n' (carriage return + line feed).
  -O, --set-variable=name
                      Change the value of a variable. Please note that this
                      option is deprecated; you can set variables directly with
                      --variable-name=value.
  --single-transaction
                      Dump all tables in single transaction to get consistent
                      snapshot. Mutually exclusive with --lock-tables.
  -S, --socket=name  Socket file to use for connection.
  -T, --tab=name      Creates 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.
  --tables            Overrides option --databases (-B).
  -u, --user=name    User for login if not current user.
  -v, --verbose      Print info about the various stages.
  -V, --version      Output version information and exit.
  -w, --where=name    Dump only selected records; QUOTES mandatory!
  -X, --xml          Dump a database as well formed XML.
  --max_allowed_packet=#
  --net_buffer_length=#

Variables (--variable-name=value)
and boolean options {FALSE|TRUE}  Value (after reading options)
--------------------------------- -----------------------------
all-databases                    FALSE
all                              FALSE
add-drop-table                    FALSE
add-locks                        FALSE
allow-keywords                    FALSE
character-sets-dir                (No default value)
comments                          TRUE
complete-insert                  FALSE
compress                          FALSE
databases                        FALSE
default-character-set            (No default value)
delayed-insert                    FALSE
disable-keys                      FALSE
extended-insert                  FALSE
fields-terminated-by              (No default value)
fields-enclosed-by                (No default value)
fields-optionally-enclosed-by    (No default value)
fields-escaped-by                (No default value)
first-slave                      FALSE
flush-logs                        FALSE
force                            FALSE
hex-blob                          FALSE
host                              (No default value)
lines-terminated-by              (No default value)
lock-tables                      FALSE
no-autocommit                    FALSE
no-create-db                      FALSE
no-create-info                    FALSE
no-data                          FALSE
port                              3306
quick                            FALSE
quote-names                      FALSE
single-transaction                FALSE
socket                            (No default value)
tab                              (No default value)
user                              (No default value)
verbose                          FALSE
where                            (No default value)
max_allowed_packet                25165824
net_buffer_length                1047551

댓글목록

등록된 댓글이 없습니다.

Total 46건 1 페이지
MYSQL Q&A 목록
번호 제목 글쓴이 조회 날짜
46 뉴어 이름으로 검색 4734 03-18
45 디비 이름으로 검색 5875 03-18
44 no_profile 관리자 쪽지보내기 자기소개 아이디로 검색 전체게시물 7151 06-17
43 no_profile 이즈 쪽지보내기 자기소개 아이디로 검색 전체게시물 3399 02-21
42 no_profile 이즈 쪽지보내기 자기소개 아이디로 검색 전체게시물 4064 02-21
41 no_profile 이즈 쪽지보내기 자기소개 아이디로 검색 전체게시물 8083 09-15
40 no_profile 이즈 쪽지보내기 자기소개 아이디로 검색 전체게시물 4365 09-15
39 no_profile 이즈 쪽지보내기 자기소개 아이디로 검색 전체게시물 5963 08-25
38 no_profile 이즈 쪽지보내기 자기소개 아이디로 검색 전체게시물 1940 03-25
37 no_profile 이즈 쪽지보내기 자기소개 아이디로 검색 전체게시물 1933 03-25
36 no_profile 이즈 쪽지보내기 자기소개 아이디로 검색 전체게시물 2434 03-25
열람중 no_profile 이즈 쪽지보내기 자기소개 아이디로 검색 전체게시물 3956 03-23
34 no_profile 이즈 쪽지보내기 자기소개 아이디로 검색 전체게시물 2248 03-22
33 no_profile 119 쪽지보내기 자기소개 아이디로 검색 전체게시물 2692 03-15
32 no_profile 119 쪽지보내기 자기소개 아이디로 검색 전체게시물 3759 03-15
31 no_profile 이즈 쪽지보내기 자기소개 아이디로 검색 전체게시물 3257 03-11
게시물 검색

회원로그인

설문조사

현재 사용하시는 os 는?

접속자집계

오늘
199
어제
432
최대
733
전체
181,320

그누보드5
Copyright © www.qdata.co.kr. All rights reserved.