Huge Sql Database Import/ Dump 03.03.08
I have a 5.9 GB text file that I would like to add to a MySQL database.
The text file contains over 70,000,000 records.
I have a 3GHZ P4 / 2GB ram & 500GB Hard Drive.
The text file & MySQL database are on the same hard drive.
I wrote a simple MySQL insert to DB in PHP. It’s been running for 2 days (48 Hrs) And has only imported about 25,000,000 records.
I need to be able to import the 70,000,000 records in 12 hours time. Can anyone suggest something to make this import much faster?



