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.

[dorans]

:up:
cca 900MB
Thanx

[Mauro79]

the backup does me fine, but when I put everything in the localhost - attachaments and avatars are not.
may be corrupted?
What configuration of hack me?
thanks

[BirdOPrey5]

Mauro-

It is likely you have attachments and avatars set to be saved in the file system- this mod only backs up the database. You need to worry about coping files separately.

Admin CP -> Attachments -> Attachment Storage Type
and
Admin CP -> Avatars -> User Picture Storage Type

These places will tell you where your attachments and avatars are stored.

[charlesr]

Originally Posted by Mauro79

the backup does me fine, but when I put everything in the localhost - attachaments and avatars are not.
may be corrupted?
What configuration of hack me?
thanks

Assuming you have also put the filesystem into localhost..... Don't panic. When restoring the forum locally you need to specify the local location for the attachments etc. It's a hidden menu.

To get things working:
Update local path in /includes/config.php
Update email options settings in vbulletin admin panel to reference new url (along with all the other settings)
I had my attachments stored in the filesystem and in vbulletin, in a location specified as a crazy full server path which can only be changed by switching to debug mode: $config['Misc']['debug'] = 1; <<by adding that to the 2nd line of the config.php). Then a hidden item in the admin panel's option menu appears for "untouchables" (2nd on the list!) where the path can be changed (remembering to remove the debug mode line afterwards from config.php).

[tonym]

Originally Posted by Paul M

The mod will always instruct the server to gzip the file (if you have the option set). If its not doing it sometimes then thats a server side issue.

Any idea what we should tell our host about this error? I have this mod installed on 2 forums and a test forum.

all stopped working on aug 30th 2012.....my host dont seem to think its them..all files on my side have not changed and even reinstalled the mod...still no gzip.


Host just emailed back and said everything fine on the server

The gzip is installed on the server and working fine. Please have a look:

======================================
root@rs2 [~]# which gzip
/bin/gzip

root@rs2 [~]# gzip -V
gzip 1.3.5
nothing has changed on my end.......time to find a new host I guess

[Mauro79]

I have everything stored in the database.
mm do not quite understand your answers. My English is bad.

http://i.imgur.com/Bmhkf.png
http://i.imgur.com/aFyTO.png
http://i.imgur.com/s5ge5.png

probe twice with two backs.
Thanks for your answers.

[BirdOPrey5]

I see you've made a separate thread- https://vborg.vbsupport.ru/showthrea...66#post2362366

Good idea because the error does not seem to be related to this mod.

[tonym]

Originally Posted by Paul M

Unfortunately, I cannot help you with server issues. The mod will issue the command to gzip them, if the server fails to do this then you need to speak to your host to investigate why. An easy test would be to connect via SSH, navigate to the folder and type gzip <filename>.

on 4.2

I can ssh and gzip the files
but it still dont work from the MOD, gzip in this MOD has worked for 2 months since I installed it. It just stopped working a few days ago....

thanks for any help

I have installed at another host also...same problem

[Superorb]

I have found a script that incorporates a feature that will delete backups that are X days old. Is there a way to incorporate it into this Mod? Maybe in the next release?

http://www.wjunction.com/48-technica...up-script.html

[Trumpetrhapsody]

I just tossed this code in there to keep only the latest 5 backups:

// Delete Old Backups
	function deleteOLD($directory)
	{
		$dirs = array($directory);
		$files = array();
		$files = array_merge($files, scandir($directory, false));
		unset($files[0]);
		unset($files[1]);
		sort($files);

		// Loop over all but the 5 newest files and delete them
		// Only need the array keys (filenames) since we don't care about timestamps now as the array will be in order
		if (count($files) > 5)
		{
			for ($i = 0; $i < (count($files) - 5); $i++)
			{
				// You'll probably want to check the return value of this too
				$file = $this->DUMP_PATH.$files[$i];
				$this->removeFile($file);
				echo "<i>[Deleting Old Backup - $file]</i><br />"; vbflush();
			}
		} else { echo "<i>[No Old Backups to Delete.]</i><br /><br />"; vbflush(); }
		
		
	}

You can call it whenever you want, I put it after the "Repair and Optimize" section, before the "Start Initial Dump" section.