Example 6 3   Usage of mysqldump with the   no create info and the   tab option

bash>mysqldump   no create info   tab=.   user root itsodb testtable

bash>cat testtable.txt

Klaus   1978 07 03

Michael 1974 03 20

Rakesh  1977 09 26

Example 6 4 shows the usage and output of the

 mysqldump

 command without 

the 

  no create info

 but with the 

  tab

 options. The output are two files: one 

containing the DDL statements for table creation, the other one with the exported 

MySQL data. The second file can be read by the DB2

 LOAD

 command.

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

bash>mysqldump   tab=.   user root itsodb testtable

bash>cat testtable.sql

   MySQL dump 9.10

   ...

   Table structure for table  testtable 

CREATE TABLE testtable (

  name char(10) default NULL,

  birthday date default NULL

) TYPE=MyISAM;

bash>cat testtable.txt

Klaus   1978 07 03

Michael 1974 03 20

Rakesh  1977 09 26

For porting the application data only, MTK generates the following call of 

mysqldump

:

mysqldump   no create info   tab=

  user= [  password=]  []

DB2 loading tools

DB2 UDB provides two utilities for loading data into a database: the

 LOAD

 and the 

IMPORT

 command.

In general, the 

LOAD

 utility is faster than the 

IMPORT

 utility, because it writes 

formatted pages directly into the database, while the 

IMPORT

 utility performs SQL 

 Chapter 6. Data porting 

131