Forums



Results 1 to 2 of 2

Thread: Importing big text file to SQL generates 500 Internal Server Error

  1. 06-15-2012, 04:52 PM #1
    imniclas
    imniclas is offline
    Registered User
    Join Date
    Jun 2012
    Posts
    3
    cPanel/WHM Access Level

    Root Administrator

    Default Importing big text file to SQL generates 500 Internal Server Error

    Hello!
    Have a customer who has a PHP script that's importing a large .txt file to MySQL. Have always worked very well but now is the file over 250MB with a lot of rows.

    Exactly after the script have runned for 4 minutes it just stops and generates a 500 Internal Server Error in the users web browser. The SQL is then around 220MB and has about 280 000 rows.

    I have tried to maximize all limits in php.ini and also the time out in Apache Configuration in WHM but nothing helps.

    Am I missing something?

    Appreciate all advice I can get. I can not help the customer any further...
    Reply With Quote Reply With Quote
  2. 06-17-2012, 05:10 AM #2
    markhard
    markhard is offline
    Member
    Join Date
    Apr 2004
    Posts
    236

    Default Re: Importing big text file to SQL generates 500 Internal Server Error

    restore the SQL dump from SSH, faster and have no problem with php/http timeout
    HalfDedi.com : Half Dedicated Half Price
    We Provide Affordable VPS hosting solution in US and Singapore
    Reply With Quote Reply With Quote
« default MySQL collation and character set / charset | What's the supported postgresql version? »

Similar Threads

  1. $xmlapi->createacct($accOptions) generates an error 500 when it succeed.
    By 26medias in forum cPanel Developers
    Replies: 2
    Last Post: 05-17-2012, 06:50 AM
  2. 500 internal server error
    By webs20112 in forum cPanel & WHM Discussions
    Replies: 1
    Last Post: 05-09-2012, 11:22 PM
  3. Internal Server Error 500, File does not exist: /usr/local/apache/htdocs/
    By afiszone in forum cPanel & WHM Discussions
    Replies: 1
    Last Post: 11-01-2011, 02:14 PM
  4. 500 Internal Server Error with PHP file
    By LSteamGeo in forum cPanel & WHM Discussions
    Replies: 26
    Last Post: 05-19-2011, 12:03 AM
  5. Internal server error 500, apache extension - how to fix htacces file without shell a
    By bbxx in forum cPanel & WHM Discussions
    Replies: 6
    Last Post: 06-23-2004, 10:36 PM