Go Back   vb.org Archive > vBulletin Modifications > Archive > Modification Graveyard
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vBulletin Cron Based Database Backup Details »»
vBulletin Cron Based Database Backup
Version: 4.2.0.2, by Paul M Paul M is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page

Category: Administrative and Maintenance Tools - Version: 4.2.x Rating:
Released: 12-27-2009 Last Update: 11-25-2013 Installs: 1434
Uses Plugins
Additional Files Translations  
No support by the author.

As of 23 Nov 2017 this modification has been withdrawn.

This is a cut down version based on a backup system written by Trigunflame for vb 3.0. It is a simple vBulletin cron trigged php system that does a dump of your database - either as one complete file, or as one file per table. Especially useful now that IB removed the old ACP backup option in vBulletin 4. Files can be (G)Zipped to save space.

All the options are located in the ACP in vBulletin Options >> vBulletin Automatic Backup

To install, download and unzip the files, and follow the instructions in the text file.


History:

v4.0.1 : 28-Dec-2009 : Initial release for vb 4.0.0 Gold.
v4.0.2 : 29-Dec-2009 : Added ability to block process larger tables.
v4.0.3 : 27-Jun-2010 : Added Gzip option.

v4.1.0 : 04-Dec-2010 : Updated for vBulletin 4.1.0.

v4.1.7.0 : 16-Oct-2011 : Updated for vBulletin 4.1.7.

v4.2.0.0 : 24-May-2012 : Updated for vBulletin 4.2.0.
v4.2.0.1 : 17-Mar-2013 : Removed vboptions from backup call..
v4.2.0.2 : 25-Nov-2013 : Fix php 5.3 deprecated warnings, added mysqldump backup.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #32  
Old 12-30-2009, 07:02 AM
linuxututs linuxututs is offline
 
Join Date: Oct 2009
Posts: 160
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Just like to say Thanks For You releasing a 4.0 version of this GREAT utility.

Thanks,
Reply With Quote
  #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
  #34  
Old 12-30-2009, 04:40 PM
rajubd rajubd is offline
 
Join Date: Jun 2009
Posts: 209
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

its stops in middle what could be the problem?
Code:
Processing vbaccess (No Data) 
Processing vbaction (No Data) 
Processing vbad (No Data) 
Processing vbadcriteria (No Data) 
Processing vbadminhelp (1666) : Processed 1666 Rows in 0.327 Seconds 
Processing vbadministrator (1) : Processed 1 Rows in 0.008 Seconds 
Processing vbadminlog (10582) : Processed 10582 Rows in 5.025 Seconds 
Processing vbadminmessage (2) : Processed 2 Rows in 0.023 Seconds 
Processing vbadminutil (2) : Processed 2 Rows in 0.019 Seconds 
Processing vbalbum (10) : Processed 10 Rows in 0.049 Seconds 
Processing vbalbumupdate (No Data) 
Processing vbannouncement (4) : Processed 4 Rows in 0.034 Seconds 
Processing vbannouncementread (663) : Processed 663 Rows in 0.226 Seconds 
Processing vbattachment (7375) : Processed 7375 Rows in 10.626 Seconds 
Processing vbattachmentcategory (1) : Processed 1 Rows in 0.014 Seconds 
Processing vbattachmentcategoryuser (7383) : Processed 7383 Rows in 1.989 Seconds 
Processing vbattachmentpermission (No Data) 
Processing vbattachmenttype (15) : Processed 15 Rows in 0.005 Seconds 
Processing vbattachmentviews (125) : Processed 125 Rows in 0.009 Seconds 
Processing vbavatar (No Data) 
Processing vbbbcode (No Data) 
Processing vbbbcode_video (7) : Processed 7 Rows in 0.024 Seconds 
Processing vbblock (4) : Processed 4 Rows in 0.039 Seconds 
Processing vbblockconfig (20) : Processed 20 Rows in 0.086 Seconds 
Processing vbblocktype (7) : Processed 7 Rows in 0.053 Seconds 
Processing vbbookmarksite (4) : Processed 4 Rows in 0.008 Seconds 
Processing vbcache (1) : Processed 1 Rows in 0.01 Seconds 
Processing vbcacheevent (3) : Processed 3 Rows in 0.002 Seconds 
Processing vbcalendar (1) : Processed 1 Rows in 0.08 Seconds 
Processing vbcalendarcustomfield (No Data) 
Processing vbcalendarmoderator (No Data) 
Processing vbcalendarpermission (No Data) 
Processing vbcontentpriority (No Data) 
Processing vbcontenttype (14) : Processed 14 Rows in 0.103 Seconds 
Processing vbcpsession (2) : Processed 2 Rows in 0.031 Seconds 
Processing vbcron (19) : Processed 19 Rows in 0.049 Seconds 
Processing vbcronlog (1437) : Processed 1437 Rows in 0.436 Seconds 
Processing vbcustomavatar (160) : Processed 160 Rows in 0.279 Seconds 
Processing vbcustomprofilepic (119) : Processed 119 Rows in 0.29 Seconds 
Processing vbdatastore (35) : Processed 35 Rows in 0.033 Seconds 
Processing vbdeletionlog (290) : Processed 290 Rows in 0.055 Seconds 
Processing vbdiscussion (3) : Processed 3 Rows in 0.015 Seconds 
Processing vbdiscussionread (No Data) 
Processing vbeditlog (2970) : Processed 2970 Rows in 0.396 Seconds 
Processing vbevent (No Data) 
Processing vbexternalcache (29) : Processed 29 Rows in 0.641 Seconds 
Processing vbfaq (42) : Processed 42 Rows in 0.015 Seconds 
Processing vbfiledata (6997) : Processed 6997 Rows in 7.344 Seconds 
Processing vbforum (37) : Processed 37 Rows in 0.201 Seconds 
Processing vbforumpermission (7) : Processed 7 Rows in 0.01 Seconds 
Processing vbforumprefixset (15) : Processed 15 Rows in 0.063 Seconds 
Processing vbforumread (No Data) 
Processing vbgroupmessage (19) : Processed 19 Rows in 0.033 Seconds 
Processing vbgroupmessage_hash (16) : Processed 16 Rows in 0.021 Seconds 
Processing vbgroupread (No Data) 
Processing vbholiday (No Data) 
Processing vbhumanverify (52) : Processed 52 Rows in 0.013 Seconds 
Processing vbhvanswer (No Data) 
Processing vbhvquestion (1) : Processed 1 Rows in 0.005 Seconds 
Processing vbicon (20) : Processed 20 Rows in 0.012 Seconds 
Processing vbimagecategory (3) : Processed 3 Rows in 0.404 Seconds 
Processing vbimagecategorypermission (No Data) 
Processing vbindexqueue (No Data) 
Processing vbinfraction (24) : Processed 24 Rows in 0.02 Seconds 
Processing vbinfractionban (No Data) 
Processing vbinfractiongroup (No Data) 
Processing vbinfractionlevel (4) : Processed 4 Rows in 0.021 Seconds 
Processing vblanguage (1) : Processed 1 Rows in 0.069 Seconds 
Processing vblinkback (No Data) 
Processing vbmailqueue (No Data) 
Processing vbmoderation (6) : Processed 6 Rows in 0.051 Seconds 
Processing vbmoderator (262) : Processed 262 Rows in 0.082 Seconds 
Processing vbmoderatorlog (12948) : Processed 12948 Rows in 16.08 Seconds 
Processing vbnotice (1) : Processed 1 Rows in 0.014 Seconds 
Processing vbnoticecriteria (1) : Processed 1 Rows in 0.005 Seconds 
Processing vbnoticedismissed (No Data) 
Processing vbpackage (1) : Processed 1 Rows in 0.013 Seconds 
Processing vbpasswordhistory (24929) : Processed 24929 Rows in 7.912 Seconds 
Processing vbpaymentapi (7) : Processed 7 Rows in 0.078 Seconds 
Processing vbpaymentinfo (No Data) 
Processing vbpaymenttransaction (No Data) 
Processing vbphrase (12296) : Processed 12296 Rows in 7.999 Seconds 
Processing vbphrasetype (70) : Processed 70 Rows in 0.041 Seconds 
Processing vbpicturecomment (2) : Processed 2 Rows in 0.032 Seconds 
Processing vbpicturecomment_hash (2) : Processed 2 Rows in 0.032 Seconds 
Processing vbpicturelegacy (17) : Processed 17 Rows in 0.05 Seconds 
Processing vbplugin (20) : Processed 20 Rows in 0.047 Seconds 
Processing vbpm (2166) : Processed 2166 Rows in 0.463 Seconds 
Processing vbpmreceipt (129) : Processed 129 Rows in 0.105 Seconds 
Processing vbpmtext (1749) : Processed 1749 Rows in 1.542 Seconds 
Processing vbpmthrottle (No Data) 
Processing vbpodcast (No Data) 
Processing vbpodcastitem (No Data) 
Processing vbpoll (17) : Processed 17 Rows in 0.028 Seconds 
Processing vbpollvote (327) : Processed 327 Rows in 0.076 Seconds 
Processing vbpost (33673) : Processed 33673 Rows in 30.735 Seconds 
Processing vbpostedithistory (2573) : Processed 2573 Rows in 1.517 Seconds 
Processing vbposthash (4) : Processed 4 Rows in 0.004 Seconds 
Processing vbpostindex (No Data) 
Processing vbpostlog (2317) : Processed 2317 Rows in 0.375 Seconds 
Processing vbpostparsed (7753) : Processed 7753 Rows in 10.75 Seconds 
Processing vbprefix (26) : Processed 26 Rows in 0.006 Seconds 
Processing vbprefixpermission (No Data) 
Processing vbprefixset (6) : Processed 6 Rows in 0.088 Seconds 
Processing vbproduct (8) : Processed 8 Rows in 0.053 Seconds 
Processing vbproductcode (4) : Processed 4 Rows in 0.022 Seconds 
Processing vbproductdependency (2) : Processed 2 Rows in 0.066 Seconds 
Processing vbprofileblockprivacy (216) : Processed 216 Rows in 0.183 Seconds 
Processing vbprofilefield (4) : Processed 4 Rows in 0.094 Seconds 
Processing vbprofilefieldcategory (No Data) 
Processing vbprofilevisitor (1501) : Processed 1501 Rows in 0.903 Seconds 
Processing vbranks (No Data) 
Processing vbreminder (No Data) 
Processing vbreputation (4260) : Processed 4260 Rows in 1.236 Seconds 
Processing vbreputationlevel (15) : Processed 15 Rows in 0.011 Seconds 
Processing vbroute (1) : Processed 1 Rows in 0.009 Seconds 
Processing vbrssfeed (No Data) 
Processing vbrsslog (No Data) 
Processing vbsearchcore (34729) : Processed 34729 Rows in 15.824 Seconds 
Processing vbsearchcore_text (34749) : Processed 34749 Rows in 16.462 Seconds 
Processing vbsearchgroup (14292) : Processed 14292 Rows in 5.327 Seconds 
Processing vbsearchgroup_text (14299) : Processed 14299 Rows in 3.783 Seconds 
Processing vbsearchlog (597) : Processed 597 Rows in 0.523 Seconds 
Processing vbsession (1976) : Processed 1976 Rows in 0.872 Seconds 
Processing vbsetting (455) : Processed 455 Rows in 0.286 Seconds 
Processing vbsettinggroup (55) : Processed 55 Rows in 0.017 Seconds 
Processing vbsigparsed (142) : Processed 142 Rows in 0.136 Seconds 
Processing vbsigpic (21) : Processed 21 Rows in 0.044 Seconds 
Processing vbsmilie (41) : Processed 41 Rows in 0.016 Seconds 
Processing vbsocialgroup (5) : Processed 5 Rows in 0.006 Seconds 
Processing vbsocialgroupcategory (1) : Processed 1 Rows in 0.023 Seconds 
Processing vbsocialgroupicon (5) : Processed 5 Rows in 0.025 Seconds 
Processing vbsocialgroupmember (32) : Processed 32 Rows in 0.017 Seconds 
Processing vbspamlog (No Data) 
Processing vbstats (256) : Processed 256 Rows in 0.058 Seconds 
Processing vbstrikes (29) : Processed 29 Rows in 0.027 Seconds 
Processing vbstyle (2) : Processed 2 Rows in 0.058 Seconds 
Processing vbstylevar (631) : Processed 631 Rows in 0.118 Seconds 
Processing vbstylevardfn (361) : Processed 361 Rows in 0.102 Seconds 
Processing vbsubscribediscussion (No Data) 
Processing vbsubscribeevent (No Data) 
Processing vbsubscribeforum (10) : Processed 10 Rows in 0.01 Seconds 
Processing vbsubscribegroup (1) : Processed 1 Rows in 0.009 Seconds 
Processing vbsubscribethread (1982) : Processed 1982 Rows in 0.271 Seconds 
Processing vbsubscription (No Data) 
Processing vbsubscriptionlog (No Data) 
Processing vbsubscriptionpermission (No Data) 
Processing vbtachyforumcounter (No Data) 
Processing vbtachyforumpost (No Data) 
Processing vbtachythreadcounter (No Data) 
Processing vbtachythreadpost (No Data) 
Processing vbtag (12116) : Processed 12116 Rows in 3.427 Seconds 
Processing vbtagcontent (64171) : Processed 64171 Rows in 12.266 Seconds 
Processing vbtaggregate_temp_1245221760 (No Data) 
Processing vbtagsearch (36236)
Reply With Quote
  #35  
Old 12-30-2009, 05:24 PM
voglermc's Avatar
voglermc voglermc is offline
 
Join Date: Oct 2006
Location: Piedmont Triad, NC, USA
Posts: 295
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

15.6 secs! wow
Reply With Quote
  #36  
Old 12-31-2009, 03:08 PM
PPUS PPUS is offline
 
Join Date: Mar 2009
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Been waiting for this too. Thanks for your work Paul!
Reply With Quote
  #37  
Old 12-31-2009, 03:38 PM
Veer Veer is offline
 
Join Date: Feb 2006
Posts: 733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Processed Database in 49.229 seconds (223 MB)

Backup Completed Successfully

Thanks.
Reply With Quote
  #38  
Old 01-01-2010, 05:55 AM
Dr.osamA's Avatar
Dr.osamA Dr.osamA is offline
 
Join Date: Aug 2004
Location: Syrie
Posts: 979
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

installed

thanxx
________
MEDICAL MARIJUANA
Reply With Quote
  #39  
Old 01-01-2010, 08:43 AM
t2cervens t2cervens is offline
 
Join Date: May 2008
Posts: 9
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thanks for the mod
I'm on hostgator
when I try to perform a full backup, all seems ok
but it stops to
.....
.....
Processing postindex (2241365)

nothing below

in the backup directory, I can see a 220 megs sql file

is it a full good backup ? I don't know... I think i should get a confirmation message ( like backup is ok ) ?

is there something I should modify ?

tia
Reply With Quote
  #40  
Old 01-01-2010, 12:15 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Turn on the block processing and see what happens.
Reply With Quote
  #41  
Old 01-01-2010, 02:33 PM
note2you note2you is offline
 
Join Date: Jun 2006
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i tries manual and found error

Automatic Database Backup for vBulletin
Backup Error : Could not write to destination file ( .../bkp/vbulletin_backup/2010-01-01/Forum-2010-01-01-Vb_access.sql )

how to fix it
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 09:34 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05040 seconds
  • Memory Usage 2,361KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (14)post_thanks_box_bit
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete