MySQL workbench表数据导入向导非常慢 [英] MySQL workbench table data import wizard extermely slow

问题描述

我需要将一个包含2000万行和2列的csv文件导入到数据库中，但是当我尝试使用mysql workbench的数据导入向导进行此操作非常慢时，可能需要1个月才能完成，看着进度条。
我希望有一些更快的方法可以做到这一点。
非常感谢

i need to import into a database a csv file with 20 million rows and 2 columns, but when i try to do this with the data import wizard of mysql workbench is extremely slow, probably is going to take 1 month to finish, looking at the progress bar. There has to be some faster way to do this, i hope. Thank you very much

推荐答案

始终使用加载数据Infile 作为大量数据的第一次尝试。

Always use Load Data Infile as a first attempt for huge sets of data.

加载数据Infile 。

为这个问题写了几个答案，但对于同行的对比，看看这家伙的问题，我的回答和工作台VS LOAD DATA INFILE他的时间比较。

Wrote up several answers for this question, but for a peer comparison, see this guy's question and my Answer and his time comparisons of Workbench vs Load Data Infile.

这篇关于MySQL workbench表数据导入向导非常慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！