Fatal error: Maximum execution time of 30 seconds exceeded in /home/.../public_html/.

[yinyang]

Does anyone know what causes this? I was trying to do a backup from the admincp under Maintenance / Databackup?

Fatal error: Maximum execution time of 30 seconds exceeded in /home/.../public_html/.../includes/adminfunctions_backup.php on line 54

[RCWong]

Hi yinyang,

Pretty much the script timed out or something like that. Normally you can only use that Backup Database in the admincp with small databases because of the PHP time limit. To remedy this you can backup your database from your phpmyadmin.

[yinyang]

WOw, thanks for the quick info!

Thanks again!

[Marco van Herwaarden]

The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_ssh_restore

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

Bigdump:
http://www.ozerov.de/bigdump.php

[yinyang]

thank you marco!

[wally]

the execution time out is changeable in php.ini

when done restart your webserver

[Dismounted]

Yes, but it should not really be changed unless you really need it.

[wally]

Yes, but it should not really be changed unless you really need it.

i agree

and the best way to do a backup is the ssh method but i just wanted to point this out

[yinyang]

thanks! i'm learning a lot!