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

 

RS232 to MySQL using our data logger software

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

1. RS-232 Logger Software download

Download and install our software.

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

You will need the following plug-ins:

• The "ASCII Data Parser" plug-in to extract data from the common data flow (already included in the installation package).
• The "SQL Database Pro" plug-in to export data 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 a necessary structure

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

4. Configure a connection in the SQL Database Pro plug-in

You can find the 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.