Data maintenance using the Mysqldump tool in MySQL

Using the Mysqldump tool, the basic usage is:

Shell> mysqldump [OPTIONS] database [tables]

If you do not give any tables, the entire database will be exported.

By executing mysqldump--help, you can get the options table supported by your mysqldump version.

Note that if you run mysqldump without--quick or--opt option, mysqldump will load the results before exporting

The entire result set into memory, if you are exporting a large database, this will probably be a problem.

Mysqldump supports the following options:

--add-locks

Add lock tables before each table is exported and then unlock table. (in order to allow faster insertion into MySQL).

--add-drop-table

Add a drop table before each create statement.

--allow-keywords

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

-C,--complete-insert

Use the full INSERT statement (with the column name).

-C,--compress

If both the client and the server support compression, compress all the information between the two.

--delayed

Inserts a row with the insert delayed command.

-E,--extended-insert

Use the new multiple-line insert syntax. (Gives a tighter and faster insert statement)

-#,--debug[=option_string]

Trace the use of the program (for debugging).