lundi 1 décembre 2014

Fastest way to insert data into mysql from csv


I have a dataset of 233,902,846 rows in a csv file. I want to load the data into mysql table. What is the most efficient way of transferring the data so that data insertion is the fastest. actually simple mysqlimport will take around 4-5 days for the complete insertion.


Regards Mona





Aucun commentaire:

Enregistrer un commentaire