开发者

Why can't mysqldumpslow.pl find any Perl modules on Windows?

开发者 https://www.devze.com 2022-12-19 02:42 出处:网络
I\'m trying to parse a MYSQL slow query log from the command line. Upon entering this: set PATH=G:\\xampp\\perl\\bin\\;%PATH%

I'm trying to parse a MYSQL slow query log from the command line.

Upon entering this:

set PATH=G:\xampp\perl\bin\;%PATH%
cd /d G:\xampp\mysql\scripts
perl mysqldumpslow.pl -s c -t 10

The shel开发者_开发问答l returns an error can't locate strict.pm in @INC (@INC contains: .) at mysqldumpslow.pl at line 8. BEGIN failed

In the perl directory in xampp, there is only one file perl.exe.

Am I missing perl modules/libraries? What do I need to read this log file?


A workaround is to find the location of strict.pm in your perl installation and to add the directory to the PERL5LIB environment variable, or to invoke perl with the -I/path/to/strict.pm/directory option (see perlfaq8: How do I add a directory to my include path (@INC) at runtime?).

If you find more unsatisfied dependencies, keep adding directories to PERL5LIB or with additional -I options until your program can run.

(Though eventually you will probably get tired of this and fix/reinstall perl.)

UPDATE: Looking through the 1.7.3 XAMPP distribution, all of the perl library files are located under xampp\perl\lib and xampp\perl\site\lib, so

    perl -IG:/xampp/perl/lib -IG:/xampp/perl/site/lib mysqldumpslow.pl -s c -t 10

is probably all that you need to do. YMMV if you have an older XAMPP distribution.


Your Perl installation seems to have been messed up in one way or another. I am not familiar with xampp, but I have a hard time believing they bundled just the perl.exe without the rest of the distribution.

Under G:\xampp\perl, there should be subdirectories such as lib, site etc.

strict is a core pragma and its absence indicates that you do not have a proper Perl installation.

In fact, I just downloaded xampp and it does contain lib and site\lib under xampp\perl (it is missing the documentation, but that is not essential to running Perl scripts).

0

精彩评论

暂无评论...
验证码 换一张
取 消