MySQL Bugs: #101245: I can,t export database

Bug #101245	I can,t export database
Submitted:	20 Oct 2020 15:03	Modified:	23 Nov 2020 10:47
Reporter:	Alberto Nico	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	8.0.20	OS:	Windows (Microsoft Windows 7 Home Premium Service Pack 1)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any
Tags:	WBBugReporter

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\lacio\AppData\Roaming\MySQL\Workbench\log\wb.log]

I get the following message:
11:23:14 Dumping cr29_v01 (avw_v0)
Running: mysqldump.exe --defaults-file="c:\users\lacio\appdata\local\temp\tmpywovtx.cnf"  --user=lacio --host=localhost --protocol=tcp --port=3306 --default-character-set=utf8 --skip-triggers "cr29_v01" "avw_v0"
mysqldump: Couldn't execute '/*!80000 SET SESSION information_schema_stats_expiry=0 */': Unknown system variable 'information_schema_stats_expiry' (1193)

Operation failed with exitcode 2
11:23:16 Export of I:\CRD19\Tablas Importadas (1) has finished with 1 errors

I tray in many ways and couldn,t export any table. Also Y can´t ony set  variable information_schema_stats_expiry. I get the message that it does not 
exist

How to repeat:
Any time I try to export a schema it appears

log file

Attachment: wb.1.log (application/octet-stream, text), 10.23 KiB.

Hello Alberto Nico,

Thank you for the bug report.
Imho the error is due to mysqldump version mismatch.
Please try below workaround.

Edit->Preferences->Administrator<TAB>
Selected path to MySQL dump tool: <path to 8.0.20>/bin/mysqldump.exe

Confirm this by clicking "OK" and reopen the WB and try to export.

Regards,
Ashwini Patil

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".