vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   Fatal error: Maximum execution time of 30 seconds exceeded in.... (https://vborg.vbsupport.ru/showthread.php?t=179633)

wtfsoccerdude 05-18-2008 10:49 AM

Fatal error: Maximum execution time of 30 seconds exceeded in....
 
I have recently upgraded to vB 3.7 and on trying to backup database on the server I get thie follow error:

Quote:

Fatal error: Maximum execution time of 30 seconds exceeded in /home2/forum/public_html/includes/adminfunctions_backup.php on line 77
The files listed in the error are sometimes class_core.php or some other database related files in the includes folder.

I have re-uploaded the files the error displayed but still th problem hasn't been solved. Please help me with this as downloading the databse onto my Pc takes a lot of time due toe slow internet connection.

Awaiting a reply...

Thank you!

Andreas 05-18-2008 10:50 AM

Your DB is too big to back it up through PHP in 1 go.

Best advice: Perform the dump via SSH.

Marco van Herwaarden 05-18-2008 10:52 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/m...nce_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/m...ce_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/showt...t=mysqlhotcopy

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

wtfsoccerdude 05-18-2008 11:17 AM

I wasn't experiencing this when I was using 3.6.8 and even 3.6.9. Is it possible to change the timeout limit?

Marco van Herwaarden 05-18-2008 11:28 AM

Yes you can change the server config to increase the timeout, but that would not change our suggestion not to use any webbased backup.

PS Are you sure that your 3.6 backups are complete?


All times are GMT. The time now is 12:17 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01066 seconds
  • Memory Usage 1,718KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete