Jump to content

Getting A Lot Of Data Into Mysql


tjjuggle
 Share

Recommended Posts

I have 1.6 million records to get into mysql. It is in the form of a .sql file which is 112megs. I tried running an 'insert from file' in phpmyadmin and it didn't seem to work, I don't know if it timed out, or what.

 

I uploaded it to my site, wraped the insert statements into the apporpriate php code, and ran it, but php died saying '

Fatal error: Maximum execution time of 30 seconds exceeded in /home/everyli/public_html/data/places_data.php on line 5

'

 

How can I get this data into my database?

Link to comment
Share on other sites

Thats a bit of a big database and it will of course time out.

 

I also notice this is your second post on the subject of large database. I am sure the solution for the 750 one will be the same as this one so I will lock this thread.

 

Jim

Edited by Jimuni
Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share

×
×
  • Create New...