mysqldump [OPTIONS] database [tables]

For a complete description of this tool, run

mysqldump   help

. The most 

important command line options are:

    no data

No data information is extracted from the database, just the SQL statements 

for creating the tables and indexes. This option is used for extracting DDL 

statements only.

    no create info

No SQL statements for creating the exported table is extracted from the 

database. So, this option should be used for exporting data only. The output 

file containing the data can be loaded into a DB2 table.

    tab=

This option creates a text file with the DDL (

.sql

) and a tabulator 

separated text file with the data (

.txt

) in the given path for each 

specified table. This option only works when the utility is run on the same 

machine as the MySQL daemon. If this option is not specified, 

INSERT

statements for each row are created.

Example 6 1 shows the usage and output of the

 mysqldump

 command without 

the 

  no create info

 and the

   tab

 options. The output has DDL statements for 

table creation, and 

INSERT

 statements to insert data into the table.

 Chapter 6. Data porting 

129