Migrate ioBroker history datapoints from MySQL to influxDB

Python script to migrate ioBroker MySQL (SQL History Adapter) data to influxDB (Logging data with influxDB)

Based on a script from UlliJ from the ioBroker Forum

I have used the script to migrate 22 million records from a MySQL DB running on a Rasperry Pi to an influxDB on a Synology.

Infos

• Run pip install -r requirements.txt to install all requirements
• The script processes the measuring points from ts_number, ts_bool and ts_string
• The data is retrieved in a batch of 100,000 data sets per measuring point and sent to influxDB in batches of 1,000 and the progress is displayed.
• Rename database.json.example to database.json and adjust the values for host, port, user, passwd and db to your enviroment. When your InfluxDB has no user/password change the values to an empty string.
• To migrate all datapoints run migrate.py ALL, to migrate one datapoint run migrate.py "hm-rega.0.NEQ1332020" or migrate.py "hm-rega.0.%" to migrate all hm-rega.0 datapoints