mysqldump - Path to executable is wrong

Answered
  • Windows
  • Downloaded and copied MySQL 5.7 zip files to: C:/mysql
  • So path is: C:/mysql/bin/mysqldump.exe
  • Still get the error message and mysqldump not working

 

 

16 comments
Comment actions Permalink

@Logan
How could it be wrong if you choose it?

Could you provide a screenshot?

0
Comment actions Permalink

I got it working by installing MySQL server instead of just extracting the ZIP. Since it is working now I don't want to go back and replicate the issue just for the screenshot. If I uninstall it for whatever reason, I will try this again and try to replicate it. 

1
Comment actions Permalink

I just had the same issue. Here is a Screenshot:

I just selected the mysqldump executable via the file picker. Maybe it is an unsupported version of mysqldump?

0
Comment actions Permalink

Could you specify mysqldump version? Since I can't reproduce the issue with mysqldump

Ver 10.13 Distrib 5.7.12, for Win32 (AMD64) 
0
Comment actions Permalink

My version is:

PS F:\programs\mysql-5.7.23-winx64\bin> ./mysqldump -V
mysqldump  Ver 10.13 Distrib 5.7.23, for Win64 (x86_64)
0
Comment actions Permalink

@Stefan Beyer Could you email me vasily.chernov@jetbrains.com IDE logs? Before that try to reproduce the issue. 

0
Comment actions Permalink

I just wanted to reproduce this again to get a minimal IDE log, but the error was gone today... I don't quite know what is happening here, but it seems that at the time where the issue appeared for me, IT rolled out some new anti virus software. Maybe it interfered in some way...

 Vasily, do you still want the log from thursday? I could get that for you if it still exists ^^

0
Comment actions Permalink

@Stefan Beyer
> Vasily, do you still want the log from thursday? I could get that for you if it still exists ^^
Yes, It would be great.

P.S.: Just in case https://intellij-support.jetbrains.com/hc/en-us/articles/207241085-Locating-IDE-log-files

0
Comment actions Permalink

Vasily, I have sent you the log file part for the whole day. it is full of exceptions (unlike the days before or after), so that is very likely that this was the work of the beforementionend av software that IT tested on my machine ^^

0
Comment actions Permalink

Just to let you know guys. I had the same issue with pg_dump on Linux. Path was specified correctly, but message said "Path to executable is wrong".

So I gave up and tried to use it on command line. And this is where I got the actual error: "Error: You must install at least one postgresql-client-<version> package".

When I installed that package the issue was gone. So basically that message was misleading in IDE.

1
Comment actions Permalink

Same, problem with WSL2 phpstorm version: 2020.2.1 Preview

 

1
Comment actions Permalink

It happened on my windows machine when I extracted the mysqldump.exe from mysql-8.0.22-winx64.zip. But If you extract the whole zip file and specify the mysqldump.exe location in IDEA, I solve the problem.

0
Comment actions Permalink

Dragonphy,
>It happened on my windows machine when I extracted the mysqldump.exe from mysql-8.0.22-winx64.zip
 

So, did you specify the wrong path? Or exe was not working?

0
Comment actions Permalink

I got the same error in the export dialog, however, for me mysqldump wouldn't print anything at all in PowerShell (wanted to see the version) and when I tried it via the old command line, I got an error message saying MSVCP120.dll was missing, which gave me the clue to install the Microsoft Visual C++ 2013 Redistributable. Installing that solved the problem for me

http://www.microsoft.com/en-us/download/details.aspx?id=40784
1
Comment actions Permalink

Hello.

I have been stucked with this problem 2 times now. Took me a while this last time to remember the problem.

If you download mysql  as a zip and try to execute mysqldump.exe in a terminal from the file:  "C:\mysql\bin\mysqldump.exe", two messages will prompt.

Those messages tells that two .dll are missing. My guess is that the installation deals with that when you choose the installer.

The ".dll" are: msvcr120.dll and msvcp120.dll. If you download those and copy them in: "C:\Windows\System32" you will be able to use the mysqldump and mysql to restore options.

1

Please sign in to leave a comment.