MySQL Bugs: #90421: Export fails when trying to export query results

Bug #90421	Export fails when trying to export query results
Submitted:	13 Apr 2018 1:29	Modified:	13 Apr 2018 11:18
Reporter:	Paul Avila	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	6.3.10	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
When I try to export query results as CSV, for the first time on a new install of Workbench, I get an error that says: Export Inserts Data Failed to open output file: (path to file is shown correctly). 

This is odd that it seems to want to open the file, not export. 

 

How to repeat:
Run query
Select Export
type in file name (leaving CSV as type)
Click Save
Error

Hello Paul Avila,

Thank you for the bug report.
I could not repeat the issue at our end using with MySQL workbench 6.3.10 version with MySQL 5.7.21 version.
If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Thanks,
Chiranjeevi.

I am having exactly this experience running Workbench on a MySQL 5.7 database via GNOME on DigitalOcean Ubuntu 18.04.  Everything proceeds as normal following directions to get a display, until the fields are filled in for export to external file; then it cancels the export and gives the message 

Export Inserts Data
Failed to open output file: 

followed by a correct filepath enclosed in backquotes.  

The problem sometimes stops for a while after doing a complete down and up of the DO droplet (all the way through poweroff of the Droplet itself, quitting Workbench, then logging off, then doing poweroff through GNOME's Terminal application, and then restarting from the ground up) but it resumes within less than twenty table writes.