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:
None 
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 
Description:
----[For better reports, please attach the log file after submitting. You can find it in /home/sreenivasreddy/.mysql/workbench/log/wb.log]

I'm unable dump data structures and date at that time i'm getting below message.
"could not get mysqldump version" and description as the below "workbench was unable get mysqldump version.please verify the log for more information.

How to repeat:
could not get mysqldump version

Suggested fix:
my workbench version was 8.0.11.
which mysqldump version is soutable for my workbench.
[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.