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
