Administrative and Maintenance Tools - vB Database Backup (Lite)

As of 24 Nov 2017 this modification has been withdrawn.

Note: I did not write the original version, but rather have modified & adapted it.

When vb 3.5 first came out I was using this backup system on my vb 3.0 - and having nothing better to use - I converted it to work on vb 3.5 (here) and since then I have cut it down and adapted it, first for vb 3.6, 3.7 and now for vb3.8.

The original version was by Trigunflame and the rights to the code were bought by Zoints (David Chapman) in January 2007. Later in 2007 David gave me permission to release my adaptation.

I have stripped out much of the extra stuff that I do not use (or indeed, could not get to work). This is a simple (Lite) version that does a php based dump of your database either as one file, or one file per table.

As of version 3.8.002, most of the options have moved to the ACP in vBulletin Options >> vBulletin Automatic Backup

Notes:
* I will not be adding anything new to this modification.
* This is a Lite version to allow people to use the basic backup functionality on 3.8.


History:

v3.8.001 : First version for vB 3.8.
v3.8.002 : Moved most of options to ACP.
v3.8.003 : Moved more options to ACP.
v3.8.004 : Gzip option backported from vb4 version.
v3.8.005 : Split option backported from vb4 version, close option removed.
v3.8.006 : Fix php 5.3 deprecated warning.

[Walter Ronny]

i works! ok so now, im looking for to get another hosting and move all info of my forum to the new hosting ill looking for to get.. what exactly i have to do ? do ill lose any info ?

[Kolbi]

Do I really have to set the folders to 777? Isn´t it unsecure?

[Paul M]

Apache needs write access to create the files, how you do that is upto you - 777 is the easiest way.

[madotds]

Cheers paul for this mod

Just for information:

For those of you who would like your sql dumps to be a little more secure, It is posible to have them save outside of your "public folder"
all you need to do is find out the full path to your sever for example mine looks something like this.

$backup['DUMP_PATH']	= '/home/fhlinux123/x/yoururl.com/user/mysqlbackups/';  //

Then just make sure the folder you defined in red is chmod 777. (you can do this through your FTP client and right clicking selecting properties if you are on a lynux sever. I dont know about any other severs.

I am far from an expert but hope this helps someone.

Regards

Madotds

[mokujin]

When I run this cron, after a few seconds there show these lines:

Automatic Database Backup for vBulletin 3.8 

Processing access : Total Rows = 0
Processing adminhelp : Total Rows = 1748
Processing administrator : Total Rows = 4
Processing adminlog : Total Rows = 5937
Processing adminmessage : Total Rows = 3
Processing adminutil : Total Rows = 3
Processing album : Total Rows = 130
Processing albumpicture : Total Rows = 933
Processing albumupdate : Total Rows = 0
Processing announcement : Total Rows = 12
Processing announcementread : Total Rows = 1061
Processing attachment : Total Rows = 753
Processing attachmentpermission : Total Rows = 0
Processing attachmenttype : Total Rows = 10
Processing attachmentviews : Total Rows = 0
Processing automediaembed : Total Rows = 0
Processing avatar : Total Rows = 0
Processing bbcode : Total Rows = 5
Processing bookmarksite : Total Rows = 4
Processing calendar : Total Rows = 1
Processing calendarcustomfield : Total Rows = 0
Processing calendarmoderator : Total Rows = 0
Processing calendarpermission : Total Rows = 0
Processing cpsession : Total Rows = 1
Processing credits_bank : Total Rows = 2
Processing credits_lottery : Total Rows = 0
Processing credits_transactions : Total Rows = 52
Processing cron : Total Rows = 19
Processing cronlog : Total Rows = 588
Processing customavatar : Total Rows = 825
Processing customprofilepic : Total Rows = 362
Processing datastore : Total Rows = 38
Processing deletionlog : Total Rows = 1362
Processing discussion : Total Rows = 5
Processing discussionread : Total Rows = 0
Processing editlog : Total Rows = 11242
Processing event : Total Rows = 1
Processing externalcache : Total Rows = 3
Processing faq : Total Rows = 42
Processing forum : Total Rows = 206
Processing forumpermission : Total Rows = 40
Processing forumprefixset : Total Rows = 17
Processing forumread : Total Rows = 0
Processing gb_cache : Total Rows = 1099
Processing gb_media : Total Rows = 1099
Processing groupmessage : Total Rows = 20
Processing groupmessage_hash : Total Rows = 20
Processing groupread : Total Rows = 0
Processing holiday : Total Rows = 0
Processing humanverify : Total Rows = 4
Processing hvanswer : Total Rows = 2
Processing hvquestion : Total Rows = 1
Processing icon : Total Rows = 16
Processing imagecategory : Total Rows = 4
Processing imagecategorypermission : Total Rows = 0
Processing infraction : Total Rows = 825
Processing infractionban : Total Rows = 2
Processing infractiongroup : Total Rows = 0
Processing infractionlevel : Total Rows = 8
Processing language : Total Rows = 2
Processing mailqueue : Total Rows = 0
Processing moderation : Total Rows = 95
Processing moderator : Total Rows = 67
Processing moderatorlog : Total Rows = 9199
Processing nhac_song : Total Rows = 19
Processing notice : Total Rows = 1
Processing noticecriteria : Total Rows = 1
Processing noticedismissed : Total Rows = 0
Processing passwordhistory : Total Rows = 22395
Processing paymentapi : Total Rows = 7
Processing paymentinfo : Total Rows = 38
Processing paymenttransaction : Total Rows = 16
Processing phrase : Total Rows = 13155
Processing phrasetype : Total Rows = 68
Processing picture : Total Rows = 933
Processing picturecomment : Total Rows = 139
Processing picturecomment_hash : Total Rows = 193
Processing plugin : Total Rows = 144
Processing pm : Total Rows = 32552
Processing pmreceipt : Total Rows = 9
Processing pmtext : Total Rows = 26650
Processing pmthrottle : Total Rows = 0
Processing podcast : Total Rows = 0
Processing podcastitem : Total Rows = 0
Processing poll : Total Rows = 61
Processing pollvote : Total Rows = 3716
Processing post : Total Rows = 146373
Processing post_thanks : Total Rows = 306367
Processing postedithistory : Total Rows = 0
Processing posthash : Total Rows = 0
Processing postindex : Total Rows = 1204613

So I think I havent backuped all tables?
Need your help, Paul!

[Kolbi]

I hade the same problem. But then the cron job automatically makes an backup all vb_ prefixes are backed up.

[mokujin]

Originally Posted by Kolbi

I hade the same problem. But then the cron job automatically makes an backup all vb_ prefixes are backed up.

I still cant backup.

[Kolbi]

How big is your database? (sorry for my english i?m german...)

[mokujin]

Originally Posted by Kolbi

How big is your database? (sorry for my english i?m german...)

about 600mb, i'm czech

[tijmen_4real]

How can i change the time/frequency the backups are made?