Bulk load from MySQL into file
Description
The Bulk load from MySQL into file action bulk loads data from a MySQL table into a file.
Options
| Option | Description |
|---|---|
Action name |
The name of the workflow action. |
Connection |
The database connection. |
Source schema |
The schema of the table to export. |
Source table |
The table to export. |
Target File name |
The file to write, on the database server. |
High Priority |
Adds |
Type |
OUTFILE (default) writes the rows with the separators below. DUMPFILE writes a single row without any formatting: more than one row makes the action fail. |
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 |
A comma separated list of columns to export |
Limit to the…first lines |
Only export the first x number of rows |
If file exists |
The action to take when the target file already exists:
|
Add file to result filenames |
Add the target file to the result filenames |
Result
What this action passes on to the next action. See Action results for how results travel through a workflow.
| Result | Value |
|---|---|
True |
The file was written, with 0 errors. Also true when the file already exists and If file exists is Do Nothing: then nothing is exported, and the action doesn’t connect to the database. |
False |
The file exists and If file exists is Fail, the table doesn’t exist, Target File name is empty, the connection doesn’t exist or can’t be opened, or MySQL refuses the query (for example a path outside the folder allowed by the server’s |
Result files |
The target file is added when Add file to result filenames is checked and the file was written. Otherwise passed on unchanged. |
Result rows |
Passed on unchanged. |
| When the table doesn’t exist, the reason is only logged at the Detailed log level: at the Basic level, the log shows a false action without an error message. |
The MySQL server writes the file (SELECT … INTO OUTFILE), so Target File name is a path on the database server. If file exists is checked on the machine where Hop runs.
|