Page 1 of 1

Run import routine every minut

Posted: Tue 18 Nov 2014 19:26
by 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.

Re: Run import routine every minut

Posted: Wed 19 Nov 2014 16:20
by 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