Thread: Administrative and Maintenance Tools - vBulletin Cron Based Database Backup
View Single Post
  #342  
Old 12-24-2010, 07:25 AM
CRDeveloper's Avatar
CRDeveloper CRDeveloper is offline
 
Join Date: Aug 2009
Location: Costa Rica
Posts: 95
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I've been using this mod since you made it hehe, but for some reason my backups haven't been successfully created, they just hang at some point:

Code:
 Scheduled Task Manager
    Automatic Database Backup for vBulletin 
Processing 404_actions (No Row Data)
Processing vbulletin_access (121) : Processed 121 Rows in 0.004 Seconds 
Processing vbulletin_action (No Row Data)
Processing vbulletin_ad (10) : Processed 10 Rows in 0.001 Seconds 
Processing vbulletin_adcriteria (7) : Processed 7 Rows in 0.001 Seconds 
Processing vbulletin_adminhelp (1670) : Processed 1670 Rows in 0.081 Seconds 
Processing vbulletin_administrator (5) : Processed 5 Rows in 0.001 Seconds 
Processing vbulletin_adminlog (20401) : Processed 20401 Rows in 0.982 Seconds 
Processing vbulletin_adminmessage (No Row Data)
Processing vbulletin_adminutil (3) : Processed 3 Rows in 0 Seconds 
Processing vbulletin_album (52) : Processed 52 Rows in 0.004 Seconds 
Processing vbulletin_albumupdate (10) : Processed 10 Rows in 0.001 Seconds 
Processing vbulletin_announcement (3) : Processed 3 Rows in 0.001 Seconds 
Processing vbulletin_announcementread (No Row Data)
Processing vbulletin_apiclient (No Row Data)
Processing vbulletin_apilog (No Row Data)
Processing vbulletin_attachment (18246) : Processed 18246 Rows in 1.609 Seconds 
Processing vbulletin_attachmentcategory (6) : Processed 6 Rows in 0.001 Seconds 
Processing vbulletin_attachmentcategoryuser (7050) : Processed 7050 Rows in 0.308 Seconds 
Processing vbulletin_attachmentpermission (No Row Data)
Processing vbulletin_attachmenttype (12) : Processed 12 Rows in 0.001 Seconds 
Processing vbulletin_attachmentviews (7) : Processed 7 Rows in 0.001 Seconds 
Processing vbulletin_avatar (No Row Data)
Processing vbulletin_bbcode (18) : Processed 18 Rows in 0.002 Seconds 
Processing vbulletin_bbcode_video (7) : Processed 7 Rows in 0.001 Seconds 
Processing vbulletin_block (1) : Processed 1 Rows in 0.001 Seconds 
Processing vbulletin_blockconfig (3) : Processed 3 Rows in 0.001 Seconds 
Processing vbulletin_blocktype (6) : Processed 6 Rows in 0.001 Seconds 
Processing vbulletin_bookmarksite (4) : Processed 4 Rows in 0.001 Seconds 
Processing vbulletin_cache (1) : Processed 1 Rows in 0.001 Seconds 
Processing vbulletin_cacheevent (3) : Processed 3 Rows in 0.001 Seconds 
Processing vbulletin_calendar (1) : Processed 1 Rows in 0.001 Seconds 
Processing vbulletin_calendarcustomfield (No Row Data)
Processing vbulletin_calendarmoderator (No Row Data)
Processing vbulletin_calendarpermission (No Row Data)
Processing vbulletin_contentpriority (No Row Data)
Processing vbulletin_contenttype (14) : Processed 14 Rows in 0.002 Seconds 
Processing vbulletin_cpsession (3) : Processed 3 Rows in 0.001 Seconds 
Processing vbulletin_cron (25) : Processed 25 Rows in 0.003 Seconds 
Processing vbulletin_cronlog (816) : Processed 816 Rows in 0.035 Seconds 
Processing vbulletin_customavatar (573) : Processed 573 Rows in 0.236 Seconds 
Processing vbulletin_customprofile (28) : Processed 28 Rows in 0.007 Seconds 
Processing vbulletin_customprofilepic (259) : Processed 259 Rows in 0.085 Seconds 
Processing vbulletin_datastore (35) : Processed 35 Rows in 0.025 Seconds 
Processing vbulletin_dbquery (No Row Data)
Processing vbulletin_dbtech_status_criteria (1) : Processed 1 Rows in 0.001 Seconds 
Processing vbulletin_dbtech_status_moods (No Row Data)
Processing vbulletin_dbtech_status_statuslog (295) : Processed 295 Rows in 0.015 Seconds 
Processing vbulletin_deletionlog (109) : Processed 109 Rows in 0.006 Seconds 
Processing vbulletin_discussion (17) : Processed 17 Rows in 0.002 Seconds 
Processing vbulletin_discussionread (58) : Processed 58 Rows in 0.003 Seconds 
Processing vbulletin_editlog (435) : Processed 435 Rows in 0.021 Seconds 
Processing vbulletin_evbs_sstabs (5) : Processed 5 Rows in 0.001 Seconds 
Processing vbulletin_evbs_sstabs_childs (17) : Processed 17 Rows in 0.002 Seconds 
Processing vbulletin_event (6) : Processed 6 Rows in 0.001 Seconds 
Processing vbulletin_externalcache (11) : Processed 11 Rows in 0.006 Seconds 
Processing vbulletin_faq (42) : Processed 42 Rows in 0.003 Seconds 
Processing vbulletin_filedata (17771) : Processed 17771 Rows in 1.673 Seconds 
Processing vbulletin_formbits (23) : Processed 23 Rows in 0.004 Seconds 
Processing vbulletin_formresults (64) : Processed 64 Rows in 0.005 Seconds 
Processing vbulletin_forms (4) : Processed 4 Rows in 0.002 Seconds 
Processing vbulletin_forum (148) : Processed 148 Rows in 0.028 Seconds 
Processing vbulletin_forumpermission (31) : Processed 31 Rows in 0.002 Seconds 
Processing vbulletin_forumprefixset (No Row Data)
Processing vbulletin_forumread (1165) : Processed 1165 Rows in 0.036 Seconds 
Processing vbulletin_groupmessage (139) : Processed 139 Rows in 0.011 Seconds 
Processing vbulletin_groupmessage_hash (No Row Data)
Processing vbulletin_groupread (43) : Processed 43 Rows in 0.002 Seconds 
Processing vbulletin_guest (6479) : Processed 6479 Rows in 0.361 Seconds 
Processing vbulletin_guestviews (49659) : Processed 49659 Rows in 1.981 Seconds 
Processing vbulletin_holiday (No Row Data)
Processing vbulletin_humanverify (6) : Processed 6 Rows in 0.001 Seconds 
Processing vbulletin_hvanswer (No Row Data)
Processing vbulletin_hvquestion (No Row Data)
Processing vbulletin_icon (14) : Processed 14 Rows in 0.001 Seconds 
Processing vbulletin_imagecategory (3) : Processed 3 Rows in 0 Seconds 
Processing vbulletin_imagecategorypermission (No Row Data)
Processing vbulletin_impexerror (No Row Data)
Processing vbulletin_indexqueue (No Row Data)
Processing vbulletin_infraction (3) : Processed 3 Rows in 0.001 Seconds 
Processing vbulletin_infractionban (No Row Data)
Processing vbulletin_infractiongroup (No Row Data)
Processing vbulletin_infractionlevel (4) : Processed 4 Rows in 0.001 Seconds 
Processing vbulletin_language (2) : Processed 2 Rows in 0.033 Seconds 
Processing vbulletin_lgv (1) : Processed 1 Rows in 0.001 Seconds 
Processing vbulletin_mailqueue (No Row Data)
Processing vbulletin_moderation (64) : Processed 64 Rows in 0.002 Seconds 
Processing vbulletin_moderator (24) : Processed 24 Rows in 0.001 Seconds 
Processing vbulletin_moderatorlog (7268) : Processed 7268 Rows in 1.032 Seconds 
Processing vbulletin_notice (4) : Processed 4 Rows in 0.001 Seconds 
Processing vbulletin_noticecriteria (4) : Processed 4 Rows in 0.001 Seconds 
Processing vbulletin_noticedismissed (144) : Processed 144 Rows in 0.005 Seconds 
Processing vbulletin_package (1) : Processed 1 Rows in 0.001 Seconds 
Processing vbulletin_passwordhistory (4078) : Processed 4078 Rows in 0.127 Seconds 
Processing vbulletin_paymentapi (7) : Processed 7 Rows in 0.001 Seconds 
Processing vbulletin_paymentinfo (No Row Data)
Processing vbulletin_paymenttransaction (No Row Data)
Processing vbulletin_phrase (23788) : Processed 23788 Rows in 1.615 Seconds 
Processing vbulletin_phrasetype (73) : Processed 73 Rows in 0.005 Seconds 
Processing vbulletin_picturecomment (30) : Processed 30 Rows in 0.003 Seconds 
Processing vbulletin_picturecomment_hash (No Row Data)
Processing vbulletin_picturelegacy (No Row Data)
Processing vbulletin_plugin (172) : Processed 172 Rows in 0.022 Seconds 
Processing vbulletin_pm (183017) 
--- Processed 100000 Rows 
 #  Processed 183017 Rows in 9.244 Seconds 
Processing vbulletin_pmreceipt (119) : Processed 119 Rows in 0.008 Seconds 
Processing vbulletin_pmtext (102486) 
--- Processed 100000 Rows 
 #  Processed 102486 Rows in 10.07 Seconds 
Processing vbulletin_pmthrottle (No Row Data)
Processing vbulletin_podcast (No Row Data)
Processing vbulletin_podcastitem (No Row Data)
Processing vbulletin_poll (84) : Processed 84 Rows in 0.027 Seconds 
Processing vbulletin_pollvote (4209) : Processed 4209 Rows in 0.232 Seconds 
Processing vbulletin_post (1178671) 
--- Processed 100000 Rows 
--- Processed 200000 Rows 
--- Processed 300000 Rows 
--- Processed 400000 Rows 
--- Processed 500000 Rows 
--- Processed 600000 Rows 
--- Processed 700000 Rows 
--- Processed 800000 Rows 
--- Processed 900000 Rows 
--- Processed 1000000 Rows 
--- Processed 1100000 Rows 
 #  Processed 1178671 Rows in 165.453 Seconds 
Processing vbulletin_post_thanks (634) : Processed 634 Rows in 0.049 Seconds 
Processing vbulletin_postedithistory (977) : Processed 977 Rows in 0.281 Seconds 
Processing vbulletin_posthash (2) : Processed 2 Rows in 0.011 Seconds 
Processing vbulletin_postlog (2672) : Processed 2672 Rows in 0.169 Seconds 
Processing vbulletin_postparsed (4062) : Processed 4062 Rows in 0.557 Seconds 
Processing vbulletin_prefix (No Row Data)
Processing vbulletin_prefixpermission (No Row Data)
Processing vbulletin_prefixset (No Row Data)
Processing vbulletin_product (45) : Processed 45 Rows in 0.013 Seconds 
Processing vbulletin_productcode (70) : Processed 70 Rows in 0.048 Seconds 
Processing vbulletin_productdependency (14) : Processed 14 Rows in 0.001 Seconds 
Processing vbulletin_profileblockprivacy (72) : Processed 72 Rows in 0.011 Seconds 
Processing vbulletin_profilefield (6) : Processed 6 Rows in 0.008 Seconds 
Processing vbulletin_profilefieldcategory (No Row Data)
Processing vbulletin_profilevisitor (3346) : Processed 3346 Rows in 0.185 Seconds 
Processing vbulletin_quotedatanew (342) : Processed 342 Rows in 0.031 Seconds 
Processing vbulletin_ranks (3) : Processed 3 Rows in 0.017 Seconds 
Processing vbulletin_rbs_banners (2) : Processed 2 Rows in 0.01 Seconds 
Processing vbulletin_rbs_hits (No Row Data)
Processing vbulletin_reminder (No Row Data)
Processing vbulletin_reputation (No Row Data)
Processing vbulletin_reputationlevel (15) : Processed 15 Rows in 0.01 Seconds 
Processing vbulletin_route (No Row Data)
Processing vbulletin_rssfeed (No Row Data)
Processing vbulletin_rsslog (No Row Data)
Processing vbulletin_searchcore (355564) 
--- Processed 100000 Rows 
--- Processed 200000 Rows 
--- Processed 300000 Rows 
 #  Processed 355564 Rows in 25.604 Seconds 
Processing vbulletin_searchcore_text (355564) 
--- Processed 100000 Rows 
--- Processed 200000 Rows 
--- Processed 300000 Rows 
 #  Processed 355564 Rows in 17.746 Seconds 
Processing vbulletin_searchgroup (67995) : Processed 67995 Rows in 3.285 Seconds 
Processing vbulletin_searchgroup_text (68013) : Processed 68013 Rows in 2.482 Seconds 
Processing vbulletin_searchlog (5) : Processed 5 Rows in 0.024 Seconds 
Processing vbulletin_seoqueries_data (148014) 
--- Processed 100000 Rows 
 #  Processed 148014 Rows in 6.227 Seconds 
Processing vbulletin_seoqueries_filtered_terms (73) : Processed 73 Rows in 0.019 Seconds 
Processing vbulletin_seoqueries_terms (139519) 
--- Processed 100000 Rows 
 #  Processed 139519 Rows in 5.037 Seconds 
Processing vbulletin_seoqueries_terms_stats (12460) : Processed 12460 Rows in 0.651 Seconds 
Processing vbulletin_session (371) : Processed 371 Rows in 0.042 Seconds 
Processing vbulletin_setting (839) : Processed 839 Rows in 0.068 Seconds 
Processing vbulletin_settinggroup (86) : Processed 86 Rows in 0.016 Seconds 
Processing vbulletin_sigparsed (439) : Processed 439 Rows in 0.071 Seconds 
Processing vbulletin_sigpic (37) : Processed 37 Rows in 0.121 Seconds 
Processing vbulletin_smilie (151) : Processed 151 Rows in 0.126 Seconds 
Processing vbulletin_socialgroup (12) : Processed 12 Rows in 0.035 Seconds 
Processing vbulletin_socialgroupcategory (8) : Processed 8 Rows in 0.011 Seconds 
Processing vbulletin_socialgroupicon (12) : Processed 12 Rows in 0.034 Seconds 
Processing vbulletin_socialgroupmember (153) : Processed 153 Rows in 0.01 Seconds 
Processing vbulletin_spamlog (7) : Processed 7 Rows in 0.011 Seconds 
Processing vbulletin_stats (2788) : Processed 2788 Rows in 0.149 Seconds 
Processing vbulletin_strikes (No Row Data)
Processing vbulletin_style (2) : Processed 2 Rows in 0.052 Seconds 
Processing vbulletin_stylevar (623) : Processed 623 Rows in 0.057 Seconds 
Processing vbulletin_stylevardfn (473) : Processed 473 Rows in 0.055 Seconds 
Processing vbulletin_subscribediscussion (No Row Data)
Processing vbulletin_subscribeevent (No Row Data)
Processing vbulletin_subscribeforum (14) : Processed 14 Rows in 0.001 Seconds 
Processing vbulletin_subscribegroup (1) : Processed 1 Rows in 0.008 Seconds 
Processing vbulletin_subscribethread (20646) : Processed 20646 Rows in 1.125 Seconds 
Processing vbulletin_subscription (No Row Data)
Processing vbulletin_subscriptionlog (No Row Data)
Processing vbulletin_subscriptionpermission (No Row Data)
Processing vbulletin_tachyforumcounter (No Row Data)
Processing vbulletin_tachyforumpost (No Row Data)
Processing vbulletin_tachythreadcounter (No Row Data)
Processing vbulletin_tachythreadpost (No Row Data)
Processing vbulletin_tag (438) : Processed 438 Rows in 0.07 Seconds 
Processing vbulletin_tagcontent (575) : Processed 575 Rows in 0.026 Seconds 
Processing vbulletin_tagsearch (3490) : Processed 3490 Rows in 0.123 Seconds 
Processing vbulletin_template (1663) : Processed 1663 Rows in 1.267 Seconds 
Processing vbulletin_templatehistory (10) : Processed 10 Rows in 0.037 Seconds 
Processing vbulletin_templatemerge (No Row Data)
Processing vbulletin_thread (67468) : Processed 67468 Rows in 12.255 Seconds 
Processing vbulletin_threadrate (161) : Processed 161 Rows in 0.033 Seconds 
Processing vbulletin_threadread (21267) : Processed 21267 Rows in 0.68 Seconds 
Processing vbulletin_threadredirect (1) : Processed 1 Rows in 0.019 Seconds 
Processing vbulletin_threadviews (No Row Data)
Processing vbulletin_upgradelog (14) : Processed 14 Rows in 0.025 Seconds 
Processing vbulletin_user (29032)
Any idea why?

My backups were bigger than 3GB, but, i moved the attachments to file system. Last backup is about 950Mbs but incomplete!
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02511 seconds
  • Memory Usage 1,847KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete