Import .db file into MySql database

Question

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

Please include some of the .db file so that the format may be inspected — Dave Lasley
– Dave Lasley, Commented Feb 15, 2013 at 19:53
it will be something like this in the link monnit.com/images/sensor-data/Vehicle-Profile-1-Data.jpg — a_el
– a_el, Commented Feb 15, 2013 at 20:55
I dont have an actual .db file. I asked for it and once i have it I will post it here. But i am pretty sure should be something like the one i posted above. thnx — a_el
– a_el, Commented Feb 17, 2013 at 0:28

Manatax · Accepted Answer · 2013-02-20 06:29:29Z

3

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.

edited Feb 20, 2013 at 6:29

answered Feb 15, 2013 at 18:44

Manatax

4,2436 gold badges32 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

a_el Over a year ago

I have never used cron before. I am using myPhp admin to create database. Do you see any way cron can come into help? Can it be set up into a frequency. Also, the program that comes with sensors doesnt support linux

Manatax Over a year ago

Read the link from "cron". What is your environment?

a_el Over a year ago

I am using windows XP (can use 7 as well). Linux is not an option because the program that collects the sensor data does not run on Linux.

Manatax Over a year ago

then you can use the windows scheduler with a .bat script... I would use autohotkey in your position... or c++ if it was for a customer that should not see the code that inserts into the db (that has the password and all)

Manatax Over a year ago

@a_el Was the answer useful?

Collectives™ on Stack Overflow

Import .db file into MySql database

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related