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]

../../ will take you a couple of levels up the folder tree - on most steups, that will be outside of the sites html folder completely (which is where backups should be).

[Delfi_r]

Last week we had a problem, something was deleted. After installing the last backup on a test server we extracted a copy of the deleted content and all went fine. One of the most useful plugins I have installed.

[RedTurtle]

Originally Posted by betterthanyours

I do have shell access to both servers. Is there a tutorial on this anywhere?

I use a cronjob on my destination server to login to my site server daily and sync up the backup folder.

Here's the command on the destination server:

rsync -vrltuzDP --rsh='ssh -p2222' admin@mydomain.com:~/backup/ /volume1/Backups/Database/

One thing you do have to do is set up a SSH authentication (I forget the exact term for this) but what it will let you do is login from your destination server into your site server without a password and still encrypt the data transfer.

[kemana]

Hey Paul This mod is really Great,,

i already mark installed

But there's one thing that really confuse me,,
i already set my timing at "Scheduled Task Manager" but it's not working.
but when i used "Run Now" it's worked.
i'm using Vbulletin Version 4.1.3

thx before

[Superorb]

Originally Posted by kemana

Hey Paul This mod is really Great,,

i already mark installed

But there's one thing that really confuse me,,
i already set my timing at "Scheduled Task Manager" but it's not working.
but when i used "Run Now" it's worked.
i'm using Vbulletin Version 4.1.3

thx before

Your site needs to be busy enough to run the cron jobs.

[kemana]

Originally Posted by Superorb

Your site needs to be busy enough to run the cron jobs.

Thx for the respond Superorb
But could u be more spesific,,i still don't understand,,

Thx A lot

[Superorb]

Originally Posted by kemana

Thx for the respond Superorb
But could u be more spesific,,i still don't understand,,

Thx A lot

Scheduled tasks are called to run when the footer is loaded in a browser. If no one visits the site the footer is never loaded, hence the scheduled tasks are never run. There needs to be activity on the site to run the cron tasks. You can just browse your site for a minute or so and everything should start to catch up.

[kemana]

Originally Posted by Superorb

Scheduled tasks are called to run when the footer is loaded in a browser. If no one visits the site the footer is never loaded, hence the scheduled tasks are never run. There needs to be activity on the site to run the cron tasks. You can just browse your site for a minute or so and everything should start to catch up.

awesome ,, i already try that nad it was working Thx Superorb

[JMEWLS`]

Originally Posted by Paul M

Change your script timeout settings (assuming you can).

How exactly would I do this? Sorry to be a pain.

[mattballew]

Can anyone help with an issue... I get this error:

Backup Error : Could not write to destination file ( /backups/Forum-11-01-2012-Full-Backup.sql )

I have set the folder /backups/ to permission 7777 but still the same error. What have i done wrong?