mysqlworkbench giving version error on exporting database

Question

When I try to export my database through MySQL Workbench remotely from localserver,

I am getting some below version error:

mysqldump Version Mismatch [Content] mysqldump.exe is version 5.5.16, but the MySQL Server to be dumped has version 5.6.10-log. Because the version of mysqldump is older than the server, some features may not be backed up properly. It is recommended you upgrade your local MySQL client programs, including mysqldump to a version equal to or newer than that of the target server. The path to the dump tool must then be set in Preferences -> Administrator -> Path to mysqldump Tool

I am trying to find a solution - I searched for solution on google but couldn't find a good answer to solve the issue.

Does anyone know, how to fix this issue in MySQL Workbench?

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 :)

Solution 3

In Linux-based like Ubuntu, Edit > Preferences... > Administration (tab), set "Path to mydqldump Tool" to /usr/bin/mysqldump (most likely by default that's where it suppose to be).

If you're not sure, you can try to find where is the mysqldump located by running the following command in terminal:

locate mysqldump

Solution 4

I was trying to solve this issue with the default mysqldump using Edit > Preferences... > Administration (tab), and setting from /usr/bin/mysqldump which did not work.

I saw that XAMPP server has a mysqldump file too which worked fine! Generally, you can find it in /opt/lampp/bin/mysqldump (for Debian and similar) so you can use this path in your preferences inside workbench.

Solution 5

The message says you need a newer mysqldump tool. One that matches the server you want to dump from. So depending on the platform you are running get a copy of the mysqldump tool from a server installation that has a recent version. Each server comes with a mysqldump tool. So it should be easy to get a copy.

Put the tool in a location where it has a persistent home, but does not conflict with other instances, and point MySQL Workbench at it (as the message says).

View more solutions

Comments

[Voitcus]

Have you tried upgrading MySQL as suggested?

[Gowri]

I don't think It's error. You have version incompatibility problem between two MySQL server version. I guess you should upgrade your mysql version in local.

[जलजनक]

Error is quite informative IMO!

[Sizzling Code]

what should i upgrade? mysql installed on server or should i upgrade the mysqlworkbench?? O_o

[Deepam Gupta]

I would suggest to use mysqldump.

[ChrisF]

Stack Overflow is an English language site. I've translated your answer using Google Translate, please review it for accuracy.

[Toma Radu-Petrescu]

arrrriba gustavo gracias

[Olivier Royo]

Some more information on how to change the target: go to mysqlworkbench and edit the preferences: mysqlworkbench/preferences.../Administartion edit the "Path to mysqldump Tool:" field and select your local mysqldump example: /usr/local/Cellar/mysql/5.7.21/bin/mysqldump

[F 505]

I did the same solution and I still have this error : 12:55:50 Dumping wordnetsemanticsimilarity (all tables) Running: "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe" --defaults-file="c:\users\admini~1\appdata\local\temp\tmpv_d‌​qzx.cnf" --user=root --host=localhost --protocol=tcp --port=3306 --default-character-set=utf8 --skip-triggers "wordnetsemanticsimilarity" mysqldump: Got error: 130: Incorrect file format 'inter' when using LOCK TABLES Operation failed with exitcode 2 12:55:50 Export of C:\Users\Administrator\Documents\dumps\Dump20180812.sql has finished with 1 errors

[simpleuser]

This only seems to apply if the server is on the same machine, and is of the same type, as the MySQL Workbench. This doesn't seem to help at all if the server is a remote MySQL Linux server and MySQL Workbench is running on a Windows PC.

[nanocv]

In MacOs, the path is: MySQLWorkbench - Preferences - Administration - Path to mysqldump Tool.

[Samitha Chathuranga]

For Mac users, it works only after restarting Mysql Workbench, after setting Path to Mysqldumptool in settings (Edit - Preferences - Administrator ).

[Kerwin Sneijders]

If the MySQL server is not on your local machine (like mine was) download the version shown by MySQL Workbench. In my case: (5.7.35). Search for: 'download mysql 5.7.35' and download it. Then extract the zip file and find: mysql-5.7.35-winx64\bin\mysqldump.exe

[B. Bulpett]

This helped me, using macos we can do which mysqldump