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.

[Gary_Oak]

Everytime I try to perform the backup through 'Run Now' I get this error message...

Warning: include_once([path]//includes/cronbackup.php) [function.include-once]: failed to open stream: No such file or directory in [path]/admincp/cronadmin.php on line 116

Warning: include_once() [function.include]: Failed opening '[path]//includes/cronbackup.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/admincp/cronadmin.php on line 116
Done

Any ideas how I can fix this? Also, does 'Done' mean that it actually worked, even though it says all that as well, or not? Finally, once I perform the backup, how do I access the backup so I can use it to restore either my main site or a test site?

Thanks in advance!

[Paul M]

That means you are missing one or more of the files used by the mod.

Either you didnt upload them, they failed to upload, or you uploaded them to the wrong place.

[Gary_Oak]

Oh okay. Well I just downloaded FileZilla and uploaded the files to the public_html directory, tried it, and it didn't work. So I tried the public_ftp directory and that didn't work either. Do you know where the files belong? Because my host has not said I need to upload any files to a specific folder or section, and it doesn't say it in the text document when you download the mod, so where exactly should they be uploaded to? I know they are being uploaded because I see them right there, so it is in the wrong place then I would assume.

[Paul M]

When you unzip it, you will see an includes folder, the files (and folders) inside this go into your existing forum includes folder.

[Gary_Oak]

I did that. It still showed me the same error message. I uploaded all contents into the includes folder of my forum, tested it in my ACP, and still got the same error message. It shows it as uploaded, so it should be working, but it isn't.

[Gary_Oak]

Sooooo... what should I do now to get this working?

[Paul M]

Give someone access to your server and ask them to check what you have done.
The error means the file(s) cannot be found, which indicates they are not where they should be. There isnt anymore I can tell you.

[zapiy]

Automatic Database Backup for vBulletin
Backup Error : Could not write to destination file ( ../../backups/2012-01-08/Forum-2012-01-08-Access.sql )

My site is /httpdocs/backups

so i have tried every way

please advise.

folder is 777

[bzcomputers]

The directory path appears incorrect.

It also appears you maybe trying to backup to your root directory, which could lead to a security issue for your backups (easy access in many cases).

What is the directory of your forum itself? www.xxxx.com/forums ?

You should be backing up the database outside of your root directory.

[djbaxter]

I have this running on five vB 4.2.0 PL3 forums now, all with "Set to yes to combine all tables into one backup file = Yes".

Two issues:

1. The filesize changes up and down from day to day with no discernible logic. What would cause this?

2. On the forum with the largest database, the process often fails to complete.