Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

mysqldump version Error while exporting data from MySQL

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.

like image 814
Chintamani Avatar asked Feb 21 '13 05:02

Chintamani


People also ask

How do I find Mysqldump version?

To see a list of the options your version of mysqldump supports, issue the command mysqldump --help .

Why Mysqldump is not working?

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.

Is Mysqldump capable of exporting a database?

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.


2 Answers

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.

like image 196
alexrider Avatar answered Oct 21 '22 12:10

alexrider


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

like image 37
funktioneer Avatar answered Oct 21 '22 14:10

funktioneer