how to set task schedule for importing text file in Mysql table?

[sweetman]

Hi all,
I'm currently using Navicat on Windows 7 to schedule a task that imports a text into a specific subscription > Mysql table on my plesk server (11.0.9) at specific hour of the day. It works perfectly.
But it runs on windows on my locale machine, so I need to leave the machine up and running all days.
I would like to re-create this schedule directly on the plesk server.

How can I create this schedule on plesk 11.0.9? I've seen there is Task schedule page on plesk 11.0.9 but how can I find the right command?
Just to explain it a little better:
Imagine you have text file uploaded to an FTP address every day at a specific hour.
Every day you need to import this text in a table, replacing completely the table content at the same time (basically the table is emptied and then re-filled with the imported data from the text file).

Is there some documentation that allow me to do this?
Or is there someone that can point me in the right direction?
TIA

tony

 

[IgorG]

You need to read mysql documentation about importing data from file to database.
In common way it should be something like this:

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa < /path/to/file

But note that format of file is very important here!

 

[sweetman]

Hi Igor,
thanks for your reply.
I can't use the command line option since I'm on plesk 11 as a reseller.
I should use the schedule options provided by plesk, but I don't know what to put in the command field, in the schedule task setup.
Is there a basic example I can use as a starting point? I can't find anything useful in the plesk help.

TIA
tony

 

[IgorG]

Actually you can't use any sql import commands if your have no root or admin privileges.
And it is very bad idea to import something to plesk psa database from untrusted source. Consequences may be unpredictable.

 

[sweetman]

Hi Igor,
I need to import a text file in mysql every day. A software house has created an export script that will ftp a file at a specific hour on my server.
I need to import this text file in mysql every day.
Actually I do this using Navicat Premium on my local workstation (windows 7).
This works ok, but I need to do this directly on the server.
Is there an alternative?
TIA
tony