vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Administrative and Maintenance Tools - vBulletin Cron Based Database Backup (https://vborg.vbsupport.ru/showthread.php?t=231481)

Blue91 07-19-2010 03:03 PM

Yes, I do. That's fine. I'm guessing it changed between 3 and 4 since my 3.8 install uses folders and the 4.x doesnt, :). No problem. I just had to change the directory in my scheduled task code that downloads a copy of the DB from my server to my home PC once a week.

Thanks for the quick reply and continued support of great mods.

gchristo 07-19-2010 04:32 PM

seems to run, and leaves a backup in the correct folder, but I do not get the backup complete or done, it ends here
Processing searchgroup (24905)
Actually just looked and that is the last folder that it saved as well. Am I missing a setting somewhere?

Paul M 07-20-2010 11:12 AM

Sounds like its probably being timed out.

bfdzio 07-20-2010 03:12 PM

Question, I haven't had a chance to make a backup forum for testing so I don't know how good my backups are...so I am wondering about this:
My cpanel says that my database is 760mb. The backups come in at about 680mb. Is this normal?

Paul M 07-20-2010 09:41 PM

Yes, they are two different things.

Robru 07-21-2010 08:35 AM

Hello Paul,

Can You give me an advise, what I must do with this mention? Put a higher mem in php?

Quote:

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 4458722 bytes) in /var/www/forum/includes/mysqlbackup.php on line 436
Thanks!

Dragonsys 07-21-2010 02:07 PM

Quote:

Originally Posted by Robru (Post 2072359)
Hello Paul,

Can You give me an advise, what I must do with this mention? Put a higher mem in php?



Thanks!

if you can use php.ini create one in your admincp and make the amount of mem = 8MB and increase by 4 (12, 16, 20, etc) until you stop getting this message.

gchristo 07-21-2010 02:11 PM

Quote:

Originally Posted by Paul M (Post 2071959)
Sounds like its probably being timed out.

I set this
Quote:

Set to yes to enable processing of larger tables in blocks. You may need this if your host timesout the backup on large tables.
still only goes to search and stops, what should i be changing?
Thanks for your help as well

Paul M 07-21-2010 04:02 PM

There is nothing else you can change - some hosts simply prevent the timeout being changed.

dmlysiak 07-24-2010 02:46 PM

I have a problem when I go to the forum page is displayed to me


Code:

Processing access (No Row Data)<br />Processing action (No Row Data)<br />Processing ad (No Row Data)<br />Processing adcriteria (No Row Data)<br />Processing adminhelp (1670) : Processed 1670 Rows in 0.053 Seconds <br />Processing administrator (5) : Processed 5 Rows in 0.001 Seconds <br />Processing adminlog (7161) : Processed 7161 Rows in 0.228 Seconds <br />Processing adminmessage (1) : Processed 1 Rows in 0.001 Seconds <br />Processing adminutil (2) : Processed 2 Rows in 0 Seconds <br />Processing album (No Row Data)<br />Processing albumupdate (No Row Data)<br />Processing announcement (No Row Data)<br />Processing announcementread (No Row Data)<br />Processing attachment (No Row Data)<br />Processing attachmentcategory (No Row Data)<br />Processing attachmentcategoryuser (No Row Data)<br />Processing attachmentpermission (No Row Data)<br />Processing attachmenttype (11) : Processed 11 Rows in 0.001 Seconds <br />Processing attachmentviews (No Row Data)<br />Processing avatar (No Row Data)<br />Processing bbcode (1) : Processed 1 Rows in 0 Seconds <br />Processing bbcode_video (7) : Processed 7 Rows in 0.001 Seconds <br />Processing block (2) : Processed 2 Rows in 0.001 Seconds <br />Processing blockconfig (5) : Processed 5 Rows in 0 Seconds <br />Processing blocktype (5) : Processed 5 Rows in 0.001 Seconds <br />Processing bookmarksite (4) : Processed 4 Rows in 0.001 Seconds <br />Processing cache (6) : Processed 6 Rows in 0.001 Seconds <br />Processing cacheevent (3) : Processed 3 Rows in 0 Seconds <br />Processing calendar (1) : Processed 1 Rows in 0 Seconds <br />Processing calendarcustomfield (No Row Data)<br />Processing calendarmoderator (No Row Data)<br />Processing calendarpermission (No Row Data)<br />Processing contentpriority (No Row Data)<br />Processing contenttype (14) : Processed 14 Rows in 0.001 Seconds <br />Processing cpsession (2) : Processed 2 Rows in 0 Seconds <br />Processing cron (21) : Processed 21 Rows in 0.001 Seconds <br />Processing cronlog (242) : Processed 242 Rows in 0.007 Seconds <br />Processing customavatar (3) : Processed 3 Rows in 0.001 Seconds <br />Processing customprofilepic (2) : Processed 2 Rows in 0 Seconds <br />Processing datastore (35) : Processed 35 Rows in 0.008 Seconds <br />Processing deletionlog (No Row Data)<br />Processing discussion (No Row Data)<br />Processing discussionread (No Row Data)<br />Processing editlog (1) : Processed 1 Rows in 0 Seconds <br />Processing event (No Row Data)<br />Processing externalcache (1) : Processed 1 Rows in 0.002 Seconds <br />Processing faq (42) : Processed 42 Rows in 0.002 Seconds <br />Processing filedata (No Row Data)<br />Processing forum (153) : Processed 153 Rows in 0.017 Seconds <br />Processing forumpermission (14) : Processed 14 Rows in 0.001 Seconds <br />Processing forumprefixset (1) : Processed 1 Rows in 0 Seconds <br />Processing forumread (No Row Data)<br />Processing groupmessage (No Row Data)<br />Processing groupmessage_hash (No Row Data)<br />Processing groupread (No Row Data)<br />Processing holiday (No Row Data)<br />Processing humanverify (No Row Data)<br />Processing hvanswer (No Row Data)<br />Processing hvquestion (No Row Data)<br />Processing icon (14) : Processed 14 Rows in 0.001 Seconds <br />Processing imagecategory (3) : Processed 3 Rows in 0.001 Seconds <br />Processing imagecategorypermission (No Row Data)<br />Processing indexqueue (10) : Processed 10 Rows in 0.001 Seconds <br />Processing infraction (5) : Processed 5 Rows in 0.001 Seconds <br />Processing infractionban (2) : Processed 2 Rows in 0 Seconds <br />Processing infractiongroup (No Row Data)<br />Processing infractionlevel (7) : Processed 7 Rows in 0.001 Seconds <br />Processing language (2) : Processed 2 Rows in 0.033 Seconds <br />Processing linkback (No Row Data)<br />Processing mailqueue (No Row Data)<br />Processing moderation (No Row Data)<br />Processing moderator (2) : Processed 2 Rows in 0 Seconds <br />Processing moderatorlog (261) : Processed 261 Rows in 0.016 Seconds <br />Processing notice (3) : Processed 3 Rows in 0.001 Seconds <br />Processing noticecriteria (4) : Processed 4 Rows in 0 Seconds <br />Processing noticedismissed (1) : Processed 1 Rows in 0 Seconds <br />Processing package (1) : Processed 1 Rows in 0 Seconds <br />Processing passwordhistory (67) : Processed 67 Rows in 0.002 Seconds <br />Processing paymentapi (7) : Processed 7 Rows in 0.001 Seconds <br />Processing paymentinfo (No Row Data)<br />Processing paymenttransaction (No Row Data)<br />Processing phrase (16909) : Processed 16909 Rows in 0.683 Seconds <br />Processing phrasetype (72) : Processed 72 Rows in 0.003 Seconds <br />Processing picturecomment (No Row Data)<br />Processing picturecomment_hash (No Row Data)<br />Processing picturelegacy (No Row Data)<br />Processing plugin (82) : Processed 82 Rows in 0.004 Seconds <br />Processing pm (18) : Processed 18 Rows in 0.001 Seconds <br />Processing pmreceipt (2) : Processed 2 Rows in 0.001 Seconds <br />Processing pmtext (16) : Processed 16 Rows in 0.001 Seconds <br />Processing pmthrottle (No Row Data)<br />Processing podcast (No Row Data)<br />Processing podcastitem (No Row Data)<br />Processing poll (No Row Data)<br />Processing pollvote (No Row Data)<br />Processing post (71) : Processed 71 Rows in 0.009 Seconds <br />Processing postedithistory (2) : Processed 2 Rows in 0.001 Seconds <br />Processing posthash (4) : Processed 4 Rows in 0.008 Seconds <br />Processing postlog (16) : Processed 16 Rows in 0.001 Seconds <br />Processing postparsed (39) : Processed 39 Rows in 0.005 Seconds <br />Processing prefix (10) : Processed 10 Rows in 0.001 Seconds <br />Processing prefixpermission (No Row Data)<br />Processing prefixset (1) : Processed 1 Rows in 0 Seconds <br />Processing product (5) : Processed 5 Rows in 0.001 Seconds <br />Processing productcode (11) : Processed 11 Rows in 0.001 Seconds <br />Processing productdependency (1) : Processed 1 Rows in 0 Seconds <br />Processing profileblockprivacy (No Row Data)<br />Processing profilefield (4) : Processed 4 Rows in 0.001 Seconds <br />Processing profilefieldcategory (No Row Data)<br />Processing profilevisitor (64) : Processed 64 Rows in 0.002 Seconds <br />Processing ranks (5) : Processed 5 Rows in 0.001 Seconds <br />Processing reminder (No Row Data)<br />Processing reputation (1) : Processed 1 Rows in 0 Seconds <br />Processing reputationlevel (15) : Processed 15 Rows in 0.001 Seconds <br />Processing route (No Row Data)<br />Processing rssfeed (No Row Data)<br />Processing rsslog (No Row Data)<br />Processing searchcore (224) : Processed 224 Rows in 0.009 Seconds <br />Processing searchcore_text (242) : Processed 242 Rows in 0.01 Seconds <br />Processing searchgroup (220) : Processed 220 Rows in 0.007 Seconds <br />Processing searchgroup_text (234) : Processed 234 Rows in 0.005 Seconds <br />Processing searchlog (17) : Processed 17 Rows in 0.002 Seconds <br />Processing session (5) : Processed 5 Rows in 0.001 Seconds <br />Processing setting (470) : Processed 470 Rows in 0.022 Seconds <br />Processing settinggroup (55) : Processed 55 Rows in 0.002 Seconds <br />Processing sigparsed (No Row Data)<br />Processing sigpic (No Row Data)<br />Processing smilie (11) : Processed 11 Rows in 0.001 Seconds <br />Processing socialgroup (No Row Data)<br />Processing socialgroupcategory (1) : Processed 1 Rows in 0 Seconds <br />Processing socialgroupicon (No Row Data)<br />Processing socialgroupmember (No Row Data)<br />Processing spamlog (No Row Data)<br />Processing stats (75) : Processed 75 Rows in 0.002 Seconds <br />Processing strikes (No Row Data)<br />Processing style (2) : Processed 2 Rows in 0.006 Seconds <br />Processing stylevar (715) : Processed 715 Rows in 0.02 Seconds <br />Processing stylevardfn (441) : Processed 441 Rows in 0.019 Seconds <br />Processing subscribediscussion (No Row Data)<br />Processing subscribeevent (No Row Data)<br />Processing subscribeforum (1) : Processed 1 Rows in 0 Seconds <br />Processing subscribegroup (No Row Data)<br />Processing subscribethread (No Row Data)<br />Processing subscription (No Row Data)<br />Processing subscriptionlog (No Row Data)<br />Processing subscriptionpermission (No Row Data)<br />Processing tachyforumcounter (No Row Data)<br />Processing tachyforumpost (No Row Data)<br />Processing tachythreadcounter (No Row Data)<br />Processing tachythreadpost (No Row Data)<br />Processing tag (37) : Processed 37 Rows in 0.001 Seconds <br />Processing tagcontent (64) : Processed 64 Rows in 0.002 Seconds <br />Processing tagsearch (49) : Processed 49 Rows in 0.001 Seconds <br />Processing template (1456) : Processed 1456 Rows in 0.283 Seconds <br />Processing templatehistory (2) : Processed 2 Rows in 0.001 Seconds <br />Processing templatemerge (1) : Processed 1 Rows in 0 Seconds <br />Processing thread (67) : Processed 67 Rows in 0.008 Seconds <br />Processing thread_serviceupdate (No Row Data)<br />Processing threadrate (No Row Data)<br />Processing threadread (No Row Data)<br />Processing threadredirect (No Row Data)<br />Processing threadviews (10) : Processed 10 Rows in 0 Seconds <br />Processing upgradelog (10) : Processed 10 Rows in 0.001 Seconds <br />Processing user (40) : Processed 40 Rows in 0.009 Seconds <br />Processing useractivation (2) : Processed 2 Rows in 0.001 Seconds <br />Processing userban (No Row Data)<br />Processing userchangelog (69) : Processed 69 Rows in 0.003 Seconds <br />Processing usercss (No Row Data)<br />Processing usercsscache (No Row Data)<br />Processing userfield (40) : Processed 40 Rows in 0.001 Seconds <br />Processing usergroup (11) : Processed 11 Rows in 0.002 Seconds <br />Processing usergroupleader (No Row Data)<br />Processing usergrouprequest (No Row Data)<br />Processing userlist (19) : Processed 19 Rows in 0.001 Seconds <br />Processing usernote (No Row Data)<br />Processing userpromotion (No Row Data)<br />Processing usertextfield (40) : Processed 40 Rows in 0.001 Seconds <br />Processing usertitle (No Row Data)<br />Processing vbseo_blacklist (1) : Processed 1 Rows in 0 Seconds <br />Processing vbseo_linkback (1) : Processed 1 Rows in 0 Seconds <br />Processing vbseo_serviceupdate (139) : Processed 139 Rows in 0.003 Seconds <br />Processing visitormessage (2) : Processed 2 Rows in 0.001 Seconds <br />Processing visitormessage_hash (No Row Data)<br /><br />Processed Database in 1.537 seconds<br /><br /><i>[Compressing Combined File]</i> : Processed File Compression in 0.964 seconds<br /><br />Backup Completed Successfully

vb 4.0.5
happens at 23.00 hours, when the cron to do backups
* 23 * * * Automatic Database Backup for vBulletin


All times are GMT. The time now is 12:37 AM.

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.01479 seconds
  • Memory Usage 1,799KB
  • 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_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete