MySQL Bulk File

Description

The MySQL Bulk File action can bulk load data from MySQL into a file.

Options

OptionDescription

Workflow action name

The name of the workflow action.

Connection

The database connection.

Edit…​

Edit the database connection.

New…​

Create a new database connection using the standard dialog.

Wizard…​

Create a new database connection using the wizard dialog.

Target schema

The target schema.

Target File name

The target file.

High Priority

The priority to load the file with.

Type

OUTFILE, DUMPFILE

Field separator

The field separator to use.

Fields enclosed by

The field enclosure to use.

Optionally enclosed

Lines terminated by

The line termination string to use.

Names of columns

Limit to the…​first lines

If file exists

Create new with unique name, Do Nothing, Fail

Add file to result filenames