Mysql – Scheduling MySQL Workbench to execute and export on a daily basis

mysql-workbench

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, the schtasks (see also here) should be of use.

MySQL Workbench is not for doing this, except if you have the Enterprise Edition.