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

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.

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.

2. Configure the ASCII 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

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

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.