Running batches of SQL Script files.
| User, date | Message |
|---|---|
|
Written by jeremy.brockman
8 months ago Category: General 2 posts since Fri, 14 Sep 12 |
Is there a way of running batches of multiple sql script files as a schedule process? Jeremy |
|
Written by ansgar
8 months ago 3949 posts since Fri, 07 Apr 06 |
Yes, MySQL 5.1+ has so called "scheduled events". If you can fire a "SHOW EVENTS" without getting an SQL error you can set up events using HeidiSQL, via right click "Create new" menu. |
|
Written by TTSneko
8 months ago 15 posts since Thu, 19 Jul 12 |
Of course, but that has nothing to do with HeidiSQL. Running MySQL in batch mode is explained here: http://dev.mysql.com/doc/refman/5.0/en/batch-mode.html You create the required batches and then have them executed at set times - under Windows, set the timer via "Control Panel -> Scheduled tasks" ... |
|
Written by jeremy.brockman
8 months ago 2 posts since Fri, 14 Sep 12 |
Thanks for your ideas, I will look into them to see if they meet my requirements. Ideally I would like to run a large number of scripts (20+) as an overnight process controlled from the client rather than the server. It is possible to run multiple SQL scripts using the Source command in the MYSQL command line client, but it provides no feed back of the progress of the script (as far as I can see). I was hoping that there was a more elegant way of doing this using the HeidiSQl client. Jeremy |
|
Please login to leave a reply, or register at first. |