MySQL data source

Learn how to set up a MySQL data source and then move its data to one of the data destinations supported by Coupler.io.

2 steps to complete the setup

  1. Set up your data source
  2. Set up your data destination

1. Set up your data source

1.1 Select an application: MySQL

1.2. Define your MySQL server and credentials

  • Click "Connect".
  • Define your MySQL server and user credentials: 
  • > Host - your host on which the MySQL server is running. The value can be a host name, IPv4 address, or IPv6 address.
    > Port - specify the port. The default port number is 3306.
    > User - user name of the MySQL account to use for connecting to the server.
    > Password - corresponding password of the MySQL account used for connecting to the server.

  • Click "Save.

1.3. Setup Basic Settings

  • Enter Database name -  the name of the MySQL database you want to export.
  • Enter Table / View name - table or view you want to export.

2. Set up your data destination

Continue setting up the integration depending on the system you want to import data to. Select your tool from the list of supported data destinations and follow the relevant setup guide.

Note: data representation in the destination can be different depending on column data type:
- if the data has type bit (single bit) -> it is converted to boolean type
- If the data has one of the following types: blob, spatial data types, bytes, bit with size -> it is encoded to base64 string (so images, which can be stored in the database will be available, after base64 decode).
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.