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 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 the file, such as > mysql dbname < text_file_name. Is there a > way to schedule a process either using a function of MySQL or of the > operating system to get it to do this? The operating system would be > Linux to my knowledge. I am hosting the db on an ISP and am not sure > what they will let me do in regards to interacting with MySQL but it is > possible to get a telnet connection if need be to perhaps setup a > script. if it has to be a shell script, i doubt they will let me do > this, but you never know. Also, as another option, is it possible to > create a web interface for this instead where a button hit by the user > would initiate the reading of the file somehow? This might be easier but > I was not sure how to exactly send command line directions from a > webpage. > > Thank you, > Jamie Buck > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
