I am new in using MySQL database and need some help. The scenario is pretty much like this: I collect data from some sensor which come with their own software. The software builds a .db file as it takes data from the sensors and saves it locally in the computer.
My problem is to collect this data from the .db file and input it into a MySQL database with a certain frequency.
Is it possible to create a script that updates the MySQL database with .db files (lets say every 5 secs)? Can you provide some direction on what to use?
Thank You in advance!
PS: .db format should be like this