The mysql command line client can accept batch files as: mysql -uuser -ppassword database < file.sql
file.sql is just a file with the plain text SQL statements in it that you want to run. Then since you are on Windows 2000, you could setup Task Scheduler to run it every night at whatever time you specify. Shouldn't be too hard at all. Good luck. Harrison ----- Original Message ----- From: "Tab Alleman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 28, 2002 12:21 PM Subject: Batching sql statements I want to write a batch file of sql statements so that I can schedule this batch file to run at night automatically and send the sql commands to a mysql database on a Win2K server. Does anybody have any experience doing this? Any pointers in the right direction would be much appreciated. Tab --------------------------------------------------------------------- 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
