What is the best way to load 1,600,000 rows of data into a mysql database?

Question

This may sound silly, but yes, I need an effective way to do this. I am using php at the moment and the person is slow.

Any pointers please.

Greetings.

Answer 1

Anytime I have to insert huge amounts of data, I try to use "LOAD DATA INFILE":

http://dev.mysql.com/doc/refman/5.1/en/load-data.html

A bottleneck could also be data indexing. I would recommend disabling indexing before starting infile data loading, and then turning it on later.

Answer 2

HediSQL http://www.heidisql.com/. , . , . mysql mysql , phpMyAdmin.

Answer 3

Try removing all indexes before inserting. Once you have inserted everything, re-create the indexes.

There is a really good article on MySql about this and other methods. Look at it here .