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.

[RichieBoy67]

Originally Posted by doctorsexy

BigDump: Staggered MySQL Dump Importer

http://www.ozerov.de/bigdump/

Bigdump is for databases.. He wants something that will back up his entire server on its own, files and database..Bigdump does not do that.

[Powerlynx]

I need something that will mirror my site "completely" everything in it's place, like literally a sister site being an exact duplicate running in parallel to the original site where I can have the sister site doing daily backups on a server and right to my own computer.

[RichieBoy67]

I believe their managed back up will do that..

[charlesr]

Use this mod to create the database dump during the quiet hours and then use something else to backup the files and dump. GoDaddy might do server snapshotting for you if you throw money at them.

[RichieBoy67]

Originally Posted by charlesr

Use this mod to create the database dump during the quiet hours and then use something else to backup the files and dump. GoDaddy might do server snapshotting for you if you throw money at them.

Well yeah.. What would the something else be?
I think he wants something he doesn't have to worry about. I would look into the godaddy managed back up option myself even if it costs a few bucks.

[charlesr]

I use WinSCP but it's manual so I only bother once a week. There must be an automated solution for rsync in windows though (assuming you leave your machine on). The cheapest offsite solution would be amazon's cloud service, but learning to use it is a pain.

[RichieBoy67]

I love this mod but would love to see a feature for limiting the amount of back ups made. I use this on many client sites in addition to my own and sometimes I forget about it and a couple months later their entire server is filled. lol

I would like to limit it to 2 or 3 back ups stored if possible.

[RichieBoy67]

Originally Posted by charlesr

I use WinSCP but it's manual so I only bother once a week. There must be an automated solution for rsync in windows though (assuming you leave your machine on). The cheapest offsite solution would be amazon's cloud service, but learning to use it is a pain.

In addition to using this mod for databases on certain back ups I also have my Plesk dedicated server run nightly back ups directly to ftp storage my host offers that is on another drive location. I do not have to touch this at all ever and I think this is what the op wants.

I do try to download a back up to my pc as well every couple weeks but my internet service provider(Cox) starts sending out threat letters when I use to much bandwith.

[bzcomputers]

Originally Posted by RichieBoy67

I love this mod but would love to see a feature for limiting the amount of back ups made. I use this on many client sites in addition to my own and sometimes I forget about it and a couple months later their entire server is filled. lol

I would like to limit it to 2 or 3 back ups stored if possible.

I limit it to just 7 backups by changing the "Date Format" in the settings. If you just use "D" (which stands for day of the week) as the date format then you will only get 7 backups before they start to overwrite themselves.

yourprefixMon-Full-Backup.sql.gz
yourprefixTue-Full-Backup.sql.gz
yourprefixWed-Full-Backup.sql.gz
yourprefixThu-Full-Backup.sql.gz
yourprefixFri-Full-Backup.sql.gz
yourprefixSat-Full-Backup.sql.gz
yourprefixSun-Full-Backup.sql.gz

Then after 7 days they will just overwrite each other. You no longer need to delete old backups which as you mentioned, everyone forgets to before they get an alert about disk space. Extremely useful if you're running multiple sites too!

I figure if I don't know within a week that I need a backup for a site then I really don't need the backup.

...My server runs nightly backups too, but you can never be too safe.

[RichieBoy67]

Originally Posted by bzcomputers

I limit it to just 7 backups by changing the "Date Format" in the settings. If you just use "D" (which stands for day of the week) as the date format then you will only get 7 backups before they start to overwrite themselves.

yourprefixMon-Full-Backup.sql.gz
yourprefixTue-Full-Backup.sql.gz
yourprefixWed-Full-Backup.sql.gz
yourprefixThu-Full-Backup.sql.gz
yourprefixFri-Full-Backup.sql.gz
yourprefixSat-Full-Backup.sql.gz
yourprefixSun-Full-Backup.sql.gz

Then after 7 days they will just overwrite each other. You no longer need to delete old backups which as you mentioned, everyone forgets to before they get an alert about disk space. Extremely useful if you're running multiple sites too!

I figure if I don't know within a week that I need a backup for a site then I really don't need the backup.

...My server runs nightly backups too, but you can never be too safe.

I never thought of that! Great idea!