Bug #90924 unable export "dump structures and data "
| Submitted: | 18 May 2018 5:57 | Modified: | 18 May 2018 9:43 |
|---|---|---|---|
| Reporter: | sreenivasulu reddy dandolu | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S5 (Performance) |
| Version: | 8.0.11, 8.0.20, 8.0.28, 8.0.30 | OS: | Linux (Ubuntu 18.04 x86_64) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | WBBugReporter | ||
[18 May 2018 5:57]
sreenivasulu reddy dandolu
[18 May 2018 6:00]
sreenivasulu reddy dandolu
which mysqldump version is suitable for my mysql workbench(8.0.11).
[18 May 2018 6:02]
sreenivasulu reddy dandolu
bug report
Attachment: Screenshot from 2018-05-18 11-10-25.png (image/png, text), 374.59 KiB.
[18 May 2018 7:26]
Chiranjeevi Battula
Hello sreenivasulu , Thank you for the bug report. This is most likely duplicate of Bug #87785, please see Bug #87785 Thanks, Chiranjeevi.
[18 May 2018 9:43]
sreenivasulu reddy dandolu
Sry for this issue, it's not a bug this is setup issue . follow as below Goto Edit-->Preferences-->Administration here, shows three input fields like 1. Path to mysqldump tool [choose path with fileName (/path/filename)] 2. path to mysql tool [(/path/filename)] ----> Ex: /usr/bin/mysql 3 Export Directory path [shows where ever you want to export data[path]]
[18 May 2018 16:12]
Henry Kafeman
Setting the Administration Paths does NOT fix the problem. When will this be fixed. Surely it is Important to be able to Export Databases for Backup, etc. I cannot believe this has not been fixed given that it was reported by myself and other long before... Thanks
[29 Jun 2018 17:43]
MySQL Verification Team
One cause of this error is that mysqldump may produce warnings when asked for a version number. Check the wb.log; if it contains something like: mysqldump: [Warning] World-writable config file '/etc/mysql/my.cnf' is ignored. or some other waning from mysqldump, fix whatever generates that warning (in this case, don't let your config files be world-writeable; that's a security risk). If this is the cause, then the bug is that WB should ignore any lines containing [Warning] when determining the version number.
[17 Oct 2018 11:25]
Gerald Tremblay
I noticed that if you have multiple versions of mysql on your machine, and my.cnf is related to the older version, the potentially innocuous message "my.cnf is ignored" appears. However, when I rename this file, the Workbench suddenly works. Perhaps a more detailed suggestion would help...
[22 Sep 2020 12:12]
MySQL Verification Team
Bug #99676 marked as duplicate of this one.
[16 Mar 2022 13:42]
MySQL Verification Team
Bug #106731 marked as duplicate of this one.
[19 Sep 2022 12:54]
MySQL Verification Team
Bug #108525 marked as duplicate of this one.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.067 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.