CODEWITHSUNDEEP
phpmysqldatabase
a_el
a_el

Reputation: 43

Import .db file into MySql database

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?

link for the db file: http://www.filedropper.com/file_45

Upvotes: 1

Views: 7262

Answers (1)

Manatax
Manatax

Reputation: 4213

you can use cron for Linux or Scheduler for Windows.

EDIT:

For the File you uploaded, you need to install SQLite. Check this for the command line access to the data.

You might want to check this out if you want to make a web interface for your system.

Upvotes: 3

Related Questions