Skip to content

Instantly share code, notes, and snippets.

@kamipo
Created October 25, 2013 09:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kamipo/7152154 to your computer and use it in GitHub Desktop.
Save kamipo/7152154 to your computer and use it in GitHub Desktop.
--- /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