MYSQL Data Transfer

[sjb66]

I've written a windows application to scan tables in a SQLite backup db and import any new records into a MYSQL db.
This would be useful for anyone who wants to keep records for longer than the Domoticz 7 days limit.
The application can be run in either manual or unattended autorun mode and keeps a basic log of updates in the MYSQL db.

So far I've only run/tested the application on a MYSQL server running on my local network but I suspect that there would be no problems saving to a Maria DB on a NAS as long as the Maria db was configured not "Non-Localhost" access.

I've not compiled any documentation yet and I was wondering if anyone else would be intereted in the application.


SB

[gizmocuz]

You can also use docker compose and install a container with InfluxDB and Grafana

[Xavier82]

@sjb66: Interesting!
Could this help with my issue?:
https://www.domoticz.com/forum/viewtopi ... ce#p312489

Is there a possibility to copy data from 1 table to an other table?
Can I restore the output as database file into Domoticz?

[gizmocuz]

I'm pretty sure you can already do this with 'SQLite Personal Edition'. Open the database, right click on the database and choose 'Attach database'