vb.org Archive - Administrative and Maintenance Tools - vBulletin Cron Based Database Backup

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!

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01621 seconds Memory Usage 1,816KB 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 (2)bbcode_code_printable (3)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
Messages: