ok, today i was doing some manupulating with a database, and ofcourse, my database is pretty big, its 24Mbs, so while i was running a php script i wrote to change some stuff on each table, i ran into this error:

Fatal error: Maximum execution time of 1200 seconds exceeded in /html/web/htdocs/admin/migrate.php on line 11


well, if you are like me, and you want to know how you can fix this problem just edit your php.ini file and look for this:



;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;

max_execution_time = 1200 ; Maximum execution time of each script, in seconds
max_input_time = 60 ; Maximum amount of time each script may spend parsing request data
memory_limit = 8M ; Maximum amount of memory a script may consume (8MB)


as you can see, my maximum execution time is set to 1200 seconds which is equals to 20 minutes.. that's a pretty long time. but ofcourse, my databse is not small either.. so i can increase this to more time... so if you want to put an hour you just have to multiply 60 seconds my whatever minutes you want, so if i want one hour, it would be 3600 seconds ( 60 x 60)

hope this helps