Skip to main content

Import data into MySQL

Tom Santiago
  • Updated
Follow

This article assumes the following:

  • You have data in a CSV file on an FTP host and you want to import that data into a table in MySQL.
  • You have already established connections for FTP and MySQL.

See also:

Use the following steps to import data into MySQL:

  1. Create or open an integration.
  2. Click + Create flow.
  3. In the Destination & Lookup Applications section, enter or select appropriate details in the following fields:

Field Name

Description

Name

Enter a name for the flow that you are creating. For example, "Contact Data."

Description

Enter a brief description of what this export does.

Application

Select FTP.

Directory Path

Select the FTP connection from which you will be retrieving the data.

Output Mode

Select Records.

Note: Enable Developer Mode to see this field.

File Name Starts With

Enter the filename that contains the data.

File Type

Select CSV.

Column Delimiter

Select Comma.

File Has Header

Select this checkbox.

File Encoding Type

Select UTF-8.
  1. Click Next.
  2. In the Source Applications section, enter or select appropriate details in the following fields: 

Field Name

Description

Name

Enter a name for your import. For example, MySQL Import.

Description

A short description that describes what this import does.

Application

Select MySQL.

Connection

Select the connection that you created for MySQL.

Query Type

Select Insert.
  1. Click Next.
  2. Click Define query.
  3. Modify the sample text present under Template to reflect your INSERT query for the MySQL table. 

Note: Under Template, you also get a list of all the record fields and available functions the moment you type an open curly brace ({).

  1. The SQL query builder contains two tabs where you can review or provide data:
    • Sample data previews any records found in a valid MySQL statement.
    • Default data lists default values per field, in JSON format, to prevent errors when inserting missing required values into the database. Enter "NULL" for any default NULL values. 
  2. Click Save.
  3. Schedule or run the data flow. 

Troubleshooting

Question: I am getting an invalid_parameter error while exporting data from NetSuite to PostgreSQL.

Answer: When you are exporting data from NetSuite to a database, such as PostgreSQL, ensure that you enable Skip grouping in NetSuite export. By default, NetSuite results are returned as an array of arrays, whereas integrator.io expects a simple (not nested) array of results. When you enable Skip grouping, the results are received as a simple array.

Related articles

Comments

0 comments

Please sign in to leave a comment.