Log in

View Full Version : Fatal error on creating backup


dxflw
03-10-2009, 11:42 AM
I get this error on creating buck up from admin cp
Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/vhosts/*******.com/httpdocs/forum/includes/class_core.php on line 715

Marco van Herwaarden
03-10-2009, 11:56 AM
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

dxflw
03-10-2009, 12:17 PM
What is means this error?

Marco van Herwaarden
03-10-2009, 12:31 PM
It means: Maximum execution time of 30 seconds exceeded

The script took more time then allowed in the PHP configuration to execute, and the result is a time-out.

dxflw
03-10-2009, 01:07 PM
And how do i fix that?

Marco van Herwaarden
03-10-2009, 01:14 PM
See post #2.

dxflw
03-10-2009, 03:07 PM
I try to restore my db like here is shows http://www.vbulletin.com/docs/html/m...ce_ssh_restore

But i get a message on the terminal :mysql command not found
I use linux and plesk panel


Now with try to get backup from terminal i get message: Permission denied


If try to get backup for phpmyadmin i get this message:
https://*************/domains/databases/phpMyAdmin/export.php Not found.

I follow this guide about:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

BSMedia
03-10-2009, 08:36 PM
try using mysqld rather tha mysql

dxflw
03-11-2009, 10:28 AM
try using mysqld rather tha mysql

Thanks but i'm not a guru on mysql can you explane what is this and do i use?

Marco van Herwaarden
03-11-2009, 10:34 AM
Please post a screenshot of the error you get when trying to restore using the mysql command.

PS No he should not try to use mysqld.

dxflw
03-11-2009, 02:49 PM
Okay i got it.I have create backup via putty