How to Schedule a Stored procedure

[Deeba]

Hello,

I'm just getting back into mySql for a client project, and have a question.

I'm using MySql 5.0, with the phpMyAdmin front end.

I would like to schedule a simple delete to run every few days on my database. I assume I have to put the Delete into a stored procedure, but were to save it, and how to call it is where I am stuck. What should I be trying?

Thanks a bunch,
~Deeba

 

[DonQuichote]

It depends a bit on your OS, but the idead is that this command should be triggered from outside. This "outside" must be scheduled. If you are on Windows, use a "scheduled task". If on *nix, use CRON.

Both can be instructed to run a batch file containing the call to the command you want to run. It can take the shape of:

echo "call <yourProcedure>();"|mysql -h <hostname> -u <databasename><username>

Because you cannot type a password in a batch file and because you do not want it to show up in a history either, it is good to make a user in MySQL that has no password an only execute rights on the procedure.

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)

 

[Deeba]

Thanks DonQuichote,

I'm using a Mac, but the database is running on the Client's ISP, I will check to see which OS it is using.

The different MySql account is a good idea.

~Deeba