Example 6 1   Usage of mysqldump without the   no create info and the   tab option

bash>mysqldump   user root itsodb testtable

   MySQL dump 9.10

   Host: localhost    Database: itsodb

   Server version       4.0.17 standard

   Table structure for table  testtable 

CREATE TABLE testtable (

  name char(10) default NULL,

  birthday date default NULL

) TYPE=MyISAM;

   Dumping data for table  testtable 

INSERT INTO testtable VALUES ( Klaus , 1978 07 03 );

INSERT INTO testtable VALUES ( Michael , 1974 03 20 );

INSERT INTO testtable VALUES ( Rakesh , 1977 09 26 );

Example 6 2 shows the usage and output of the 

mysqldump

 command with the 

  no create info

 but without the 

  tab

 options. The output has only 

INSERT

statements for each row to insert data into the table.

Example 6 2   Usage of mysqldump with the   no create info but without the   tab option

bash>mysqldump   no create info   user root itsodb testtable

   MySQL dump 9.10

   ...

   Dumping data for table  testtable 

INSERT INTO testtable VALUES ( Klaus , 1978 07 03 );

INSERT INTO testtable VALUES ( Michael , 1974 03 20 );

INSERT INTO testtable VALUES ( Rakesh , 1977 09 26 );

Example 6 3 shows the usage and output of the 

mysqldump

 command with the 

  no create info

 and the 

  tab

 options. The output is a file with the exported 

MySQL data. This file can be read by the DB2 

LOAD

 command.

130 

MySQL to DB2 UDB Conversion Guide