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.

[Robru]

Originally Posted by Dragonsys

if you can use php.ini create one in your admincp and make the amount of mem = 8MB and increase by 4 (12, 16, 20, etc) until you stop getting this message.

Thanks for your advise, a higher Mem increase to 16 do the trick, it works well now

[oddmud]

Thanks this is great, I wasn't backing up at all until now. LOL!!!

[dmlysiak]

Originally Posted by dmlysiak

I have a problem when I go to the forum page is displayed to me

Processing access (No Row Data)<br />Processing action (No Row Data)<br />Processing ad (No Row Data)<br />Processing adcriteria (No Row Data)<br />Processing adminhelp (1670) : Processed 1670 Rows in 0.053 Seconds <br />Processing administrator (5) : Processed 5 Rows in 0.001 Seconds <br />Processing adminlog (7161) : Processed 7161 Rows in 0.228 Seconds <br />Processing adminmessage (1) : Processed 1 Rows in 0.001 Seconds <br />Processing adminutil (2) : Processed 2 Rows in 0 Seconds <br />Processing album (No Row Data)<br />Processing albumupdate (No Row Data)<br />Processing announcement (No Row Data)<br />Processing announcementread (No Row Data)<br />Processing attachment (No Row Data)<br />Processing attachmentcategory (No Row Data)<br />Processing attachmentcategoryuser (No Row Data)<br />Processing attachmentpermission (No Row Data)<br />Processing attachmenttype (11) : Processed 11 Rows in 0.001 Seconds <br />Processing attachmentviews (No Row Data)<br />Processing avatar (No Row Data)<br />Processing bbcode (1) : Processed 1 Rows in 0 Seconds <br />Processing bbcode_video (7) : Processed 7 Rows in 0.001 Seconds <br />Processing block (2) : Processed 2 Rows in 0.001 Seconds <br />Processing blockconfig (5) : Processed 5 Rows in 0 Seconds <br />Processing blocktype (5) : Processed 5 Rows in 0.001 Seconds <br />Processing bookmarksite (4) : Processed 4 Rows in 0.001 Seconds <br />Processing cache (6) : Processed 6 Rows in 0.001 Seconds <br />Processing cacheevent (3) : Processed 3 Rows in 0 Seconds <br />Processing calendar (1) : Processed 1 Rows in 0 Seconds <br />Processing calendarcustomfield (No Row Data)<br />Processing calendarmoderator (No Row Data)<br />Processing calendarpermission (No Row Data)<br />Processing contentpriority (No Row Data)<br />Processing contenttype (14) : Processed 14 Rows in 0.001 Seconds <br />Processing cpsession (2) : Processed 2 Rows in 0 Seconds <br />Processing cron (21) : Processed 21 Rows in 0.001 Seconds <br />Processing cronlog (242) : Processed 242 Rows in 0.007 Seconds <br />Processing customavatar (3) : Processed 3 Rows in 0.001 Seconds <br />Processing customprofilepic (2) : Processed 2 Rows in 0 Seconds <br />Processing datastore (35) : Processed 35 Rows in 0.008 Seconds <br />Processing deletionlog (No Row Data)<br />Processing discussion (No Row Data)<br />Processing discussionread (No Row Data)<br />Processing editlog (1) : Processed 1 Rows in 0 Seconds <br />Processing event (No Row Data)<br />Processing externalcache (1) : Processed 1 Rows in 0.002 Seconds <br />Processing faq (42) : Processed 42 Rows in 0.002 Seconds <br />Processing filedata (No Row Data)<br />Processing forum (153) : Processed 153 Rows in 0.017 Seconds <br />Processing forumpermission (14) : Processed 14 Rows in 0.001 Seconds <br />Processing forumprefixset (1) : Processed 1 Rows in 0 Seconds <br />Processing forumread (No Row Data)<br />Processing groupmessage (No Row Data)<br />Processing groupmessage_hash (No Row Data)<br />Processing groupread (No Row Data)<br />Processing holiday (No Row Data)<br />Processing humanverify (No Row Data)<br />Processing hvanswer (No Row Data)<br />Processing hvquestion (No Row Data)<br />Processing icon (14) : Processed 14 Rows in 0.001 Seconds <br />Processing imagecategory (3) : Processed 3 Rows in 0.001 Seconds <br />Processing imagecategorypermission (No Row Data)<br />Processing indexqueue (10) : Processed 10 Rows in 0.001 Seconds <br />Processing infraction (5) : Processed 5 Rows in 0.001 Seconds <br />Processing infractionban (2) : Processed 2 Rows in 0 Seconds <br />Processing infractiongroup (No Row Data)<br />Processing infractionlevel (7) : Processed 7 Rows in 0.001 Seconds <br />Processing language (2) : Processed 2 Rows in 0.033 Seconds <br />Processing linkback (No Row Data)<br />Processing mailqueue (No Row Data)<br />Processing moderation (No Row Data)<br />Processing moderator (2) : Processed 2 Rows in 0 Seconds <br />Processing moderatorlog (261) : Processed 261 Rows in 0.016 Seconds <br />Processing notice (3) : Processed 3 Rows in 0.001 Seconds <br />Processing noticecriteria (4) : Processed 4 Rows in 0 Seconds <br />Processing noticedismissed (1) : Processed 1 Rows in 0 Seconds <br />Processing package (1) : Processed 1 Rows in 0 Seconds <br />Processing passwordhistory (67) : Processed 67 Rows in 0.002 Seconds <br />Processing paymentapi (7) : Processed 7 Rows in 0.001 Seconds <br />Processing paymentinfo (No Row Data)<br />Processing paymenttransaction (No Row Data)<br />Processing phrase (16909) : Processed 16909 Rows in 0.683 Seconds <br />Processing phrasetype (72) : Processed 72 Rows in 0.003 Seconds <br />Processing picturecomment (No Row Data)<br />Processing picturecomment_hash (No Row Data)<br />Processing picturelegacy (No Row Data)<br />Processing plugin (82) : Processed 82 Rows in 0.004 Seconds <br />Processing pm (18) : Processed 18 Rows in 0.001 Seconds <br />Processing pmreceipt (2) : Processed 2 Rows in 0.001 Seconds <br />Processing pmtext (16) : Processed 16 Rows in 0.001 Seconds <br />Processing pmthrottle (No Row Data)<br />Processing podcast (No Row Data)<br />Processing podcastitem (No Row Data)<br />Processing poll (No Row Data)<br />Processing pollvote (No Row Data)<br />Processing post (71) : Processed 71 Rows in 0.009 Seconds <br />Processing postedithistory (2) : Processed 2 Rows in 0.001 Seconds <br />Processing posthash (4) : Processed 4 Rows in 0.008 Seconds <br />Processing postlog (16) : Processed 16 Rows in 0.001 Seconds <br />Processing postparsed (39) : Processed 39 Rows in 0.005 Seconds <br />Processing prefix (10) : Processed 10 Rows in 0.001 Seconds <br />Processing prefixpermission (No Row Data)<br />Processing prefixset (1) : Processed 1 Rows in 0 Seconds <br />Processing product (5) : Processed 5 Rows in 0.001 Seconds <br />Processing productcode (11) : Processed 11 Rows in 0.001 Seconds <br />Processing productdependency (1) : Processed 1 Rows in 0 Seconds <br />Processing profileblockprivacy (No Row Data)<br />Processing profilefield (4) : Processed 4 Rows in 0.001 Seconds <br />Processing profilefieldcategory (No Row Data)<br />Processing profilevisitor (64) : Processed 64 Rows in 0.002 Seconds <br />Processing ranks (5) : Processed 5 Rows in 0.001 Seconds <br />Processing reminder (No Row Data)<br />Processing reputation (1) : Processed 1 Rows in 0 Seconds <br />Processing reputationlevel (15) : Processed 15 Rows in 0.001 Seconds <br />Processing route (No Row Data)<br />Processing rssfeed (No Row Data)<br />Processing rsslog (No Row Data)<br />Processing searchcore (224) : Processed 224 Rows in 0.009 Seconds <br />Processing searchcore_text (242) : Processed 242 Rows in 0.01 Seconds <br />Processing searchgroup (220) : Processed 220 Rows in 0.007 Seconds <br />Processing searchgroup_text (234) : Processed 234 Rows in 0.005 Seconds <br />Processing searchlog (17) : Processed 17 Rows in 0.002 Seconds <br />Processing session (5) : Processed 5 Rows in 0.001 Seconds <br />Processing setting (470) : Processed 470 Rows in 0.022 Seconds <br />Processing settinggroup (55) : Processed 55 Rows in 0.002 Seconds <br />Processing sigparsed (No Row Data)<br />Processing sigpic (No Row Data)<br />Processing smilie (11) : Processed 11 Rows in 0.001 Seconds <br />Processing socialgroup (No Row Data)<br />Processing socialgroupcategory (1) : Processed 1 Rows in 0 Seconds <br />Processing socialgroupicon (No Row Data)<br />Processing socialgroupmember (No Row Data)<br />Processing spamlog (No Row Data)<br />Processing stats (75) : Processed 75 Rows in 0.002 Seconds <br />Processing strikes (No Row Data)<br />Processing style (2) : Processed 2 Rows in 0.006 Seconds <br />Processing stylevar (715) : Processed 715 Rows in 0.02 Seconds <br />Processing stylevardfn (441) : Processed 441 Rows in 0.019 Seconds <br />Processing subscribediscussion (No Row Data)<br />Processing subscribeevent (No Row Data)<br />Processing subscribeforum (1) : Processed 1 Rows in 0 Seconds <br />Processing subscribegroup (No Row Data)<br />Processing subscribethread (No Row Data)<br />Processing subscription (No Row Data)<br />Processing subscriptionlog (No Row Data)<br />Processing subscriptionpermission (No Row Data)<br />Processing tachyforumcounter (No Row Data)<br />Processing tachyforumpost (No Row Data)<br />Processing tachythreadcounter (No Row Data)<br />Processing tachythreadpost (No Row Data)<br />Processing tag (37) : Processed 37 Rows in 0.001 Seconds <br />Processing tagcontent (64) : Processed 64 Rows in 0.002 Seconds <br />Processing tagsearch (49) : Processed 49 Rows in 0.001 Seconds <br />Processing template (1456) : Processed 1456 Rows in 0.283 Seconds <br />Processing templatehistory (2) : Processed 2 Rows in 0.001 Seconds <br />Processing templatemerge (1) : Processed 1 Rows in 0 Seconds <br />Processing thread (67) : Processed 67 Rows in 0.008 Seconds <br />Processing thread_serviceupdate (No Row Data)<br />Processing threadrate (No Row Data)<br />Processing threadread (No Row Data)<br />Processing threadredirect (No Row Data)<br />Processing threadviews (10) : Processed 10 Rows in 0 Seconds <br />Processing upgradelog (10) : Processed 10 Rows in 0.001 Seconds <br />Processing user (40) : Processed 40 Rows in 0.009 Seconds <br />Processing useractivation (2) : Processed 2 Rows in 0.001 Seconds <br />Processing userban (No Row Data)<br />Processing userchangelog (69) : Processed 69 Rows in 0.003 Seconds <br />Processing usercss (No Row Data)<br />Processing usercsscache (No Row Data)<br />Processing userfield (40) : Processed 40 Rows in 0.001 Seconds <br />Processing usergroup (11) : Processed 11 Rows in 0.002 Seconds <br />Processing usergroupleader (No Row Data)<br />Processing usergrouprequest (No Row Data)<br />Processing userlist (19) : Processed 19 Rows in 0.001 Seconds <br />Processing usernote (No Row Data)<br />Processing userpromotion (No Row Data)<br />Processing usertextfield (40) : Processed 40 Rows in 0.001 Seconds <br />Processing usertitle (No Row Data)<br />Processing vbseo_blacklist (1) : Processed 1 Rows in 0 Seconds <br />Processing vbseo_linkback (1) : Processed 1 Rows in 0 Seconds <br />Processing vbseo_serviceupdate (139) : Processed 139 Rows in 0.003 Seconds <br />Processing visitormessage (2) : Processed 2 Rows in 0.001 Seconds <br />Processing visitormessage_hash (No Row Data)<br /><br />Processed Database in 1.537 seconds<br /><br /><i>[Compressing Combined File]</i> : Processed File Compression in 0.964 seconds<br /><br />Backup Completed Successfully

vb 4.0.5
happens at 23.00 hours, when the cron to do backups
* 23 * * * Automatic Database Backup for vBulletin

who help me?

[sas forum]

I installed, chose my folder and then ran the task manager and got an email showing me a DB error. After processing all the tables the page said:

Processed Database in 170.889 seconds

[Compressing Combined File] : Processed File Compression in 27.256 seconds

Backup Completed Successfully

And then:

Database error in vBulletin 4.0.5:

Database error in vBulletin 4.0.5:

Invalid SQL:

INSERT INTO cronlog
(varname, dateline, description, type)
VALUES
('cbu_crontask',
#########,
'Backup Completed Successfully',
0);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, July 28th 2010 @ 07:51:13 PM
Error Date : Wednesday, July 28th 2010 @ 07:54:32 PM
Script : http://www.website.com/forum/admincp...cron&cronid=20
Referrer : http://www.website.com/forum/admincp....php?do=modify
IP Address : ##.###.###.##
Username : username
Classname : vB_Database
MySQL Version :



From what I could tell, the file did not save in the specified folder either.

Any help would be great. This looks like a welcome addition to my site. Thanks for the work put into this.

[Paul M]

The file must have saved somewhere, otherwise you would not get the timing messages.

The database error means vbulletin failed to insert the completed ok message in the cronlog - the actual error suggests the database connection of the session running the task timed out.

[Bigstack]

Originally Posted by chicken604

How do I manually run this? (To test if it's working)

go into Scheduled Task Manager and hit run now

[GONUMBER6]

Installed. When I click 'run now' nothing happens tho. It just sits there and does not do anything?

I created a folder for backups like this, and this is how I entered it in the cron job. Do I need to add httpdocs, 2 dots, one dot? ./forums/backups/

This is the full path it is in (below),so please direct me? thx

englishbulldognews.com/httpdocs/forums/backups/

I am sure it is just an error in how I have entered the folder path, but I do not want to mess with it too much before I mess up my forum LOL

[Paul M]

If it does nothing at all you have some sort of installation issue i would guess, it will always attempt to run, even if it then gives an error.

[GONUMBER6]

hmmm, that is strange. I uplaoded the files, but I will reupload again tomorrow and see what happens. thx

Yes, all it says when I hit 'run now' is 'Automatic database backup for vbulletin.'

But nothing else happens....

[GoTTi]

will this work with 3.8.x?