Administrative and Maintenance Tools - vB Database Backup Pro (Lite) for vb 3.6

This modification is no longer available or supported.

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 for vb 3.6.

The original version was by Trigunflame and the rights to the code were bought by Zoints (D.Chapman) in January. A while ago David gave me permission to release my adaption, but until now I haven't got round to it. Trigunflame did mention a few months ago he was working on a new version, but nothing ever appeared.

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. It's been in use on our forum since the day 3.6 was installed.

Notes:
* I will not add anything new to this, or spend vast amounts of time supporting it.
* This is a Lite version to allow people to use the basic 3.0 backup functionality on 3.6.


History:

v2.10 : First internal version.
v2.11 : Bug fixes, some code changes.
v2.12 : Initial Public Release.

[steadicamop]

Originally Posted by Paul M

You can change the timeout if you want (in cronbackup.php) - but tbh, if you have such a large postindex file then I would consider switching to using the vb fulltext search method and clear the postindex table out.

Sounds like a plan! I'm not too sure how to enable vb fulltext search, I had a quick look in the AdminCP and couldn't find anything, sorry to be a pain but any chance you could tell me where to find this?

Thanks!

Jason

[Paul M]

In the vbulletin options menu there should be two links - one for the options, and one for search type.

[bashy]

Hi Paul, yeah i know what ya said m8 but the actual file says, with trailing /, bit misleadin if your saying without trailing /
Thats what im on about m8

  $backup['DUMP_PATH']    = DIR.'/folder/forums/and/so/on';  // Path ( With trailing '/' )

Originally Posted by Paul M

I suggest you read it again. I said DIR is the path to your forum, with no trailing '/' in it.

[Paul M]

There is nothing misleading, you are not reading it correctly - as already explained elsewhere, DIR is a constant defined by vbulletin, it has no trailing '/' in it. If you still don't understand then please PM me, not clutter up this thread.

[steadicamop]

Originally Posted by Paul M

In the vbulletin options menu there should be two links - one for the options, and one for search type.

It's an elusive option I'm not totally sure what I'm looking for, I did find one called Duplicate Search Index Information on Thread Copy? but not sure if that's the right one.

I cleared out the postindex table, but again, it doesn't complete a full back up, it just gets further down the tables (it doesn't actually reach the user table). This is a little frustrating, I'm beginning to think my host is the issue here, I've had backup problems before.

Thanks,

Jason

[Paul M]

I think you are looking in the wrong place for the search option, see screenshot.

[steadicamop]

<font color="Navy">*puts glasses back on, squints</font> -- aaaah yes I'm so stupid to miss it there!!!

Thanks, done that, but I am still having that issue with it not completing a full back up, I do have a few extra tables in the database, but it's only around 20mb or so, I just can't understand why it never backs up completely :ermm: :ermm:

[exilera]

Does this add-on allow for a partial backup? If I wanted to just backup a part of the database related to user accounts, would that allow me to do so?

[Jealousy10312]

Originally Posted by Paul M

If you just want to specify a direct path then do so - e.g.

PHP Code:

 $backup['DUMP_PATH'] = 'e:/some/path/mybackups/';  // Path ( With trailing '/' ) 


So where you put the "e:/" that's for Windows servers?

Also, the path /some/path/ .. is that inluding your root? Or is that the path of the folder you're currently in? For example, say I wanted to install it in includes/ folder, I would put "e:/includes/mybackups"

?

Thanks

[bashy]

Thanks a lot paul, sorted now and working well, your explanation help no end, Sorry for being a bit thick

Originally Posted by Paul M

There seems to be a lot of confusion about this line ;

PHP Code:

 $backup['DUMP_PATH'] = DIR.'/../../backups/';  // Path ( With trailing '/' ) 


Please note that the DIR is on the righthand side of the equals, and is a constant created by vbulletin - it is the full path to your forums root folder.

For example (in windows) it might be "d:/wwwroot/forum" - it has NO trailing '/' at the end, so the rest of the path definition adds one - so in this example the path defined above is "d:/wwwroot/forum/../../backups/" - which with the two '../' translates into "d:/backups/" a folder outside your public html folder. That backups folder must be writable by the webserver.

If you just want to specify a direct path then do so - e.g.

PHP Code:

 $backup['DUMP_PATH'] = 'e:/some/path/mybackups/';  // Path ( With trailing '/' )