Tool for HomeAssistant MySQL Historical Sensor Data Migration to InfluxDB

Migration of the sensor state historical data from MYSQLDB to InfluxDB.

Home Assistant: https://www.home-assistant.io

MySQL used as a Home Assistant recorder. I have MySQL 8.

InfluxDB V2 https://docs.influxdata.com/influxdb/v2.0/ I have used official HomeAssistant Guide for the configuration: https://www.home-assistant.io/integrations/influxdb/

Golang to compile the application for your system.

Both MySQL and InfluxDB need to be exposed to the host you run the tool on over the network.

Currently only supported Sensors with state in numeric format.

The following Attributes values would be copied if not empty or 0:

• Voltage
• BatteryLevel
• UnitOfMeasurement
• FriendlyName
• DeviceClass
• Model

The following Attributes values would be copied if not empty or greater than -50:

• HvacModes
• MinTemp
• MaxTemp
• PresetModes
• CurrentTemperature
• Temperature
• HvacAction
• PresetMode
• PercentageDemand
• ControlOutputState
• HeatingRate
• WindowState
• WindowDetectionActive
• AwayModeSupressed
• FriendlyName
• SupportedFeatures
• UnitOfMeasurement

go get -t ./...

go build

chmod 766 hamysqldb2influxdb

Copy config/config_sample.json to config/config.json

Update config.json setting with you values.

Run the tool