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.

[your24hourstore]

Originally Posted by MixMakers

I have a fairly large forum and the backup seems to always freeze @:

--- Processed 18300000 Rows

Database is over 2 gigs when it freezes. Any idea as to why this happens?

when was the last time you repair or optmizes the tables in maintenance?

[your24hourstore]

Originally Posted by jeffinj

Peace of mind of after 393 secs of backup execution.
This is a great mod Paul!! Thank you.

this is the most important mod in here i would think, i wish it would gzip it so i didnt have to :>

[pltillman]

I get this error when trying to run the cron job manually.

Backup Error : Could not write to destination file ( ../../backups/2010-06-16/Forum-2010-06-16-Access.sql )

I will admit that I'm new to vbulletin and don't yet fully understand all the intricacies regarding plugins and how they are ran. With that said I did try manually creating a backups directory and chmod 777 to make sure it was writable. I tried placing it in the following directories and each time I got the error.

\
\community - subdomain that vbulletin is installed in
\community\includes

I also wish there were additional options such as emailing the backup file (under a given size of course) or the ability to specify a save location.

Any help is greatly appreciated.

patrick

[Paul M]

E-mailing will never be an option.

You can already specify the save location in the options. The default which the error shows you are using) is ../../backups/

This is a folder called backups, two levels above your forum folder.

e.g.

/var/www/sitename/httpdocs/community = your forum location
/var/www/sitename/backups/ = default backups location

[pltillman]

Thanks Paul. This was literally the first mod I've played with so I just realized I had been going to the Scheduled Task Manager to edit the options, but now I've found the 'real' options under Settings. I updated the save location and it works like a charm. Thanks again!

Oh.. and may I ask why emailing will 'never' be an option?

Thanks
patrick

[Paul M]

E-mailing copies of your database is a huge security risk. Most databases will also be far larger than any e-mail system can handle.

[xenxo blanco]

I had an error when trying to do a backup..

Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/vhosts/spmi.com/httpdocs/includes/mysqlbackup.php on line 402

[Paul M]

You need to speak to your host about that, they are limiting the run time in php.

[Speedy1505]

A corresponding entry is on the moderator options vorhanden.Ist it possible to extend this hack to a TAR compression?

In places the backups are still very large.

many thanks

[Paul M]

Gziping the files will be an option in the next release, im testing it atm.