Bulkload into MySQL

Description

This step loads data from a text file into a MySQL table.

See also the MySQL reference page for the generated LOAD DATA command. (MySQL 5.0)

Options

Option

Description

Job entry name

The name of the job entry. This name must be unique within a single job. A job entry can be placed several times on the canvas, however it will be the same job entry.

Connection

The connection to the MySQL database to use.

Target schema

The schema of the table to load

Target table name

The name of the table to load into

Source file name

The name of the file to load

Local

Check this if the file is local

Priority

The priority to load the file with

Fields terminated by

The field terminator to use

Fields enclosed by

The field enclosure to use

Fields escaped by

The escape character to use

Lines started by

The line start string to use

Lines terminated by

The line termination string to use

Fields

The fields to load, separated by comma (,)

Replace data

Check this option if you want to replace the data in the target data

Ignore the first ... lines

Ignores the first ... lines in the text file

Add files to result

Check this option if you want to re-use the filename of the text file in a next job entry.