2

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.

2 Answers 2

2

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.

2
  • Correct, however the enterprise edition (its name is actually: MySQL Workbench SE, standard edition, in oppostion to CE, community edition) uses MEB (MySQL Enterprise Backup) instead of mysqldump. Commented Jul 12, 2015 at 8:51
  • @MikeLischke Thanks for clarifying that Mike. BTW, big fan of Virtual Treeview back in the good old Delphi days. :-)
    – Vérace
    Commented Jul 13, 2015 at 16:44
0

It would be better to use MySQL Workbench to write and test the scripts, but then use an OS-native script running utility to run the scripts at specific times. For example, on Linux you might use cron, which is simple to use (there are also tools designed to make it even easier).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.