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.

[Simon Lloyd]

Hi Paul, i have to say with the old version prior to the one with no gzip i had no problem backing up once a week (i had to check my backups after responding to the post above) but with the new version using gzip i find that doing a daily backup only backed up a small portion of my database, with the final file in the folder NOT being compressed.

Is there anyway i can have the previous xml to go back to please?

[Paul M]

There is no difference between them as far as actual backups are concerned.

[Simon Lloyd]

Hmm. it's odd then, i set the backup to be daily and every day it only backed up the first say 25 tables, i've deleted them now but how ever many it was it was exactly the same in each days folder and always the last file (which just happened to be attachments) wasn't compressed, i've set cron to just onday now and see how we go

[Paul M]

I just checked, and the only changes are for Gzip. What happens if you run it manually ?

[Simon Lloyd]

Just ran it manually, when using gzip i get this after it cas compressed 31 tables:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 21605379 bytes) in /home/thecodec/public_html/forumz/includes/mysqlbackup.php on line 498

So using GZIP is causing me to run out of memory?

EDIT: in fact i just turned off GZIP and get the same thing, it always ends on

.............
Processing vb_announcementread (9) : Processed 9 Rows in 0.001 seconds
Processing vb_attachment (591)
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 21605379 bytes) in /home/thecodec/public_html/forumz/includes/mysqlbackup.php on line 498

EDIT2: here's my forum stats:

Server Type Linux
Web Server Apache v2.0.63
PHP 5.2.9
MySQL Version 5.0.91-community-log
Data Usage 1.16 GB
PHP Max Post Size 50.00 MB
PHP Maximum Upload Size 50.00 MB
PHP Memory Limit 64.00 MB
MySQL Packet Size 64.00 MB
Index Usage 496.61 MB
Attachment Usage 76.69 MB
Avatar Usage 180.9 KB
Profile Picture Usage 74.0 KB

[Simon Lloyd]

UPDATE
I moved the attachments to the file system and can confirm that this mod works fine both with and without gzip.

I don't know if there was a work around to it but the post table was like 1.4Gb and it didn't stall at that and compressed it nicely to 331mb!

[larry suttles]

To set the date formate to a lower case "L" would is look like this??

Y-m-l

Or do I just put the lower case "l" by it's self?

l

[Simon Lloyd]

just the "l"

[slowphantom]

hi Pual

my host change my php.ini file

and since thay change it the hack dosnt work
i try it to run it but it give

An error occured during the Backup :

that is all it dosnt give any des about the error

so i looked at the old one and the new one
and saw

disable_functions it have code will pm u with it

Thanks

[Paul M]

Originally Posted by slowphantom

hi Pual

my host change my php.ini file

Change it back.

Ive looked at what you sent me and tbh, its a wonder anything works, ive never seen a disable functions list so large, it would take me ages to check through all the entries in it.