How to install mysqldumpslow in windows

Hi all,
I have one Mysql 5.6 that has been installed in windows server 2012.  When I tried to run mysqldumpslow, the command not able to found the executable, how do I get this command added into Mysql in windows ? FYI I have installed active PERL  and in teh PERL Package Manager I can't find the package that contains this Mysqldumpslow.
motioneyeAsked:
Who is Participating?
 
Dave BaldwinFixer of ProblemsCommented:
That's the same error I get.  Here's the instructions but I don't know if it answers the 'basedir' question.  https://dev.mysql.com/doc/refman/5.6/en/mysqldumpslow.html
1
 
Dave BaldwinFixer of ProblemsCommented:
In MySQL 5.7, "mysqldumpslow.pl" is located in C:\Program Files (x86)\MySQL\MySQL Server 5.7\bin .  My version of Perl won't read that path because of the spaces so I have to be in that directory to run it.  I didn't give it the correct parameters so it didn't tell me anything but it ran.
1
 
motioneyeAuthor Commented:
Hi,
Okay I see the file but I can't run the file  which it throw with an erro below.

C:\Program Files\MySQL\MySQL Server 5.6\bin>dir mysqldumpslow.pl
 Volume in drive C has no label.
 Volume Serial Number is 860C-F7B8

 Directory of C:\Program Files\MySQL\MySQL Server 5.6\bin

12/09/2017  08:51 AM             7,635 mysqldumpslow.pl
               1 File(s)          7,635 bytes
               0 Dir(s)  42,298,392,576 bytes free

C:\Program Files\MySQL\MySQL Server 5.6\bin>mysqldumpslow.pl
Can't determine basedir from 'my_print_defaults mysqld' output:  at C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldumpslow.pl line 56.

C:\Program Files\MySQL\MySQL Server 5.6\bin>
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.