[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 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. [/snip]
Sounds like you need to run a CRON job (you will have to know if your specific implementation has this.) You can have the CRON run a script that will perform the actions. You can use many script types to accomplish this such as PERL, AWK, PHP (you have to install PHP as a CGI binary) and others. This should give you enough to be able to ask your ISP some questions. HTH! Jay mysql, query, sql --------------------------------------------------------------------- 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
