01-11-2011, 01:01 AM
|
|
|
It's 42
Industry Role:
Join Date: Jun 2010
Location: Global
Posts: 18,083
|
In SSH or terminal if you can;
Quote:
mysql> load data LOCAL infile '/home/user/path to/file.csv' into table name fields terminated by ',' lines terminated by '\n' (zip, city, state, lat, lng, county);
Query OK, 41755 rows affected (0.13 sec)
Records: 41755 Deleted: 0 Skipped: 0 Warnings: 0
|
This was for a database of all the postal zip codes in the United States . PHP is way too slow to load databases.
I like epoch time myself ...
|
|
|