Here's my question.
I have a couple scripts (very simple stuff; select queries) that I run in MySQL Workbench which I can than export to CSVs. What I want to know is if it is possible to schedule MySQL Workbench to run the scripts and export to CSVs at a specific time everyday.
I am using Windows 7.
Best Answer
Use the Windows Task Scheduler or if you want to use the command line, then an
at
job should do the trick. On Window 7, theschtasks
(see also here) should be of use.MySQL Workbench is not for doing this, except if you have the Enterprise Edition.