Re: Is it possible to have MySQL perform an action at a specifictime?

2002-06-05 Thread Mark
- Original Message - From: "Jay Blanchard" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 04, 2002 8:48 PM Subject: RE: Is it possible to have MySQL perform an action at a specific time? > Sounds like you need to run a CRON job (you will have to know if your > specific im

Re: Is it possible to have MySQL perform an action at a specifictime?

2002-06-05 Thread Eivind A. Sivertsen
Hummm..one solution is just to exploit the 'at' program of unix/linux systems... I use that for backups, table dumps etc. combined with perl or php scripts... $0.02; Eivind - Before posting, please check: http:/

Re: Is it possible to have MySQL perform an action at a specifictime?

2002-06-04 Thread David M. Peak
Have you looked at cron on LINUX? - Original Message - From: "Jamie Buck" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 04, 2002 11:37 AM Subject: Is it possible to have MySQL perform an action at a specifictime? > I have a file containing commands to add and drop tab

RE: Is it possible to have MySQL perform an action at a specifictime?

2002-06-04 Thread Jay Blanchard
[snip] I have a file containing commands to add and drop tables as a means of synchronizing two databases. What i want to happen is for MySQL to open this file and read it at a specific time without the user having to explicitly connect to MySQL and type in the commands in order to get it to read