Bug #68328 | Mismatch on version of "mysqldump.exe" and "mysqld.exe" mak failure in Workbench | ||
---|---|---|---|
Submitted: | 9 Feb 2013 19:34 | Modified: | 13 Jun 2013 5:59 |
Reporter: | Ted palmer | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Workbench: Administration | Severity: | S2 (Serious) |
Version: | 5.2.46 | OS: | Windows (Can't Export Data) |
Assigned to: | CPU Architecture: | Any |
[9 Feb 2013 19:34]
Ted palmer
[9 Feb 2013 21:46]
MySQL Verification Team
Thank you for the bug report. C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.46>mysqldump --version mysqldump Ver 10.13 Distrib 5.5.16, for Win32 (x86)
[11 Feb 2013 22:25]
Robert ocking
I am using mysql 5.6.10 on windows 7 (64 bit) and was having exactly the same issue with the version mismatch. I downloaded the mysql-5.6.10-winx64.zip folder from this site, opened it, copied out the mysqldump.exe file and pasted it into the two mysql folders on the C: drive. C:\Program Files\Mysql\MysqlServer 5.6\bin\ (sentence case may not be correct) C:\Program Files(x86)\Mysql\Mysql Workbench CE 5.2.46\ restarted the Pc. and the export worked perfectly.
[11 Feb 2013 23:18]
Ted palmer
Robert ocking: I am surprised that you got the result you did for the corrective action that you took. I don't doubt that you got what you got, but that just doesn't square with what I finally read at the end of the error message. Which was "The path to the dump tool must then be set in Preferences -> Administrator -> Path to mysqldump Tool". That is all I did. Set the path to the "mysqldump.exe" program in the preferences. It is unfortunite that the most valuable part of the error message was at the bottom. Because I had other issues that inspired me to concentrate my efforts at what was at the top. What you downloaded should have been the same version of what was already in the folder. In the process I stumbled on language that said that the path had to be set in the MySQL Workbench Preferences or else the version of mysqldump.exe that was linked into the executable would be used. That explained how it was that a version different than what I just installed got executed. You might take a look the top menu choice Edit >> preferences >> Administrator. It was a shocker to me when I saw it. Ted Palmer
[15 Mar 2013 17:21]
Stephen Tregidga
Had the exact same issue (running on 64bit Win8). Thanks Robert ocking for your work-around. Worked perfectly for me also.
[23 Mar 2013 14:29]
Nandan Jain
Thanks Robert ocking for your solution. I also had same issue and your solution has worked very well. It solved my problem. Thanks Again.
[23 Mar 2013 19:36]
Michael Lant
I am having exactly the same problem. I cannot export/backup a database. I installed the latest version of WB, but before doing that, I uninstalled the previous version of WB and wiped out the following folder: C:\Users\<user>\AppData\Roaming\MySQL\Workbench\ I am also experiencing that persistent "Connection Cancelled" issue whenever I attempt to open a connection to the database. MySQL Workbench has been rendered 100% unusable. [Window Title] MySQL Workbench [Main Instruction] 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: [Continue Anyway] [Cancel]
[4 Apr 2013 14:13]
massimo carozzo
Indeed there are two problems. 1) If you do not specify the path for mysqldump.exe, the export is suspended and a warning is published waiting for your decision. 2) If you specify the path the warning is published in the export log pane but the export process starts anyway. Obviously if you replace mysqldump.exe with correct version as suggested, export runs without any warning. Massimo.
[6 Apr 2013 22:54]
Luis Medeiros
I've got se same problem today and solved it copying the files mysqldump*.* from "C:\Program Files\MySQL\MySQL Server 5.6\bin" to "C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.47" BTW: I'm using Win 7 Ultimate 64 bits
[21 Apr 2013 0:32]
Bob Tschetter
I did what Ted suggested except that Luis actually provided the location of the correct dump.exe file. Here's what I did, and I have Windows 7 64 bit too. Edit, Preferences, Administrator Selected path to mysql dump tool: C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe Notice the correct *dump.exe file is in bin folder of c:\Program Files\... not c:\Program files x86\... I ran the export and got no errors...finally!
[21 Apr 2013 17:54]
Ted Palmer
Thank you for keeping me informed guys. I appreciate all that you do. But may I suggest this. One of the fixes offered was to update the MySQL utility software on my PC to be at or above the version of the MySQL server the utility software is working with. I experienced this using the whole MySQL software package that I had just downloaded that day. If there is a mismatch in versioning between programs in the download package, it seems to me that the download package that provides the all the software a user needs to use MySQL on windows needs to be revised. Ted Palmer
[24 Apr 2013 1:27]
Jack Worthing
Bob's comment worked great for me! Thanks Bob
[20 May 2013 9:36]
Louise Wheatley
Thank you Robert and Bob. I had two different versions of mysqldump.exe. Setting the preferences to the one in Program Files not Program Files (x86) worked. Thanks Ted for raising it.
[23 May 2013 5:35]
Junior Granados
to solve this problem go to workbench program: edit>>preferences>>administrator>>path to mysqldump tool:>> choose C:\programfiles\MySQL\MySQL Server 5.6\bin\mysqldump.exe press ok. in that way choose the same version of mysqldump.exe 5.6.11 from the server folder. :) hope you like it
[6 Jun 2013 16:30]
Christopher Hinkle
I followed the workaround suggested and specified the location of mysqldump.exe (which I confirmed to be version 5.6.11 by looking at the file properties). When I then continued with the dump, I no longer received the pop-up notice, but I did get the following in the Export Progress tab's Log window: WARNING mysqldump.exe is version 5.5.16, but the MySQL Server to be dumped has version 5.6.11-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: 12:25:16 Dumping my_database (all tables) Running: "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe" --defaults-extra-file="c:\users\username\appdata\local\temp\3\tmpj0edbv.cnf" --user=root --max_allowed_packet=1G --host=localhost --port=2222 --default-character-set=utf8 --routines --events "my_database" 12:25:18 Export of T:\backup\20130606.sql has finished --------- I note that the path to mysqldump.exe mentioned on the "Running:" line is the exact same one I set in the preferences tab and which I confirmed to be version 5.6.11.
[6 Jun 2013 16:39]
Christopher Hinkle
Adding to the above comment under name "NOT_FOUND", my version of MySQL Workbench is 5.2.47 CS Revision 10398 running on Windows Server 2012.
[13 Jun 2013 5:59]
Philip Olson
Fixed as of the upcoming MySQL Workbench 6.0.2 public beta release, and the changelog entry was merged with Oracle Bug #16575396 / MySQL Bug #68683 which reads as: An older version of the MySQL Client was bundled with MySQL Workbench, and it has since been updated. This caused problems while executing "mysqldump". Thank you for the bug report.
[23 Jul 2013 11:32]
MySQL Verification Team
http://bugs.mysql.com/bug.php?id=69819 marked as duplicate of this one.
[21 Aug 2013 0:30]
Alejandro Garro
/Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump is version 5.5.24, but the MySQL Server to be dumped has version 5.6.12. 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: