I am getting an error while exporting data from mysql 5.5.29(winx-64)
. I am using mysql workbench -gpl-5.2.45(win 32)
.
The error message is:
**WARNING**
Error checking mysqldump version
Error retrieving version from mysqldump.exe:
(exit 1)
I am new in MySQL.
To see a list of the options your version of mysqldump supports, issue the command mysqldump --help .
If mysqldump is not identified by the cmd prompt that means it cannot recognize where the mysqldump.exe is located. You need to add path of the directory where the exe is located in the PATH variable under environment variables. After doing that your command will start working in the cmd prompt.
There are three ways in which the mysqldump tool can be used: First, it can be used to export specific tables in a MySQL database. Second, it can be used to export databases. Third, it can be used to export an entire MySQL server.
Check File->Edit->Preferences, Administrator tab. You need to provide correct path to mysqldump there, or leave field clear to use mysqldump.exe shipped with Workbench.
You have to start MySql Workbench as Admin. Rightclick on the Icon and select "run as adminstrator" that fix the issue. If this won't fix it have a look at Help > Show log file
Best, Nils
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With