brianlange Posted July 21, 2010 Share Posted July 21, 2010 I am loading about 2 million rows into four tables using bulk insert statements and the LOAD DATA INFILE command. The process seems to work fine however the server that hosts the website is crashing. Database server is fine, all of the data is loaded without any problems. I am running the LOAD DATA INFILE command through php on my development server and the data files are located on the production database server so the server that hosts the website does not get used at all. Any ideas? Thanks in advance. -Brian Link to comment https://forums.phpfreaks.com/topic/208438-load-data-infile-causes-web-server-to-crash/ Share on other sites More sharing options...
fenway Posted July 23, 2010 Share Posted July 23, 2010 Chunk the records. Link to comment https://forums.phpfreaks.com/topic/208438-load-data-infile-causes-web-server-to-crash/#findComment-1090349 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.