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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.