CGI Timeout issue

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
kyzercube
Forum Newbie
Posts: 5
Joined: Wed Oct 25, 2006 3:19 pm

CGI Timeout issue

Post 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?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
kyzercube
Forum Newbie
Posts: 5
Joined: Wed Oct 25, 2006 3:19 pm

Post 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.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
kyzercube
Forum Newbie
Posts: 5
Joined: Wed Oct 25, 2006 3:19 pm

Post 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 :)
Post Reply