Created
October 25, 2013 09:39
-
-
Save kamipo/7152154 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 18:37:00.000000000 +0900 | |
+++ /dev/fd/12 2013-10-25 18:37:00.000000000 +0900 | |
@@ -1,4 +1,5 @@ | |
mysqldump Ver 10.13 Distrib 5.6.14, for osx10.8 (x86_64) | |
+Copyright (c) 2009-2013 Percona LLC and/or its affiliates | |
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. | |
Oracle is a registered trademark of Oracle Corporation and/or its | |
@@ -11,7 +12,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/5.6.14-q4m-0.9.10/etc/my.cnf ~/.my.cnf | |
+/etc/my.cnf /etc/mysql/my.cnf /Users/kamipo/opt/mysql/percona-5.6.14-62.0/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. | |
@@ -65,7 +66,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[=#] This is a non-debug version. Catch this and exit. | |
+ -#, --debug[=name] Output debug log. | |
--debug-check Check memory and open file usage at exit. | |
--debug-info Print some debug info at exit. | |
--default-character-set=name | |
@@ -134,7 +135,12 @@ | |
--include-master-host-port | |
Adds 'MASTER_HOST=<host>, MASTER_PORT=<port>' to 'CHANGE | |
MASTER TO..' in dump produced with --dump-slave. | |
+ --innodb-optimize-keys | |
+ Use InnoDB fast index creation by creating secondary | |
+ indexes after dumping the data. | |
--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. | |
@@ -278,6 +284,7 @@ | |
compress FALSE | |
create-options TRUE | |
databases FALSE | |
debug-check FALSE | |
debug-info FALSE | |
default-character-set utf8 | |
@@ -297,7 +304,9 @@ | |
hex-blob FALSE | |
host (No default value) | |
include-master-host-port FALSE | |
+innodb-optimize-keys FALSE | |
insert-ignore FALSE | |
+ignore-create-error FALSE | |
lines-terminated-by (No default value) | |
lock-all-tables FALSE | |
lock-tables TRUE |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment