Bug #87972 Error occur when I try to export an schema of a remote database
Submitted: 4 Oct 2017 10:43 Modified: 11 Nov 2017 7:35
Reporter: Martín Pons Mayol Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:6.3.9 OS:Linux (Ubuntu 16.04 x86_64)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[4 Oct 2017 10:43] Martín Pons Mayol
I get this log when I try to export a schema of a remote database:
12:35:02 Dumping openppm (all tables)
Running: mysqldump --defaults-file="/tmp/tmpdJtaRG/extraparams.cnf"  --set-gtid-purged=OFF --user=root --host= --protocol=tcp --port=3306 --default-character-set=utf8 --single-transaction=TRUE --routines --events "openppm"
mysqldump: unknown variable 'set-gtid-purged=OFF'

Operation failed with exitcode 7

However when I export the schema of my local database this is not happenning and I can export it successfully.

I tried to fix it by commenting the "set-gtid-purged":["Add 'SET @@GLOBAL.GTID_PURGED' to the output.","AUTO","STR",("5.6.9", None)] line of wb_admin_export_options.py file by adding a # in the begginning and it doesn't work.

How to repeat:
Connect to a remote database and export the schema.
[11 Oct 2017 7:35] Umesh Shastry
Hello Martín,

Thank you for the report.
Could you please provide unaltered WB log, screenshot of "Administration Preferences"( Preferences -> Administration) and details of the instance such as OS, exact MySQL Server version etc which you are trying to export? This would help us to investigate further on this.

When starting WB, could you please add --log-level=debug3(alternatively you can set environment WB_LOG_LEVEL)?

[12 Nov 2017 1:00] Bugs System
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".