mySQL dB Dump timeout

SubZane

My problem is when I try to dump my dB to disk and/or to another dB server I get timeouts when using PHP to do the dumping.

I cannot use telnet/SSH and use the mysql program since the webserver wont allow such things, so I can only do it by scripting

anyone who can help me with a solutuion?

skicraz

Keep in mind that PHP is a web scripting language by nature (despite what the PHP group might want us to think :-)

Keeping that in mind, there are a variety of defaults in PHP that you might need to fiddle with. In this case, my guess would be that you have a timeout in place that limits the amount of time that a PHP script can run for. This default was put in place because of the nature of PHP and the normal useage....a web script probably shouldn't run for hours, and if it does then there is probably an error in the script. If there is an error, why let it slam on the box for hours and stop other good scripts from working? Just let it die now and keep the box running.

This default can be changed within the php.ini file, so check out the online documentation and try changing this value. This may fix your problem.

SubZane

ig I could fiddle with the INI file on the server I would as easily use mysqldump.
I'm not the server admin..I'm just an end-user of the webserver
thats why I asked

wsh

Hello

I have a half-million row db table and the only way i could dump it was in sets of 50,000 with a script or phpmyadmin.

sid

the ONLY way i could dump db over 2 mb (currently a 44mb one) is the default backup script of cpanel - im not sure if it is available as an extra script too, but it rocks.

it generates a tar.gz archive with your db dump included and you can restore it by just using the same script.