Thread: Administrative and Maintenance Tools - vBulletin Cron Based Database Backup
View Single Post
  #33  
Old 12-30-2009, 07:06 AM
linuxututs linuxututs is offline
 
Join Date: Oct 2009
Posts: 160
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by utahraves View Post
I installed this and it slowed my server down more than anything I've ever used before; I actually ended up with database errors after using and had to take my server down for six hours to resolve. I didn't even get any of the "processing" status messages like others did... just completely frozen. I'll just stick with backing it up on the SQL side for now. Love your products though, Paul *uninstalled*
Code:
utomatic Database Backup for vBulletin
Processing access (No Data)
Processing action (18) : Processed 18 Rows in 0.181 Seconds
Processing ad (No Data)
Processing adcriteria (No Data)
Processing adminhelp (1748) : Processed 1748 Rows in 0.39 Seconds
Processing administrator (1) : Processed 1 Rows in 0.001 Seconds
Processing adminlog (16691) : Processed 16691 Rows in 3.505 Seconds
Processing adminmessage (2) : Processed 2 Rows in 0.077 Seconds
Processing adminutil (2) : Processed 2 Rows in 0.155 Seconds
Processing adv_links (2) : Processed 2 Rows in 0.092 Seconds
Processing adv_links_banners (No Data)
Processing adv_links_categories (16) : Processed 16 Rows in 0.03 Seconds
Processing adv_links_catids (2) : Processed 2 Rows in 0.161 Seconds
Processing adv_links_cfields (No Data)
Processing adv_links_cfields_entries (No Data)
Processing adv_links_deletionlog (No Data)
Processing adv_links_extcache (2) : Processed 2 Rows in 0.041 Seconds
Processing adv_links_favorites (No Data)
Processing adv_links_moderator (No Data)
Processing adv_links_permissions (No Data)
Processing adv_links_posts (No Data)
Processing adv_links_rate (1) : Processed 1 Rows in 0.059 Seconds
Processing adv_links_reports (1) : Processed 1 Rows in 0.158 Seconds
Processing adv_links_search (No Data)
Processing adv_links_subscribecat (No Data)
Processing adv_links_subscribelink (No Data)
Processing adv_modules (26) : Processed 26 Rows in 0.11 Seconds
Processing adv_pages (2) : Processed 2 Rows in 0.122 Seconds
Processing adv_pages_user (No Data)
Processing adv_setting (287) : Processed 287 Rows in 0.071 Seconds
Processing adv_settinggroup (16) : Processed 16 Rows in 1.268 Seconds
Processing album (No Data)
Processing albumupdate (No Data)
Processing announcement (2) : Processed 2 Rows in 0.053 Seconds
Processing announcementread (1) : Processed 1 Rows in 0.189 Seconds
Processing attachment (35) : Processed 35 Rows in 0.082 Seconds
Processing attachmentcategory (No Data)
Processing attachmentcategoryuser (35) : Processed 35 Rows in 0.762 Seconds
Processing attachmentpermission (1) : Processed 1 Rows in 0.277 Seconds
Processing attachmenttype (43) : Processed 43 Rows in 0.144 Seconds
Processing attachmentviews (16) : Processed 16 Rows in 0.053 Seconds
Processing avatar (50) : Processed 50 Rows in 0.146 Seconds
Processing bbcode (2) : Processed 2 Rows in 0.109 Seconds
Processing bbcode_video (7) : Processed 7 Rows in 0.322 Seconds
Processing block (No Data)
Processing blockconfig (No Data)
Processing blocktype (7) : Processed 7 Rows in 0.131 Seconds
Processing blog (No Data)
Processing blog_attachment (No Data)
Processing blog_attachmentviews (No Data)
Processing blog_category (No Data)
Processing blog_categorypermission (No Data)
Processing blog_categoryuser (No Data)
Processing blog_custom_block (No Data)
Processing blog_custom_block_parsed (No Data)
Processing blog_deletionlog (No Data)
Processing blog_editlog (No Data)
Processing blog_featured (No Data)
Processing blog_groupmembership (No Data)
Processing blog_grouppermission (No Data)
Processing blog_hash (No Data)
Processing blog_moderation (No Data)
Processing blog_moderator (No Data)
Processing blog_pinghistory (No Data)
Processing blog_rate (No Data)
Processing blog_read (No Data)
Processing blog_relationship (No Data)
Processing blog_search (No Data)
Processing blog_searchresult (No Data)
Processing blog_subscribeentry (No Data)
Processing blog_subscribeuser (No Data)
Processing blog_summarystats (No Data)
Processing blog_tachyentry (No Data)
Processing blog_text (No Data)
Processing blog_textparsed (No Data)
Processing blog_trackback (No Data)
Processing blog_trackbacklog (No Data)
Processing blog_user (No Data)
Processing blog_usercss (No Data)
Processing blog_usercsscache (No Data)
Processing blog_userread (No Data)
Processing blog_userstats (No Data)
Processing blog_views (No Data)
Processing blog_visitor (No Data)
Processing bookmarksite (4) : Processed 4 Rows in 0.062 Seconds
Processing cache (17) : Processed 17 Rows in 0.003 Seconds
Processing cacheevent (30) : Processed 30 Rows in 0.001 Seconds
Processing calendar (1) : Processed 1 Rows in 0.034 Seconds
Processing calendarcustomfield (No Data)
Processing calendarmoderator (No Data)
Processing calendarpermission (No Data)
Processing cms_article (21) : Processed 21 Rows in 0.026 Seconds
Processing cms_category (28) : Processed 28 Rows in 0.03 Seconds
Processing cms_grid (9) : Processed 9 Rows in 0.034 Seconds
Processing cms_layout (5) : Processed 5 Rows in 0.048 Seconds
Processing cms_layoutwidget (22) : Processed 22 Rows in 0.02 Seconds
Processing cms_navigation (3) : Processed 3 Rows in 0.001 Seconds
Processing cms_node (28) : Processed 28 Rows in 0.017 Seconds
Processing cms_nodecategory (48) : Processed 48 Rows in 0.023 Seconds
Processing cms_nodeconfig (35) : Processed 35 Rows in 0.019 Seconds
Processing cms_nodeinfo (28) : Processed 28 Rows in 0.023 Seconds
Processing cms_permissions (32) : Processed 32 Rows in 0.044 Seconds
Processing cms_rate (No Data)
Processing cms_sectionorder (14) : Processed 14 Rows in 0.001 Seconds
Processing cms_widget (19) : Processed 19 Rows in 0.112 Seconds
Processing cms_widgetconfig (96) : Processed 96 Rows in 0.028 Seconds
Processing cms_widgettype (13) : Processed 13 Rows in 0.001 Seconds
Processing contentpriority (No Data)
Processing contenttype (19) : Processed 19 Rows in 0.057 Seconds
Processing cpsession (1) : Processed 1 Rows in 0.025 Seconds
Processing cron (27) : Processed 27 Rows in 0.003 Seconds
Processing cronlog (2798) : Processed 2798 Rows in 0.102 Seconds
Processing customavatar (1) : Processed 1 Rows in 0.166 Seconds
Processing customprofilepic (No Data)
Processing datastore (64) : Processed 64 Rows in 0.116 Seconds
Processing deletionlog (No Data)
Processing discussion (No Data)
Processing discussionread (No Data)
Processing editlog (36) : Processed 36 Rows in 0.034 Seconds
Processing event (1) : Processed 1 Rows in 0.001 Seconds
Processing externalcache (2) : Processed 2 Rows in 0.011 Seconds
Processing faq (63) : Processed 63 Rows in 0.015 Seconds
Processing filedata (35) : Processed 35 Rows in 0.164 Seconds
Processing files (30) : Processed 30 Rows in 0.1 Seconds
Processing forum (1530) : Processed 1530 Rows in 0.279 Seconds
Processing forumpermission (44) : Processed 44 Rows in 0.06 Seconds
Processing forumprefixset (No Data)
Processing forumread (44) : Processed 44 Rows in 0.002 Seconds
Processing groupmessage (No Data)
Processing groupmessage_hash (No Data)
Processing groupread (No Data)
Processing holiday (No Data)
Processing humanverify (1) : Processed 1 Rows in 0.037 Seconds
Processing hvanswer (No Data)
Processing hvquestion (No Data)
Processing icon (14) : Processed 14 Rows in 0.001 Seconds
Processing imagecategory (5) : Processed 5 Rows in 0.016 Seconds
Processing imagecategorypermission (No Data)
Processing indexqueue (No Data)
Processing infraction (No Data)
Processing infractionban (No Data)
Processing infractiongroup (No Data)
Processing infractionlevel (4) : Processed 4 Rows in 0.001 Seconds
Processing language (1) : Processed 1 Rows in 0.045 Seconds
Processing mailqueue (No Data)
Processing moderation (No Data)
Processing moderator (1) : Processed 1 Rows in 0.064 Seconds
Processing moderatorlog (218) : Processed 218 Rows in 0.101 Seconds
Processing notice (1) : Processed 1 Rows in 0.053 Seconds
Processing noticecriteria (1) : Processed 1 Rows in 0.02 Seconds
Processing noticedismissed (No Data)
Processing package (3) : Processed 3 Rows in 0.001 Seconds
Processing passwordhistory (8) : Processed 8 Rows in 0.029 Seconds
Processing paymentapi (7) : Processed 7 Rows in 0.002 Seconds
Processing paymentinfo (No Data)
Processing paymenttransaction (No Data)
Processing peers (10) : Processed 10 Rows in 0.023 Seconds
Processing phrase (14319) : Processed 14319 Rows in 0.852 Seconds
Processing phrasetype (79) : Processed 79 Rows in 0.055 Seconds
Processing picturecomment (No Data)
Processing picturecomment_hash (No Data)
Processing picturelegacy (No Data)
Processing plugin (123) : Processed 123 Rows in 0.097 Seconds
Processing pm (45) : Processed 45 Rows in 0.061 Seconds
Processing pmreceipt (No Data)
Processing pmtext (33) : Processed 33 Rows in 0.086 Seconds
Processing pmthrottle (No Data)
Processing podcast (No Data)
Processing podcastitem (No Data)
Processing poll (3) : Processed 3 Rows in 0.048 Seconds
Processing pollvote (No Data)
Processing post (215) : Processed 215 Rows in 0.028 Seconds
Processing postedithistory (101) : Processed 101 Rows in 0.248 Seconds
Processing posthash (4) : Processed 4 Rows in 0.041 Seconds
Processing postindex (No Data)
Processing postlog (29) : Processed 29 Rows in 0.034 Seconds
Processing postparsed (394) : Processed 394 Rows in 0.149 Seconds
Processing prefix (No Data)
Processing prefixpermission (No Data)
Processing prefixset (No Data)
Processing product (6) : Processed 6 Rows in 0.029 Seconds
Processing productcode (34) : Processed 34 Rows in 0.078 Seconds
Processing productdependency (4) : Processed 4 Rows in 0.054 Seconds
Processing profileblockprivacy (No Data)
Processing profilefield (11) : Processed 11 Rows in 0.027 Seconds
Processing profilefieldcategory (No Data)
Processing profilevisitor (13) : Processed 13 Rows in 0.013 Seconds
Processing ranks (15) : Processed 15 Rows in 0.078 Seconds
Processing reminder (No Data)
Processing reputation (6) : Processed 6 Rows in 0.058 Seconds
Processing reputationlevel (15) : Processed 15 Rows in 0.074 Seconds
Processing route (5) : Processed 5 Rows in 0.034 Seconds
Processing rssfeed (1) : Processed 1 Rows in 0.001 Seconds
Processing rsslog (65) : Processed 65 Rows in 0.027 Seconds
Processing searchcore (1746) : Processed 1746 Rows in 0.229 Seconds
Processing searchcore_text (1746) : Processed 1746 Rows in 1.581 Seconds
Processing searchgroup (1749) : Processed 1749 Rows in 0.104 Seconds
Processing searchgroup_text (1749) : Processed 1749 Rows in 0.037 Seconds
Processing searchlog (191) : Processed 191 Rows in 0.148 Seconds
Processing session (11) : Processed 11 Rows in 0.025 Seconds
Processing setting (555) : Processed 555 Rows in 0.037 Seconds
Processing settinggroup (59) : Processed 59 Rows in 0.002 Seconds
Processing sigparsed (3) : Processed 3 Rows in 0.001 Seconds
Processing sigpic (1) : Processed 1 Rows in 0.025 Seconds
Processing smilie (54) : Processed 54 Rows in 0.107 Seconds
Processing socialgroup (No Data)
Processing socialgroupcategory (1) : Processed 1 Rows in 0.229 Seconds
Processing socialgroupicon (No Data)
Processing socialgroupmember (No Data)
Processing spamlog (No Data)
Processing stats (83) : Processed 83 Rows in 0.061 Seconds
Processing strikes (No Data)
Processing style (2) : Processed 2 Rows in 0.076 Seconds
Processing stylevar (449) : Processed 449 Rows in 0.083 Seconds
Processing stylevardfn (451) : Processed 451 Rows in 0.104 Seconds
Processing subscribediscussion (No Data)
Processing subscribeevent (No Data)
Processing subscribeforum (No Data)
Processing subscribegroup (No Data)
Processing subscribethread (No Data)
Processing subscription (No Data)
Processing subscriptionlog (No Data)
Processing subscriptionpermission (No Data)
Processing tachyforumcounter (No Data)
Processing tachyforumpost (No Data)
Processing tachythreadcounter (No Data)
Processing tachythreadpost (No Data)
Processing tag (252) : Processed 252 Rows in 0.008 Seconds
Processing tagcontent (1297) : Processed 1297 Rows in 0.067 Seconds
Processing tagsearch (36429) : Processed 36429 Rows in 0.782 Seconds
Processing template (1583) : Processed 1583 Rows in 1.182 Seconds
Processing templatehistory (6) : Processed 6 Rows in 0.028 Seconds
Processing templatemerge (No Data)
Processing thread (213) : Processed 213 Rows in 0.055 Seconds
Processing threadrate (4) : Processed 4 Rows in 0.054 Seconds
Processing threadread (12) : Processed 12 Rows in 0.001 Seconds
Processing threadredirect (No Data)
Processing threadviews (No Data)
Processing trackerhistory (94) : Processed 94 Rows in 0.097 Seconds
Processing umg_rating (No Data)
Processing upgradelog (40) : Processed 40 Rows in 0.066 Seconds
Processing user (9) : Processed 9 Rows in 0.027 Seconds
Processing useractivation (1) : Processed 1 Rows in 0.211 Seconds
Processing userban (No Data)
Processing userchangelog (12) : Processed 12 Rows in 0.009 Seconds
Processing usercss (No Data)
Processing usercsscache (No Data)
Processing userfield (9) : Processed 9 Rows in 0.011 Seconds
Processing usergroup (10) : Processed 10 Rows in 0.033 Seconds
Processing usergroupleader (No Data)
Processing usergrouprequest (No Data)
Processing userlist (3) : Processed 3 Rows in 0.001 Seconds
Processing usernote (No Data)
Processing userpromotion (No Data)
Processing usertextfield (9) : Processed 9 Rows in 0.001 Seconds
Processing usertitle (4) : Processed 4 Rows in 0.056 Seconds
Processing vbseo_blacklist (164) : Processed 164 Rows in 0.08 Seconds
Processing vbseo_linkback (3) : Processed 3 Rows in 0.041 Seconds
Processing vbseo_serviceupdate (No Data)
Processing vbstopforumspam (No Data)
Processing vbstopforumspam_log (1) : Processed 1 Rows in 0.051 Seconds
Processing vbstopforumspam_remotecache (1) : Processed 1 Rows in 0.059 Seconds
Processing visitormessage (6) : Processed 6 Rows in 0.001 Seconds
Processing visitormessage_hash (No Data)

Processed Database in 18.686 seconds

Backup Completed Successfully

Done
And I have over 1,600 forums built so far on my new site.
This is really a Great mod to have.

Thanks again,
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01284 seconds
  • Memory Usage 1,846KB
  • 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)bbcode_quote
  • (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