bg

MODBUS to MySQL: Write MODBUS values to the MySQL database

Download Advanced Serial Data Logger
Download a Free Trial Version.It allows you to try all features!

The configuration process for MySQL is similar to the article "How to write data to MSSQL." Only the main differences are described in this manual.

1. Download and install the 32-bit version of MySQL ODBC Connector (the ODBC driver) for MySQL from mysql.org.

Driver section
Fig. 1 Driver section

2. The structure of a table in the database will look like this:


CREATE TABLE `modbus_data_2` (
  `REC_ID` int(11) NOT NULL AUTO_INCREMENT,
  `TIMESTAMP` datetime NOT NULL,
  `ITEM1` varchar(30) DEFAULT NULL,
  `ITEM2` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`REC_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

If you specify any other data type than String for ITEM1 or ITEM2 in the MODBUS settings, you should create the columns of the corresponding types while creating a table.

3. Create an ODBC data source for your MySQL database.

4 Follow steps #1-9 from the previous tutorial for MS SQL: "Writing MODBUS values to MS SQL."

5. During the binding process, you should consider that the names of the table and its columns are case-sensitive in MySQL.

Related articles: MODBUS to MySQL: Write MODBUS values to the MySQL database

MODBUS RTU, MODBUS ASCII, MODBUS/TCP

IEC 62056-21

Advanced Serial Data Logger - Read more about:

Serial port interface RS232 port logger Com port logger RS232 data logger Data Logger Software For Electricity Meter RS232 to ODBC RS232 to MySQL RS232 to MS SQL Server RS232 to database