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.

[Paul M]

There is generally more involved than just the folder settings (which themselves are fine). Things like open_basdir can restrict what areas apache can write too. Its also not possible from your post to see where the folder is in relation to your vb installation. Like I said, most peoples set-ups are slightly different.

[Gamelobby]

I see.. yea i guess my example could be misleading. Mine is set outside the Forums

example.com/Notforumsfolder/backupfiles

Any suggestions what i could try that could be not allowing it to write/work.?

Thanks

[TeknoSounds]

do you have access to your logs? could check there to see if the job is throwing something in there that could be an indication.

As for my site I have it set up as:
BU folder location
mysite.com/backups

settings in acp:
../backups/

running on linux.

[Gamelobby]

Originally Posted by TeknoSounds

do you have access to your logs? could check there to see if the job is throwing something in there that could be an indication.

As for my site I have it set up as:
BU folder location
mysite.com/backups

settings in acp:
../backups/

running on linux.

Where, which logs.?


Wait, am i literally supposed to use dots.?
.../backups

Because if so, that is probably the issue. lol

[Paul M]

Yes, the dots are important (two dots, not three, and a slash)

../ means up one folder level.

[prandah]

hello paul

i used this on my server
i use xen memroy 1GB

but yesterday when i run this
i get error
here is my error ?

PHP Code:

Database error in vBulletin 4.1.2:

Invalid SQL:

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

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, May 11th 2011 @ 04:09:35 PM
Error Date : Wednesday, May 11th 2011 @ 04:11:36 PM
Script : http://www.ditusuk.com/tempik/cronadmin.php?do=runcron&cronid=40
Referrer : http://www.ditusuk.com/tempik/cronadmin.php?do=modify
IP Address : 123.456.789
Username : Admin
Classname : vB_Database
MySQL Version : 


what should i do ?

[marianoblesa]

This is where you put?

<!-- $Header: F:\CVS/4.x/Auto-backup/Auto-backup.txt,v 1.3 2010/12/04 22:52:33 Pem Exp $ -->

[Paul M]

Originally Posted by prandah

what should i do ?

Read back a few posts - your mysql timeout is low, so the connection is timing out, probably because you are gzipping the file.

[Paul M]

Originally Posted by marianoblesa

This is where you put?

<!-- $Header: F:\CVS/4.x/Auto-backup/Auto-backup.txt,v 1.3 2010/12/04 22:52:33 Pem Exp $ -->

I dont know what you are asking.

[prandah]

Originally Posted by Paul M

Read back a few posts - your mysql timeout is low, so the connection is timing out, probably because you are gzipping the file.

so do I have to rebuild Gzip again?
or whether the database could still be in use ( can be dump )? because there is an error log?