MySQLDUMP Options for Database Backup

MySQL Dump Options

Description

--add-drop-database

Add a DROP DATABASE statement before each CREATE DATABASE statement

--add-drop-table

Add a DROP TABLE statement before each CREATE TABLE statement

--add-locks

Surround each table dump with LOCK TABLES and UNLOCK TABLES statements

--all-databases

Dump all tables in all databases

--all-tablespaces

Adds to a table dump all SQL statements needed to create any tablespaces used by an NDB Cluster table

--complete-insert

Use complete INSERT statements that include column names

--create-options

Include all MySQL-specific table options in the CREATE TABLE statements

--databases

Dump several databases

--dump-date

Include dump date in "Dump completed on" comment if --comments is given

--extended-insert

Use multiple-row INSERT syntax that include several VALUES lists

--lock-all-tables

Deprecated. Now renamed to --lock-all-tables

--ignore-table=db_name.tbl_name

Do not dump the given table

--insert-ignore

Write INSERT statements with the IGNORE option

--lines-terminated-by=string

This option is used with the -T option and has the same meaning as the corresponding clause for LOAD DATA INFILE

--lock-all-tables

Lock all tables across all databases

--lock-tables

Lock all tables before dumping them

--no-create-db

This option suppresses the CREATE DATABASE statements

--no-create-info

Do not write CREATE TABLE statements that re-create each dumped table

--no-data

Do not write any table row information (that is, do not dump table contents)

--set-charset

Add SET NAMES default_character_set to the output

--single-transaction

This option issues a BEGIN SQL statement before dumping data from the server

--tables

Override the --databases or -B option

--triggers

Dump triggers for each dumped table

--verbose

Verbose mode

--version

Display version information and exit

--where='where_condition'

Dump only rows selected by the given WHERE condition

--xml

Produce XML output