Web Hosting Talk







View Full Version : File to edit for increasing timeout of mysql?


jolo2
11-08-2003, 01:20 AM
I'm always getting 300 seconds timeouts when loading a bigger mysql db 12mb in phpmyadmin. I heard I need to increase timeouts. What file to edit? I do have my dedicated server and i got access to it.

taz0
11-08-2003, 01:35 AM
php.ini for php.

animelab
11-08-2003, 10:53 AM
Do you get an error from mysql like "MySQL server has gone away"?

SROHost
11-08-2003, 11:41 AM
In your php.ini, you need to adjust the "max_execution_time" variable to something higher so the script doesn't time out.


If you do get "server has gone away" messages also, edit my.cnf (my.ini in Windows) and change the wait_timeout variable to something longer.