Hi everyone,
I know that similar topic was hire but it was 6 years ago.
My case is looking like -> I got .sql file with query and I need to run it every Sunday @ 13:00
How to schedule it ? I was try to make cli command file but no success,
I don’t have to export result – I will copy it manually at Mondays – HS will runs on virtual machine.
Any Idea ?
Can anyone help me ?
Scheduler for .sql query
mysql contains an event scheduler since v5.1.6. cf this on defining events.
otherwise, get hold of a mysql.exe, use
mysql.exe -h hostname -u username --password=xxxx <stmts.sql
in a batch file. windows task manager can then be used to implement running this batch regularly.
otherwise, get hold of a mysql.exe, use
mysql.exe -h hostname -u username --password=xxxx <stmts.sql
in a batch file. windows task manager can then be used to implement running this batch regularly.
Please login to leave a reply, or register at first.