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.

[shuuk]

i want to make a everyday at 20:00 autobackup..
how can i do that?

please can anyone show me that in a pic?

[TeknoSounds]

change Stunde to 20... unless your server time is offset, then you'll need to adjust for that.

[Stefan118]

Every week I let this mod make a backup of the database, and every week I get this error in my mailbox:

Database error in vBulletin 4.1.3:

Invalid SQL:

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

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Sunday, May 1st 2011 @ 05:03:34 AM
Error Date : Sunday, May 1st 2011 @ 05:20:46 AM
Script : http://www.papegaaienforum.nl/cron.php?rand=1304219014
Referrer : http://www.papegaaienforum.nl/search.php?searchid=81263
IP Address : 94.211.138.61
Username : Niet Geregistreerd
Classname : vB_Database
MySQL Version :


What can I do about it exept for disabling this mod?

[Paul M]

Originally Posted by Stefan118

What can I do about it exept for disabling this mod?

You can just ignore it. Its only the logging of the cron run after backup completion.

I would guess your mysql timeout is quite small and its timing out before the log command can be run (are you using the gzip option ?).

[Stefan118]

Ok, thank you.

Yes, I do use that, because the database is about 1.5 Gb. (350Mb with gzip)

[Paul M]

Thats why then - the Gzip is taking longer than your mysql timeout.

[Gamelobby]

Originally Posted by Paul M

Then your path is probably wrong, try ../../backupfiles/

So this should work correctly, or should i make a new folder.?
example.com/folder/_db_backups



*edit*


I created this folder

example.com/folder/backupfiles

but still get the error.?

Backup Error : Could not write to destination file

I beleive it is write-able... see image.

[CharlieDelta]

Installed and works like a charm!
Thanks Paul!!

[Paul M]

Originally Posted by Gamelobby

So this should work correctly, or should i make a new folder.?
example.com/folder/_db_backups



*edit*


I created this folder

example.com/folder/backupfiles

but still get the error.?


I beleive it is write-able... see image.

I cannot really answer server specific questions as few servers are exactly the same.

[Gamelobby]

Server specific..!?

I know you obviously don't know what my folders are named, but i'm asking if anything looks wrong to you as far as folder structure & if it looks writable (see image)

I'm just trying to get it to work, like everyone else.
Thanks