I have to pass data from Access database to a MySQL database attached to HeidiSQL automatically every minutes.

But i have to modify the data from Access before putting them in MySQL.

I already have the script that modify and put the data in MySQL from Access.

The problem is how to call it every minutes and wait until it finished before doing anything else ?

CodePudding user response：

On solution is using cronjob if you are using Linux OS. cronjob is used for reapiting tasks in servers. The cronjob syntax for running is task every minute is : "* * * * *" . this article describes the creation of cronjob in Ubuntu Linux.

CodePudding user response：

You can schedule long-running tasks to run from a command line script. You may try using the

"* * * * * [command] "

making the cronjob definition to run the script you have prepared to pass the data.