A few months ago I wrote an article geared towards MySQL Windows users on using ActiveState Perl in order to run various MySQL scripts. It was kind of a pain to get set up properly for MySQL usage, hence requiring a write-up in the first place.

But now I’d just like to inform all Windows MySQL users that using Strawberry Perl for your Perl needs is much easier than Active State Perl.

Simply install it. That’s it. No need to worry about later locating and installing the Perl DBI and DBD:MySQL modules, as they’re automatically installed. How refreshing!

You can download Strawberry Perl from here:

http://strawberryperl.com

I downloaded the latest GA version: 5.12.3.0, double-clicked on the installer, installed it, and ran the MySQL scripts immediately.

It doesn’t get …

This article is just a how-to for setting up Perl on Windows in order to use the perl scripts provided with MySQL, such as mysqldumpslow.pl or mysql_explain_log.pl.

Now, you might say there is a section on this topic in the MySQL manual, to which I’d agree. But, this was for ActiveState Perl 5.6. The latest ActiveState Perl is 5.12, so thoese instructions are a bit out-of-date. Also, there are some helpful “User Comments” on that same page, but again, those are slightly out-of-date in the ActiveState 5.12. So, I thought I’d just post the steps I took in order to set this up.

First, download and install ActivePerl. Click the “Download ActivePerl 5.12.4 for Windows” button (choose either 32-bit or 64-bit). You’ll be prompted to save an msi file. Save …