Mysqldump parameter Detailed

Parameters

Parameter description

--all-databases,-A

Export all databases.

Mysqldump-uroot-p--all-databases

--all-tablespaces, Y

Export all table spaces.

Mysqldump-uroot-p--all-databases--all-tablespaces

--no-tablespaces, Y

does not export any table space information.

Mysqldump-uroot-p--all-databases--no-tablespaces

--add-drop-database

Add a drop DATABASE statement before each database is created.

Mysqldump-uroot-p--all-databases--add-drop-database

--add-drop-table

Add a Drop Data table statement before each datasheet is created. (Default is open, use--skip-add-drop-table cancellation option)

Mysqldump-uroot-p--all-databases (Add drop statement by default)

Mysqldump-uroot-p--all-databases–skip-add-drop-table (Cancel drop statement)

--add-locks

Add lock tables before each table is exported and then unlock table. (Default is open, use--skip-add-locks cancellation option)

Mysqldump-uroot-p--all-databases (default add lock statement)

Mysqldump-uroot-p--all-databases–skip-add-locks (Cancel lock statement)

--allow-keywords

Allow creation of column names that are keywords. This is done by the table name prefix in each column name.

Mysqldump-uroot-p--all-databases--allow-keywords

--apply-slave-statements

Add ' STOP SLAVE ' before ' Change MASTER ' and add ' START SLAVE ' at the end of the export.

Mysqldump-uroot-p--all-databases--apply-slave-statements

--character-sets-dir

Directory of Character Set files

Mysqldump-uroot-p--all-databases--character-sets-dir=/usr/local/mysql/share/mysql/charsets

--comments

additional annotation information. Open by default, can be canceled with--skip-comments

Mysqldump-uroot-p--all-databases (Default record Note)

Mysqldump-uroot-p--all-databases--skip-comments (uncomment)

--compatible

The exported data will be compatible with other databases or older versions of MySQL. Values can be ANSI, mysql323, MYSQL40, PostgreSQL, Oracle, MSSQL, DB2, MAXDB, No_key_options, no_tables_options, no_field_options, etc. ，

To use a few values, separate them with commas. It does not guarantee full compatibility, but is as compatible as possible.

Mysqldump-uroot-p--all-databases--compatible=ansi

--compact