MySQL Bugs: #68994: Import don't complete with Path to mysql tool defined

Bug #68994	Import don't complete with Path to mysql tool defined
Submitted:	18 Apr 2013 9:56	Modified:	6 Sep 2013 23:14
Reporter:	Kailow Graphic	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	5.2.47 CE Revision 10398	OS:	Windows (Win8 64-bit)
Assigned to:		CPU Architecture:	Any

Description:
When using Data Import/Restore and having set Edit->Preferences->Administrator->Path to mysql Tool to C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe

The import will not complete.

How to repeat:
Have a new database version than the one MySQL Workbench's mysql.exe have.
Import a dump in Self-Contained File format.

mysql.exe versions:
Workbench: Ver 14.14 Distrib 5.5.16, for Win32 (x86)
Database:  Ver 14.14 Distrib 5.6.10, for Win64 (x86_64)

The error also is present if suggested workaround is in place and Path to mysql Tool defined.

Suggested fix:
Workaround:
Copy new version of mysql.exe into Workbench installation dir. And delete the Parth to mysql Tool setting.

Hello.
Can you please try with:
Edit->Preferences->Administrator->Path to mysql Tool to C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe
Thanks

It makes the same error (except the schema name), weather I use the original schema or I try to create a new.

I get this when trying:
Running: "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe" --defaults-extra-file="c:\users\kailow\appdata\local\temp\tmpxmjbe0.cnf"  --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments --database=test < "G:\\MySQL Database Backup\\Dump20130423.sql"

Warning: mysqldump: ignoring option '--databases' due to invalid value 'test'

mysqldump: Got error: 1049: Unknown database '<' when selecting the database

I don't know how it works with importing into new schema, but it seams to me that the two first line in the dump file has to be overridden. Well the error don't change if I out comment the first two lines:
-- CREATE DATABASE  IF NOT EXISTS `test` /*!40100 DEFAULT CHARACTER SET utf8 */;
-- USE `test`;

Please check for duplicate with http://bugs.mysql.com/bug.php?id=68328 . Thanks.

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".

As I see it, the suggested duplicate bug report (http://bugs.mysql.com/bug.php?id=68328) talks about:
Edit->Preferences->Administrator->Path to mysqldump Tool

where this bug report talks about:
Edit->Preferences->Administrator->Path to mysql Tool

So I can see they are related, but not duplicate.

Hi

Please check whether version 6.0.5 still has the problem.

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".