tjjuggle Posted August 29, 2003 Posted August 29, 2003 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?
TCH-JimE Posted August 29, 2003 Posted August 29, 2003 (edited) 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 August 29, 2003 by Jimuni
Recommended Posts