MySQL Bugs: #82700: MySQL Workbench error during data export

Bug #82700	MySQL Workbench error during data export
Submitted:	24 Aug 2016 4:20	Modified:	1 Mar 2017 16:27
Reporter:	Peter Curtis	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S5 (Performance)
Version:	6.3.7	OS:	Windows (Microsoft Windows 7 Enterprise Service Pack 1)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\pcurtis\AppData\Roaming\MySQL\Workbench\log\wb.log]

When I attempt to export a database table and click the "Start Export" button, I get this error: Could not get mysqldump version: Workbench was unable to get musqldump version. Please verify the log for more information.

Log shows the following error:

mysqldump  Ver 10.13 Distrib 5.7.12, for Win64 (x86_64)
21:03:16 [ERR][wb_admin_export.py:get_mysqldump_version:117]: Could not parse version number from mysqldump.exe:

How to repeat:
described above.

Suggested fix:
I was able to make it work by adding this line in wb_admin_export.py just before the s = re.match... line:

output = 'mysqldump  Ver 10.13 Distrib 5.7.12, for Win64 (x86_64)'

Obviously, that's not a good long-term fix.  Somehow, it is not seeing any value for the "output" variable.

I think the issue may be that I have my command prompt set up to automatically run several commands.  After making the modification I provided in the initial ticket, I can see the following at the top of the dump file when I open it.

CREATE DATABASE  IF NOT EXISTS `pcurtis` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `pcurtis`;

C:\Program Files\MySQL\MySQL Workbench 6.3 CE>DOSKEY python27=C:\Python27_64\python.exe 

C:\Program Files\MySQL\MySQL Workbench 6.3 CE>DOSKEY python34=C:\Python34_64\python.exe 

C:\Program Files\MySQL\MySQL Workbench 6.3 CE>DOSKEY python35=C:\Anaconda\Anaconda3\python.exe 

C:\Program Files\MySQL\MySQL Workbench 6.3 CE>DOSKEY java="C:\Program Files (x86)\Java\jre1.5.0_12\bin\java.exe" 

C:\Program Files\MySQL\MySQL Workbench 6.3 CE>DOSKEY packages=cd C:\Anaconda\Anaconda3\packages 

C:\Program Files\MySQL\MySQL Workbench 6.3 CE>DOSKEY web2py="C:\web2py\web2py_win\web2py\web2py.exe" 

C:\Program Files\MySQL\MySQL Workbench 6.3 CE>REM DOSKEY conda="C:\Anaconda\Anaconda3\Scripts\conda.exe" 
-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)

Please try version 6.3.8. Thanks.

http://dev.mysql.com/downloads/workbench/

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Hello,

I have the same problem and I have updated to 6.3.8. Could this ticket be updated or should I open a now one ?

I'm on Ubuntu 16.4.

Thanks in advance for your time and effort.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

maybe add option to my.ini to skip mysqldump version check...