Bug #94499 Error with Export Wizard

• Submitted: 27 Feb 2019 18:30
• Modified: 4 Mar 2019 19:21
• Reporter: Thomas Stieve
• Status: Unsupported
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 6.3
• OS: Any
• CPU Architecture: Any

[27 Feb 2019 18:30] Thomas Stieve

Description:
Hello, I am trying to back up several databases use the Wizard. I immediately get a warning that the dumpsqldumptool needs to be updated. I follow the instructions given https://stackoverflow.com/questions/47101540/where-to-download-mysqldump-ext-newer-version... and use the 10x version required.

Now, I don't get the warning, but I get off and on the error message:

Error Unhandled exception: u'name of database'

I have to reboot Workbench even to get the export button to activate again. Online help forums do not help. I cannot find a workaround, and I am afraid of losing data while backing up. Thank you for your help.

Tom

How to repeat:
Please see description

[27 Feb 2019 19:29] MySQL Verification Team

Thank you for the bug report. I couldn't repeat with current version 8.0.15, please upgrade.

[27 Feb 2019 21:53] Thomas Stieve

Thank you. I am assuming that the new version will not have any problems handling all the data from the older version, yes?

[27 Feb 2019 22:15] MySQL Verification Team

I couldn't promise you nothing, I just tested the export wizard with WorkBench 8.0.15 and on my environment the mysqldump is the version below:
C:\Program Files\MySQL\MySQL Server 8.0>bin\mysqldump --version
mysqldump  Ver 8.0.15 for Win64 on x86_64 (MySQL Community Server - GPL)

[27 Feb 2019 22:21] MySQL Verification Team

Forgot to mention tested with server below connected:
2019-02-27T22:16:55.407576Z 0 [Note] Event Scheduler: Loaded 0 events
2019-02-27T22:16:55.409598Z 0 [Note] c:\dbs\5.7\bin\mysqld: ready for connections.
Version: '5.7.26-log'  socket: ''  port: 3570  Source distribution BUILD: 2019-FEB-20

[4 Mar 2019 18:52] Thomas Stieve

Hi, I upgrade to 8, but still error messages. I am trying to use the command prompt to export, but I get "couldn't get SELECT COLUMN" error (Please see png). I am able to successfully enter command mysql.exe. 

Your help is greatly appreciated,
Tom

[4 Mar 2019 18:53] Thomas Stieve

Error Message

Attachment: mysql.png (image/png, text), 106.04 KiB.

[4 Mar 2019 19:11] MySQL Verification Team

Thank you for the feedback. You are using server MariaDB which isn't supported.

[4 Mar 2019 19:21] Thomas Stieve

I'm sorry, do you mean Maria doesn't support this command or this error page doesn't support it? I'm really confused by MariaDB as opposed to MYSQL Workbench?

[4 Mar 2019 19:33] MySQL Verification Team

WorkBench doesn't support Server MariaDB.