////
Licensed to the Apache Software Foundation (ASF) under one
or more contributor license agreements.  See the NOTICE file
distributed with this work for additional information
regarding copyright ownership.  The ASF licenses this file
to you under the Apache License, Version 2.0 (the
"License"); you may not use this file except in compliance
with the License.  You may obtain a copy of the License at
  http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing,
software distributed under the License is distributed on an
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
KIND, either express or implied.  See the License for the
specific language governing permissions and limitations
under the License.
////
:documentationPath: /plugins/actions/
:language: en_US
:page-alternativeEditUrl: https://github.com/apache/incubator-hop/edit/master/plugins/actions/mysqlbulkload/src/main/doc/mysqlbulkload.adoc
= MySQL Bulk Loader

== Description

The MySQL Bulk Loader action loads data from a text file into a MySQL table.

== Options

[width="90%", options="header"]
|===
|Option|Description
|Workflow action name|The name of the workflow action.
|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 workflow action. 
|===