SNMP to MySQL: Writing SNMP values to MySQL database. Tutorial.
Configuring how to write SNMP data to a MySQL database is very much similar to configuring how to write data to MSSQL. Only main differences are described in this manual.
Fig. 1 Driver section
2. The structure of a table in the database will look like this:
2.1 In case of writing a lot of SNMP items
2.2 In case of writing several SNMP items
CREATE TABLE `snmp_data_2` (
If you specify any other data type than String for ITEM1 or ITEM2 in the SNMP 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. During "Binding", you should take into account that the names of the table and its columns are case-sensitive in MySQL.