| 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 | ||
[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)? Thanks, Umesh
[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".
Description: 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=192.168.65.225 --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.