mysqldump - Path to executable is wrong

已回答
  • 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

 

 

2

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

Could you provide a screenshot?

0
Avatar
Permanently deleted user

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

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

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

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

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

0

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

@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

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

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

Same, problem with WSL2 phpstorm version: 2020.2.1 Preview

 

3

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

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

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
Avatar
Permanently deleted user

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

Same issue on UBUNTU and IntelliJ. 

For mysql I use docker. To be available to use the mysqldump I intalled mysql client locally

sudo apt install mysql-client-core-8.0

Than /usr/bin/mysqldump appeared

Good luck and happy codding :)

0

请先登录再写评论。