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.

[Paul M]

The only time this modification can actually change anything on a site is if you use the 'shutdown' option to close your forum during a backup, in theory if the save of the options failed for some bizarre reason then the options in the datastore could get corrupted (simply editing an option would rebuild them I think).

Other than that, this has no capability to change anything, it's a "read only" modification.

Given that the basic code (written by Trigunflame) has been in use for over two years without any other such reports, I'm inclined to conclude that something else caused your issue. If you have evidence otherwise then please feel free to contact me.

(JFYI, This runs a backup on my site every night, and has done since the day 3.6 was released. I do not use the shutdown option.)

[philip_g]

I don't understand why the generated backup file is 53 megs when the file if I do a backup through SSH is 130 megs.

[beishe8]

Originally Posted by philip_g

I don't understand why the generated backup file is 53 megs when the file if I do a backup through SSH is 130 megs.

It is not saving your whole database, some of your tables are too large for it.
Times out incompleted,the forum stays locked.Locking and unlocking is the only way to start functioning again.
I installed it but cannot use it . It stops around 10 MB. (There is a large table which stops it.)
Tried to save the result to the server,same result.

[Deimos]

I only have problems if the PHP Memory Limit is left at default.
I have to raise it to about 100mb then it runs fine, otherwise i get an error about the memory being exausted.

[Paul M]

For reference, our server PHP limit is 32MB, and SQL packet Size is 16MB.

Our largest table (post) is about 550MB, and it backs up fine.

[Smoothie]

Originally Posted by raiderlax

You are right, I should provide solid proof of this, but I have already re-stored my site and am not going to re-install this mod to prove this, in fact I didn't really have to re-store the site, I could have just uninstalled the mod and things would have been fine, I just didn't know at first it was this mod that caused the problems on the site.

Some problems were header links missing and a lot of functionality missing on the site.

So now I will spend some time fixing up the site only because I had previous mods installed that have got messed up from re-storing the site, but if you do have problems like ones I have mention uninstall this mod to see if it is it(in my case it was) and do not go ahead and restore all your forum files like I had done

Other than that I like the idea of the mod and the way it was working until these problems arose.

I can confirm this on my site. Header links all farked-up. When I remove the product, it's back to normal. Uninstalled!!!!

[Paul M]

Originally Posted by Smoothie

I can confirm this on my site. Header links all farked-up. When I remove the product, it's back to normal. Uninstalled!!!!

1. What does "Header links all farked-up" mean exactly ?

2. As per previous posts, did you use the 'shutdown' option.

[philip_g]

Originally Posted by Paul M

For reference, our server PHP limit is 32MB, and SQL packet Size is 16MB.

Our largest table (post) is about 550MB, and it backs up fine.

my PHP is set to 64 and the SQL also set to 16. It seems to end processing the post column.


Server Type Linux
Safe Mode
Web Server Apache v2.2.3
PHP 5.1.6
PHP Max Post Size 8.00 MB
PHP Maximum Upload Size 16.00 MB
PHP Memory Limit 64.00 MB
MySQL Version 5.0.27
MySQL Packet Size 16.00 MB

Any ideas?

[Paul M]

Turn off safe mode, I have a feeling that you cannot override the default php timeout in safemode, so the script is possibly timing out.

[Smoothie]

Originally Posted by Paul M

1. What does "Header links all farked-up" mean exactly ?

2. As per previous posts, did you use the 'shutdown' option.

1. Meaning the links I have in the header (moved from the navbar, custom skin) were all messed-up. The Quick Links turned into a link for the buddy list, the login link no longer worked (it re-directed you to the forum index), the Mark forums read link suddenly appeared in the header and the New post link directed you to the style id of the skin you were using. Very odd stuff.

2. Yes