1:输出此信息的命令如下:

E:/Soft/Programs/MySQL/MySQL Server 5.6/bin/mysqldump --help > D:\tmp\mysqldump_help.txt

?2:帮助文档信息如下:

?

mysqldump ?Ver 10.13 Distrib 5.6.10, for Win32 (x86)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

?

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

?

Dumping structure and contents of MySQL databases and tables.

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 E:\Soft\Programs\MySQL\MySQL Server 5.6\my.ini E:\Soft\Programs\MySQL\MySQL Server 5.6\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 option file,

? ? ? ? ? ? ? ? ? ? ? ? except for login file.

--defaults-file=# ? ? ? Only read default options from the given file #.

--defaults-extra-file=# Read this file after the global files are read.

--defaults-group-suffix=#

? ? ? ? ? ? ? ? ? ? ? ? Also read groups with concat(group, suffix)

--login-path=# ? ? ? ? ?Read this path from the login file.

? -A, --all-databases Dump all the databases. This will be same as --databases

? ? ? ? ? ? ? ? ? ? ? with all databases selected.

? -Y, --all-tablespaces?

? ? ? ? ? ? ? ? ? ? ? Dump all the tablespaces.

? -y, --no-tablespaces?

? ? ? ? ? ? ? ? ? ? ? Do not dump any tablespace information.

? --add-drop-database Add a DROP DATABASE before each create.

? --add-drop-table ? ?Add a DROP TABLE before each create.

? ? ? ? ? ? ? ? ? ? ? (Defaults to on; use --skip-add-drop-table to disable.)

? --add-drop-trigger ?Add a DROP TRIGGER before each create.

? --add-locks ? ? ? ? Add locks around INSERT statements.

? ? ? ? ? ? ? ? ? ? ? (Defaults to on; use --skip-add-locks to disable.)

? --allow-keywords ? ?Allow creation of column names that are keywords.

? --apply-slave-statements?

? ? ? ? ? ? ? ? ? ? ? Adds 'STOP SLAVE' prior to 'CHANGE MASTER' and 'START

? ? ? ? ? ? ? ? ? ? ? SLAVE' to bottom of dump.

? --bind-address=name IP address to bind to.

? --character-sets-dir=name?

? ? ? ? ? ? ? ? ? ? ? Directory for character set files.

? -i, --comments ? ? ?Write additional information.

? ? ? ? ? ? ? ? ? ? ? (Defaults to on; use --skip-comments to disable.)

? --compatible=name ? Change the dump to be compatible with a given mode. By

? ? ? ? ? ? ? ? ? ? ? default tables are dumped in a format optimized for

? ? ? ? ? ? ? ? ? ? ? MySQL. Legal modes are: ansi, mysql323, mysql40,

? ? ? ? ? ? ? ? ? ? ? postgresql, oracle, mssql, db2, maxdb, no_key_options,

? ? ? ? ? ? ? ? ? ? ? no_table_options, no_field_options. One can use several

? ? ? ? ? ? ? ? ? ? ? modes separated by commas. Note: Requires MySQL server

? ? ? ? ? ? ? ? ? ? ? version 4.1.0 or higher. This option is ignored with

? ? ? ? ? ? ? ? ? ? ? earlier server versions.

? --compact ? ? ? ? ? Give less verbose output (useful for debugging). Disables

? ? ? ? ? ? ? ? ? ? ? structure comments and header/footer constructs. ?Enables

? ? ? ? ? ? ? ? ? ? ? options --skip-add-drop-table --skip-add-locks

? ? ? ? ? ? ? ? ? ? ? --skip-comments --skip-disable-keys --skip-se