Export Wizard extremely slow when exporting tables to CSV

Question

When I try to export my tables to CSV using the guide on:

the export runs extremely slow and then ultimatively fails. Is there any way to circumvent this?

It fails even for tables around 50 MB.

Anyone know what to do here?

score 3 · Accepted Answer · answered Nov 30 '18 at 15:36

There is a bug in MySQL making the export wizard extremely slow when exporting larger files.

Use a code instead to export the file.

Forexample one can use:

SELECT variables
INTO OUTFILE 'nameoffile.csv' CHARACTER SET 'UTF8MB4'
FIELDS TERMINATED BY ','
FROM "table to export";

1 Answers1