Skip to content

Instantly share code, notes, and snippets.

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