Created
October 25, 2013 10:33
-
-
Save kamipo/7152690 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--- /dev/fd/11 2013-10-25 19:31:16.000000000 +0900 | |
+++ /dev/fd/12 2013-10-25 19:31:16.000000000 +0900 | |
@@ -1,5 +1,4 @@ | |
-mysqldump Ver 10.13 Distrib 5.6.14, for osx10.8 (x86_64) | |
-Copyright (c) 2009-2013 Percona LLC and/or its affiliates | |
+mysqldump Ver 10.13 Distrib 5.6.12, for osx10.8 (x86_64) | |
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. | |
Oracle is a registered trademark of Oracle Corporation and/or its | |
@@ -12,7 +11,7 @@ | |
OR mysqldump [OPTIONS] --all-databases [OPTIONS] | |
Default options are read from the following files in the given order: | |
-/etc/my.cnf /etc/mysql/my.cnf /Users/kamipo/opt/mysql/percona-5.6.14-62.0/etc/my.cnf ~/.my.cnf | |
+/etc/my.cnf /etc/mysql/my.cnf /Users/kamipo/opt/mysql/facebook-5.6.12/etc/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. | |
@@ -66,7 +65,7 @@ | |
this case no tables are given. All name arguments are | |
regarded as database names. 'USE db_name;' will be | |
included in the output. | |
- -#, --debug[=name] Output debug log. | |
+ -#, --debug[=#] This is a non-debug version. Catch this and exit. | |
--debug-check Check memory and open file usage at exit. | |
--debug-info Print some debug info at exit. | |
--default-character-set=name | |
@@ -138,9 +137,9 @@ | |
--innodb-optimize-keys | |
Use InnoDB fast index creation by creating secondary | |
indexes after dumping the data. | |
+ --print-ordering-key | |
+ Print the key used for ordering rows in the dumpfile | |
--insert-ignore Insert rows with INSERT IGNORE. | |
- --ignore-create-error | |
- Don't exit on show create table errors. | |
--lines-terminated-by=name | |
Lines in the output file are terminated by the given | |
string. | |
@@ -152,6 +151,11 @@ | |
-l, --lock-tables Lock all tables for read. | |
(Defaults to on; use --skip-lock-tables to disable.) | |
--log-error=name Append warnings and errors to given file. | |
+ --lra-size=# Set innodb_lra_size for the session of this dump. | |
+ --lra-sleep=# Set innodb_lra_sleep for the session of this dump. | |
+ --lra-n-node-recs-before-sleep=# | |
+ Set innodb_lra_n_node_recs_before_sleep for the session | |
+ of this dump. | |
--master-data[=#] This 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 | |
@@ -214,15 +218,14 @@ | |
--single-transaction | |
Creates 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. While a | |
- --single-transaction dump is in process, to ensure a | |
- valid dump file (correct table contents and binary log | |
- position), no other connection should use the following | |
- statements: ALTER TABLE, DROP TABLE, RENAME TABLE, | |
- TRUNCATE TABLE, as consistent snapshot is not isolated | |
- from them. Option automatically turns off --lock-tables. | |
+ InnoDB; the dump is NOT guaranteed to be consistent for | |
+ other storage engines. While a --single-transaction dump | |
+ is in process, to ensure a valid dump file (correct table | |
+ contents and binary log position), no other connection | |
+ should use the following statements: ALTER TABLE, DROP | |
+ TABLE, RENAME TABLE, TRUNCATE TABLE, as consistent | |
+ snapshot is not isolated from them. Option automatically | |
+ turns off --lock-tables. | |
--dump-date Put a dump date to the end of the output. | |
(Defaults to on; use --skip-dump-date to disable.) | |
--skip-opt Disable --opt. Disables --add-drop-table, --add-locks, | |
@@ -247,6 +250,8 @@ | |
path. (Create .sql and .txt files.) NOTE: This only works | |
if mysqldump is run on the same machine as the mysqld | |
server. | |
+ --timeout=# Set data transfer timeouts for server-side session | |
+ (default server setting, if 0) | |
--tables Overrides option --databases (-B). | |
--triggers Dump triggers for each dumped table. | |
(Defaults to on; use --skip-triggers to disable.) | |
@@ -284,7 +289,6 @@ | |
compress FALSE | |
create-options TRUE | |
databases FALSE | |
debug-check FALSE | |
debug-info FALSE | |
default-character-set utf8 | |
@@ -305,12 +309,15 @@ | |
host (No default value) | |
include-master-host-port FALSE | |
innodb-optimize-keys FALSE | |
+print-ordering-key FALSE | |
insert-ignore FALSE | |
-ignore-create-error FALSE | |
lines-terminated-by (No default value) | |
lock-all-tables FALSE | |
lock-tables TRUE | |
log-error (No default value) | |
+lra-size 0 | |
+lra-sleep 0 | |
+lra-n-node-recs-before-sleep 1024 | |
master-data 0 | |
max-allowed-packet 25165824 | |
net-buffer-length 1046528 | |
@@ -338,6 +345,7 @@ | |
ssl-crlpath (No default value) | |
ssl-verify-server-cert FALSE | |
tab (No default value) | |
+timeout 0 | |
triggers TRUE | |
tz-utc TRUE | |
user (No default value) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment