Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Strawberry Perl – A Great Perl Option for Windows MySQL Users
+3 Vote Up -0 Vote Down

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 any easier than that. (I even went ahead and uninstalled Active State Perl altogether.)

In fact, here is the quote on their home page:

“When I’m on Windows, I use Strawberry Perl” — Larry Wall

And for reference, here is my new mysqldumpslow output from using the new Strawberry Perl (just to show it’s the exact same as my previous example):

C:> mysqldumpslow.pl -v -s at ..\data\Chris-PC-slow.log

Reading mysql slow query log from ..\data\Chris-PC-slow.log
Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=5.0 (5), root[root]@localhost
  select * from t;
  C:\Program Files\MySQL\MySQL Server N.N\bin\mysqld-nt. started with:
  TCP Port: N, Named Pipe: MySQL

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), 0users@0hosts
  C:\Program Files\MySQL\MySQL Server N.N\bin\mysqld-nt. started with:
  TCP Port: N, Named Pipe: MySQL
  # Time: N N:N:N
  # User@Host: root[root] @ localhost [N.N.N.N]
  # Query_time: N  Lock_time: N  Rows_sent: N  Rows_examined: N
  use test99;
  select * from t

 
 

Votes:

You must be logged in with a MySQL account to vote on Planet MySQL entries. More information on PlanetMySQL voting.

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.