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.
我是使用MySQL数据库的新手，需要一些帮助。场景非常类似：我从一些带有自己软件的传感器收集数据。该软件构建.db文件，因为它从传感器获取数据并将其本地保存在计算机中。
My problem is to collect this data from the .db file and input it into a MySQL database with a certain frequency.
我的问题是从.db文件中收集这些数据并将其输入到具有特定频率的MySQL数据库中。
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?
是否可以创建一个用.db文件更新MySQL数据库的脚本（比如说每隔5秒）？你能提供一些使用方向吗？
link for the db file: http://www.filedropper.com/file_45
db文件的链接：http：//www.filedropper.com/file_45
1 个解决方案
#1
2
you can use cron for Linux or Scheduler for Windows.
你可以使用cron for Linux或Scheduler for Windows。
EDIT:
编辑：
For the File you uploaded, you need to install SQLite. Check this for the command line access to the data.
对于您上传的文件，您需要安装SQLite。检查此命令行是否可以访问数据。
You might want to check this out if you want to make a web interface for your system.
如果要为系统创建Web界面，可能需要检查此问题。
#1
2
you can use cron for Linux or Scheduler for Windows.
你可以使用cron for Linux或Scheduler for Windows。
EDIT:
编辑：
For the File you uploaded, you need to install SQLite. Check this for the command line access to the data.
对于您上传的文件，您需要安装SQLite。检查此命令行是否可以访问数据。
You might want to check this out if you want to make a web interface for your system.
如果要为系统创建Web界面，可能需要检查此问题。