Freelance Projects

All freelance projects at One Location


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?



If you liked this project, make sure you
Subscribe to Freelance Projects RSS feed!




    • Your Ads Here
    • Your Ads Here