Page 1 of 1

CGI Timeout issue

Posted: Wed Oct 25, 2006 3:51 pm
by kyzercube
I'm trying to import a HUGE database table ( over 480,000 rows ) to the mysql database on my test server via phpmyadmin.

However, when attempting this import I get this error:

"The specified CGI application exceeded the allowed time for processing. The server has deleted the process.:"

I'm certain there is a way to increase this allowed time for processing, but I don't know where the allowed time is set. I've looked in my php.ini file, but I'm not seeing anything that resembles CGI allowed times for processing.

Just that you know, I have the latest versions of PHP,MySQL and phpMyAdmin.


Can anyone tell me how to increase this CGI application allowed time?

Posted: Wed Oct 25, 2006 3:57 pm
by feyd
Break the file up into much smaller chunks and process them one by one or write a script that does the importation instead of phpMyAdmin.

Posted: Wed Oct 25, 2006 4:14 pm
by kyzercube
I am fully aware that is an option, but the file is so big, I'll spend a unreal amount of time doing this. Besides, I know there is a way to increase the allowed time. If you don't know how, then don't respond to my post.

Posted: Wed Oct 25, 2006 4:26 pm
by feyd
kyzercube wrote:I am fully aware that is an option, but the file is so big, I'll spend a unreal amount of time doing this. Besides, I know there is a way to increase the allowed time. If you don't know how, then don't respond to my post.
I'll assume you weren't trying to insult me for suggesting a perfectly valid alternative.

set_time_limit() can be used.

Posted: Wed Oct 25, 2006 4:35 pm
by kyzercube
Ofc not Feyd. I felt I was insulted when you suggested I splice a 480,000 row sql file. Don't be offended please :)