Skip to content

Latest commit

 

History

History
15 lines (10 loc) · 1.12 KB

README.md

File metadata and controls

15 lines (10 loc) · 1.12 KB

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