Administrative and Maintenance Tools - vBulletin Cron Based Database Backup

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.

[CRDeveloper]

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:

 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!

[haidm]

Where can I alter the timing of the cron job to suit?

[Paul M]

Originally Posted by haidm

Where can I alter the timing of the cron job to suit?

ACP > Scheduled Tasks.

[Paul M]

Originally Posted by CRDeveloper

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:

My backups were bigger than 3GB, but, i moved the attachments to file system. Last backup is about 950Mbs but incomplete!

I cant answer questions on individual servers as I have no access to them - most likely your host has set php timeouts you cannot override.

[Trek]

Paul,

I've been running this for a long time on one site I admin without a problem (vb 4.06), I just installed it on another site (vb 4.08) and when I attempt to save the settings from AdminCP-> Settions->Options, I get the following error:

You don't have permission to access /forum/admincp/options.php on this server.

It's only when I try and save the setting with this mod in view though. If I select another mod specifically, it'll save fine. If I select this one specifically (or the full list of settings options), I get this error. Any suggestions on what to do?

Thanks!

[Paul M]

Thats a server issue, probably something like mod security. You need to speak to your host.

[ShackMaster]

Hi Paul...

I have read every post and tried every combo of paths known to mankind.... but I cannot get it to work. I have our forums in public_html on a dedicated server with gzip. I have a backups folder with 777 permissions in the same home directory as the public_html folder... and have verified and reuploaded the cronbackup.php to the /includes/cron/ folder. I still get an error... here is the latest path I set... (assuming I need the same path in the Options setting and in the Scheduled Tasks setting)...

Automatic Database Backup for vBulletin

Warning: include_once([path]/../backups) [function.include-once]: failed to open stream: Success in [path]/admincp/cronadmin.php on line 113

Warning: include_once() [function.include]: Failed opening '[path]/../backups' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/admincp/cronadmin.php on line 113

Done

Your help is appreciated!

[Paul M]

You dont change anything in the Scheduled Task settings, otherwise you will break it.

[ShackMaster]

Why didn't ya just say so then... :huh:

[CRDeveloper]

Originally Posted by Paul M

You dont change anything in the Scheduled Task settings, otherwise you will break it.

If we changed, how to get it back??