mysqlworkbench giving version error on exporting database

Solution 1:

Go to: Edit -> Preferences -> Administrator -> Path to Mysqldumptool:
Look for file mysqldump.exe in your MySQL Server installation folder (it could be: mysql/bin/). Then click it, and OK. After that try to do the backup.

Solution 2:

Fortunately, although not obvious, there is a fairly straightforward solution. You just need to update the mysqldump.exe. The up to date version of the .exe file can be found in. To solve the issue just go to Edit->Preferences->Administrator, and browse the following path

C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe

grab this file and replace it at the Path to mysqldump tool textbox

There may be the following path is set before the above mentioned before, so just replace it with the newer one

C:\Program Files\MySQL\MySQL Workbench CE 5.2.47\mysqldump.exe

The paths may be slightly different for you, but the solution remains the same. In some OS(64bit), there are two folders C:\Program Files (x86)\MySQL and C:\Program Files\MySQL But you have to go for C:\Program Files\MySQL Hope it will help :)