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.

[Paul M]

Originally Posted by charlesr

And how do I find out how long it takes to run on mine? The log in vb just gives time of start and "success".

You need to manually run the schedule in Schedule Manager.

[Skivey]

Hmmm... I uninstalled, reinstalled and over writ all files via ftp.

Reded settings and reran the scheduled task and again I get

Automatic Database Backup for vBulletin

Done

Bit concerning this, im not doing anything wrong.

[Paul M]

What happens if you run the sql "SHOW tables" ?

[Skivey]

it lists me a shed load of DB tables

[Skivey]

ok, really not to worry now. Ive decided to use mysqldumper instead and create a cron with the cpanel. Not only does backups of the forum but my whole list of databases.

Thanks for trying though!! )

[charlesr]

Originally Posted by Paul M

You need to manually run the schedule in Schedule Manager.

Thanks. Did that.

30 mins for the live backup and 7 mins for the compression.
Is that about what you'd expect for a database of my size? (see a few posts back).

No point in me running this once an hour! It would be in a constant state of backup

[Paul M]

Originally Posted by charlesr

30 mins for the live backup and 7 mins for the compression.
Is that about what you'd expect for a database of my size? (see a few posts back).

That seems a bit slow. I have 1.65 GB data, 900M index, and it backs up in < 10 Min.

[charlesr]

Really? How odd. I just tried it on my local PC instead (test server) which is pretty fast and it took 23mins for the backup (obviously the gzip bit didn't work), so a little faster, but not nearly as quick as yours.

Any suggestions/ideas? I checked and the database isn't fragmented to any significant degree.

[compassion23ph]

Where can i SEE the .gzip file of this?

[JMEWLS`]

Processing access (1) [Compressing File] : Processed 1 Rows in 0.029 Seconds
Processing action (18) [Compressing File] : Processed 18 Rows in 0.022 Seconds
Processing activitystream (13761) [Compressing File] : Processed 13761 Rows in 0.766 Seconds
Processing activitystreamtype (16) [Compressing File] : Processed 16 Rows in 0.005 Seconds
Processing ad (3) [Compressing File] : Processed 3 Rows in 0.023 Seconds
Processing adcriteria (No Row Data) [Compressing File]
Processing adminhelp (1801) [Compressing File] : Processed 1801 Rows in 0.091 Seconds
Processing administrator (3) [Compressing File] : Processed 3 Rows in 0.005 Seconds
Processing adminlog (7557) [Compressing File] : Processed 7557 Rows in 0.828 Seconds
Processing adminmessage (3) [Compressing File] : Processed 3 Rows in 0.077 Seconds
Processing adminutil (7) [Compressing File] : Processed 7 Rows in 0.096 Seconds
Processing album (8) [Compressing File] : Processed 8 Rows in 0.016 Seconds
Processing albumupdate (No Row Data) [Compressing File]
Processing announcement (3) [Compressing File] : Processed 3 Rows in 0.104 Seconds
Processing announcementread (112) [Compressing File] : Processed 112 Rows in 0.007 Seconds
Processing apiclient (No Row Data) [Compressing File]
Processing apilog (No Row Data) [Compressing File]
Processing apipost (No Row Data) [Compressing File]
Processing attachment (116) [Compressing File] : Processed 116 Rows in 0.065 Seconds
Processing attachmentcategory (No Row Data) [Compressing File]
Processing attachmentcategoryuser (115) [Compressing File] : Processed 115 Rows in 0.039 Seconds
Processing attachmentpermission (No Row Data) [Compressing File]
Processing attachmenttype (11) [Compressing File] : Processed 11 Rows in 0.026 Seconds
Processing attachmentviews (No Row Data) [Compressing File]
Processing autosave (1031) [Compressing File] : Processed 1031 Rows in 0.142 Seconds
Processing avatar (No Row Data) [Compressing File]
Processing bbcode (No Row Data) [Compressing File]
Processing bbcode_video (8) [Compressing File] : Processed 8 Rows in 0.125 Seconds
Processing block (12) [Compressing File] : Processed 12 Rows in 0.027 Seconds
Processing blockconfig (39) [Compressing File] : Processed 39 Rows in 0.045 Seconds
Processing blocktype (6) [Compressing File] : Processed 6 Rows in 0.017 Seconds
Processing blog (No Row Data) [Compressing File]
Processing blog_attachmentlegacy (No Row Data) [Compressing File]
Processing blog_category (No Row Data) [Compressing File]
Processing blog_categorypermission (No Row Data) [Compressing File]
Processing blog_categoryuser (No Row Data) [Compressing File]
Processing blog_custom_block (No Row Data) [Compressing File]
Processing blog_custom_block_parsed (No Row Data) [Compressing File]
Processing blog_deletionlog (No Row Data) [Compressing File]
Processing blog_editlog (No Row Data) [Compressing File]
Processing blog_featured (No Row Data) [Compressing File]
Processing blog_groupmembership (No Row Data) [Compressing File]
Processing blog_grouppermission (No Row Data) [Compressing File]
Processing blog_hash (No Row Data) [Compressing File]
Processing blog_moderation (No Row Data) [Compressing File]
Processing blog_moderator (No Row Data) [Compressing File]
Processing blog_pinghistory (No Row Data) [Compressing File]
Processing blog_rate (No Row Data) [Compressing File]
Processing blog_read (No Row Data) [Compressing File]
Processing blog_relationship (No Row Data) [Compressing File]
Processing blog_search (No Row Data) [Compressing File]
Processing blog_searchresult (No Row Data) [Compressing File]
Processing blog_sitemapconf (No Row Data) [Compressing File]
Processing blog_subscribeentry (No Row Data) [Compressing File]
Processing blog_subscribeuser (No Row Data) [Compressing File]
Processing blog_summarystats (No Row Data) [Compressing File]
Processing blog_tachyentry (No Row Data) [Compressing File]
Processing blog_text (No Row Data) [Compressing File]
Processing blog_textparsed (No Row Data) [Compressing File]
Processing blog_trackback (No Row Data) [Compressing File]
Processing blog_trackbacklog (No Row Data) [Compressing File]
Processing blog_user (55) [Compressing File] : Processed 55 Rows in 0.017 Seconds
Processing blog_usercss (No Row Data) [Compressing File]
Processing blog_usercsscache (No Row Data) [Compressing File]
Processing blog_userread (No Row Data) [Compressing File]
Processing blog_userstats (No Row Data) [Compressing File]
Processing blog_views (No Row Data) [Compressing File]
Processing blog_visitor (No Row Data) [Compressing File]
Processing bookmarksite (4) [Compressing File] : Processed 4 Rows in 0.006 Seconds
Processing cache (649) [Compressing File] : Processed 649 Rows in 2.934 Seconds
Processing cacheevent (878) [Compressing File] : Processed 878 Rows in 0.031 Seconds
Processing calendar (1) [Compressing File] : Processed 1 Rows in 0.017 Seconds
Processing calendarcustomfield (No Row Data) [Compressing File]
Processing calendarmoderator (No Row Data) [Compressing File]
Processing calendarpermission (No Row Data) [Compressing File]
Processing cms_article (255) [Compressing File] : Processed 255 Rows in 0.131 Seconds
Processing cms_category (No Row Data) [Compressing File]
Processing cms_grid (2) [Compressing File] : Processed 2 Rows in 0.012 Seconds
Processing cms_layout (1) [Compressing File] : Processed 1 Rows in 0.004 Seconds
Processing cms_layoutwidget (11) [Compressing File] : Processed 11 Rows in 0.005 Seconds
Processing cms_navigation (214) [Compressing File] : Processed 214 Rows in 0.016 Seconds
Processing cms_node (214) [Compressing File] : Processed 214 Rows in 0.032 Seconds
Processing cms_nodecategory (No Row Data) [Compressing File]
Processing cms_nodeconfig (5) [Compressing File] : Processed 5 Rows in 0.036 Seconds
Processing cms_nodeinfo (214) [Compressing File] : Processed 214 Rows in 0.025 Seconds
Processing cms_permissions (18) [Compressing File] : Processed 18 Rows in 0.005 Seconds
Processing cms_rate (No Row Data) [Compressing File]
Processing cms_sectionorder (No Row Data) [Compressing File]
Processing cms_widget (14) [Compressing File] : Processed 14 Rows in 0.005 Seconds
Processing cms_widgetconfig (45) [Compressing File] : Processed 45 Rows in 0.006 Seconds
Processing cms_widgettype (21) [Compressing File] : Processed 21 Rows in 0.013 Seconds
Processing contentpriority (No Row Data) [Compressing File]
Processing contentread (1713) [Compressing File] : Processed 1713 Rows in 0.1 Seconds
Processing contenttype (28) [Compressing File] : Processed 28 Rows in 0.006 Seconds
Processing cpsession (1) [Compressing File] : Processed 1 Rows in 0.004 Seconds
Processing cron (31) [Compressing File] : Processed 31 Rows in 0.006 Seconds
Processing cronlog (54518) [Compressing File] : Processed 54518 Rows in 3.846 Seconds
Processing customavatar (343) [Compressing File] : Processed 343 Rows in 0.912 Seconds
Processing customprofile (4) [Compressing File] : Processed 4 Rows in 0.013 Seconds
Processing customprofilepic (238) [Compressing File] : Processed 238 Rows in 0.27 Seconds
Processing datastore (40) [Compressing File] : Processed 40 Rows in 0.05 Seconds
Processing dbquery (No Row Data) [Compressing File]
Processing deletionlog (2054) [Compressing File] : Processed 2054 Rows in 0.114 Seconds
Processing discussion (4) [Compressing File] : Processed 4 Rows in 0.006 Seconds
Processing discussionread (No Row Data) [Compressing File]
Processing editlog (8432) [Compressing File] : Processed 8432 Rows in 0.34 Seconds
Processing event (1) [Compressing File] : Processed 1 Rows in 0.013 Seconds
Processing externalcache (No Row Data) [Compressing File]
Processing faq (80) [Compressing File] : Processed 80 Rows in 0.016 Seconds
Processing filedata (115) [Compressing File] : Processed 115 Rows in 1.041 Seconds
Processing forum (115) [Compressing File] : Processed 115 Rows in 0.021 Seconds
Processing forumpermission (36) [Compressing File] : Processed 36 Rows in 0.017 Seconds
Processing forumprefixset (1) [Compressing File] : Processed 1 Rows in 0.011 Seconds
Processing forumread (No Row Data) [Compressing File]
Processing forumrunner_push_data (No Row Data) [Compressing File]
Processing forumrunner_push_users (No Row Data) [Compressing File]
Processing gcbos (30) [Compressing File] : Processed 30 Rows in 0.032 Seconds
Processing glowhostspamomatic_log (39214) [Compressing File] : Processed 39214 Rows in 4.184 Seconds
Processing glowhostspamomatic_remotecache (307) [Compressing File] : Processed 307 Rows in 0.248 Seconds
Processing glowhostspamomatic_stats (1) [Compressing File] : Processed 1 Rows in 0.112 Seconds
Processing groupmessage (14) [Compressing File] : Processed 14 Rows in 0.006 Seconds
Processing groupmessage_hash (No Row Data) [Compressing File]
Processing groupread (No Row Data) [Compressing File]
Processing holiday (No Row Data) [Compressing File]
Processing humanverify (24) [Compressing File] : Processed 24 Rows in 0.053 Seconds
Processing hvanswer (5) [Compressing File] : Processed 5 Rows in 0.045 Seconds
Processing hvquestion (2) [Compressing File] : Processed 2 Rows in 0.102 Seconds
Processing icon (62) [Compressing File] : Processed 62 Rows in 0.134 Seconds
Processing imagecategory (3) [Compressing File] : Processed 3 Rows in 0.007 Seconds
Processing imagecategorypermission (No Row Data) [Compressing File]
Processing indexqueue (No Row Data) [Compressing File]
Processing infraction (8) [Compressing File] : Processed 8 Rows in 0.005 Seconds
Processing infractionban (No Row Data) [Compressing File]
Processing infractiongroup (No Row Data) [Compressing File]
Processing infractionlevel (4) [Compressing File] : Processed 4 Rows in 0.016 Seconds
Processing ipdata (1713) [Compressing File] : Processed 1713 Rows in 0.194 Seconds
Processing language (1) [Compressing File] : Processed 1 Rows in 0.165 Seconds
Processing mailqueue (No Row Data) [Compressing File]
Processing moderation (9327) [Compressing File] : Processed 9327 Rows in 0.332 Seconds
Processing moderator (19) [Compressing File] : Processed 19 Rows in 0.005 Seconds
Processing moderatorlog (56661) [Compressing File] : Processed 56661 Rows in 6.044 Seconds
Processing navigation (40) [Compressing File] : Processed 40 Rows in 0.041 Seconds
Processing notice (4) [Compressing File] : Processed 4 Rows in 0.029 Seconds
Processing noticecriteria (4) [Compressing File] : Processed 4 Rows in 0.059 Seconds
Processing noticedismissed (151) [Compressing File] : Processed 151 Rows in 0.008 Seconds
Processing package (3) [Compressing File] : Processed 3 Rows in 0.005 Seconds
Processing passwordhistory (6096) [Compressing File] : Processed 6096 Rows in 0.241 Seconds
Processing paymentapi (7) [Compressing File] : Processed 7 Rows in 0.006 Seconds
Processing paymentinfo (No Row Data) [Compressing File]
Processing paymenttransaction (No Row Data) [Compressing File]
Processing phrase (16538) [Compressing File] : Processed 16538 Rows in 1.121 Seconds
Processing phrasetype (78) [Compressing File] : Processed 78 Rows in 0.008 Seconds
Processing picturecomment (27) [Compressing File] : Processed 27 Rows in 0.017 Seconds
Processing picturecomment_hash (No Row Data) [Compressing File]
Processing picturelegacy (No Row Data) [Compressing File]
Processing plugin (204) [Compressing File] : Processed 204 Rows in 0.056 Seconds
Processing pm (2514) [Compressing File] : Processed 2514 Rows in 0.11 Seconds
Processing pmreceipt (12) [Compressing File] : Processed 12 Rows in 0.008 Seconds
Processing pmtext (2178) [Compressing File] : Processed 2178 Rows in 0.474 Seconds
Processing pmthrottle (No Row Data) [Compressing File]
Processing podcast (No Row Data) [Compressing File]
Processing podcastitem (No Row Data) [Compressing File]
Processing poll (204) [Compressing File] : Processed 204 Rows in 0.089 Seconds
Processing pollvote (1656) [Compressing File] : Processed 1656 Rows in 0.11 Seconds
Processing post (317671) [Compressing File] : Processed 317671 Rows in 33.858 Seconds
Processing postedithistory (26315) [Compressing File] : Processed 26315 Rows in 4.321 Seconds
Processing posthash (7) [Compressing File] : Processed 7 Rows in 0.026 Seconds
Processing postlog (3594) [Compressing File] : Processed 3594 Rows in 0.521 Seconds
Processing postparsed (11992) [Compressing File] : Processed 11992 Rows in 1.427 Seconds
Processing postrelease (1) [Compressing File] : Processed 1 Rows in 0.14 Seconds
Processing prefix (5) [Compressing File] : Processed 5 Rows in 0.074 Seconds
Processing prefixpermission (No Row Data) [Compressing File]
Processing prefixset (1) [Compressing File] : Processed 1 Rows in 0.089 Seconds
Processing product (15) [Compressing File] : Processed 15 Rows in 0.005 Seconds
Processing productcode (23) [Compressing File] : Processed 23 Rows in 0.02 Seconds
Processing productdependency (9) [Compressing File] : Processed 9 Rows in 0.006 Seconds
Processing profileblockprivacy (80) [Compressing File] : Processed 80 Rows in 0.007 Seconds
Processing profilefield (6) [Compressing File] : Processed 6 Rows in 0.005 Seconds
Processing profilefieldcategory (No Row Data) [Compressing File]
Processing profilevisitor (4631) [Compressing File] : Processed 4631 Rows in 0.12 Seconds
Processing ranks (7) [Compressing File] : Processed 7 Rows in 0.014 Seconds
Processing reminder (No Row Data) [Compressing File]
Processing reputation (1268) [Compressing File] : Processed 1268 Rows in 0.062 Seconds
Processing reputationlevel (15) [Compressing File] : Processed 15 Rows in 0.027 Seconds
Processing route (4) [Compressing File] : Processed 4 Rows in 0.028 Seconds
Processing rssfeed (40) [Compressing File] : Processed 40 Rows in 0.008 Seconds
Processing rsslog (48182) [Compressing File] : Processed 48182 Rows in 2.455 Seconds
Processing searchcore (391069) [Compressing File]

Keeps timing out here. Switched on block processing. Not sure what else to do.