0

I'm trying to import a CSV file into MySQL, but the progress bar doesn't advance. When I cancel the import, a ProgressBar error appears, but I see that the file was partially imported. The same error is repeated with other files, and from what everything indicates, besides the ProgressBar error, MySQL is very slow in the import. I searched the forum and everything indicates that it is a Bug, but it has not yet been resolved by the developers. Has anyone managed to solve this problem or circumvent it somehow? I use Windows 10 and the latest version of MySQL.

The way I configure the import

How the progress bar stays still

The error

1
  • 1
    MySQL is very slow in the import No, this is Workbench problem which reads and inserts row-by-row. Do not use such import, create correct LOAD DATA statement and execute. This is the most fast method for CSV data import.
    – Akina
    Oct 13, 2022 at 15:18

1 Answer 1

0

I see frequent complaints that bulk import in MySQL Workbench is very slow.

https://bugs.mysql.com/bug.php?id=95481 (May 2019)

"Workbench import wizard extremely, agonizingly, painfully slow"

https://bugs.mysql.com/bug.php?id=101803 (Nov 2020)

"MySQL Workbench Table Data Import Wizard is still extremely slow"

I don't know why they even implemented an import function and then made it so bad.

I would recommend using LOAD DATA INFILE with the command-line MySQL client. Do not use MySQL Workbench if you need data import to be fast.

You might also write your own custom script in Python or whatever your favorite language is.

You may be interested in my presentation Load Data Fast!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.