Run import routine every minut

[ordnance1]

To start with I am a DB novice, having said that, I have created a MySQL db to store my weather station data. My weather station creates a text file each minute with all relevant data.

Using Devart I have been able to manually import my data and create an import template. I have also been able to create a command lime script to import using the template.

Code: Select all

C:\Users\atrick."C:\Program Files\Devart\dbForge Studio for MySQL\deforgemysql" /dataimport /templatefile:C:\wdisplay\wedfiles\WeatherDisplayImport_3.dit

I am at a loss as to how to get this to run automatically ever minute.

[alexa]

You can automate the process with the command line interface of dbForge and, for example, Windows Task Scheduler. Please refer to the following articles on our website for details:

http://blogs.devart.com/dbforge/how-to- ... ndows.html
http://www.devart.com/dbforge/mysql/stu ... ackup.html