RS232 to MySQL Bridge - RS232 to MySQL. Logging data from RS-232 to MySQL database

Trust In Confidence!

For Windows 2000 - Windows 10 (2019) (incl. Server, x86 and x64). Latest version: 4.5.1 build 814. .

 

RS232 to MySQL using our data logger software

Complete the following steps to configure our software for data logging from RS232 to MySQL. If you are not familiar with the SQL dialect, please use the RS232 to ODBC method instead. In this case, you should install Connector/ODBC for MySQL.

1. Download RS-232 Logger Software

Download and install our software.

Download RS232 to MySQL Bridge

You can download Advanced Serial Data Logger and all necessary plugins from our download area. Plugins can be downloaded separately here.

You will need the following plugins:

  • The "ASCII Data Parser" plugin extracts data from the common data flow (already included in the installation package).
  • The "SQL Database Pro" plugin exports data that the logger received from RS232 to the MySQL database. You can insert data to any MySQL table and any column. Also, you can insert data using stored routines (procedures and functions).

The following diagram illustrates the internal data flow from RS232 to MySQL.

 

RS232 to MySQL data flow

 

2. Configure the ASCII data parser

RS232 data parser

Our tutorials section contains several examples for different data formats. Also, our support team will glad to help you with the parser settings.

3. Create a MySQL database and table with the necessary structure

MySQL Workbench

You can use MySQL Workbench for free or any third-party tool. Don't forget to grant the necessary rights to the new table.

4. Configure a connection in the SQL Database Pro plugin

MySQL data export

You can find a detailed description in the following tutorial.

5. Specify a SQL statement to insert RS232 data to MySQL

 

 

RS-232 to MySQL Glossary

RS232 Port, RS232, RS-232 - usually identifies serial ports more or less compliant to the RS-232 standard.

MySQL - relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases.