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
解决方案
Always use Load Data Infile as a first attempt for huge sets of data.
Mysql Manual page on 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.