MySQL Bugs: #102320: MySQL Workbench Export Fails if "Include Create Schema" Is Selected

Bug #102320	MySQL Workbench Export Fails if "Include Create Schema" Is Selected
Submitted:	20 Jan 2021 18:23	Modified:	21 Jan 2021 6:55
Reporter:	Craig Bransfield	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S2 (Serious)
Version:	8.0	OS:	Windows (10.0.19042 )
Assigned to:		CPU Architecture:	x86 (Intel Core-i7-3520M)

Description:
When running Data Export with "Include Create Schema" selected, the following error occurs:

"Error executing task write() argument must be str, not bytes"

Export proceeds normally if "Include Create Schema" is not selected.

This problem occurs whether I use the mysqldump.exe included with Server installation, or the mysqldump.exe included with Workbench installation.

How to repeat:
Perform schema data export with option "Include Create Schema" selected (checked).

Added OS/CPU info.

Hello Craig Bransfield,

Thank you for the bug report.
Verified as described.

Regards,
Ashwini Patil

8.0.23 test results

Attachment: 102320_test_results.png (image/png, text), 157.50 KiB.

Bug #102319 marked as duplicate of this one.

Bug #102342 marked as duplicate of this one.

Bitten by the same bug.

When reported to stackoverflow (https://stackoverflow.com/questions/65830702/error-executing-task-write-argument-must-be-s...) suggested fixes include:

- Revert to 8.0.20 or earlier (I didn't try this)
- Don't check "Create Schema" (works, but messy)
- Make a code change to wb_admin_export.py (that did not work for me)

Export from MySql workbench does not work neither for just data nor just schema!

Export from MySql workbench does not work neither for just data nor just schema!

Bug #104936 marked as duplicate of this one.