Administrative and Maintenance Tools - vB Database Backup (Lite)

As of 24 Nov 2017 this modification has been withdrawn.

Note: I did not write the original version, but rather have modified & adapted it.

When vb 3.5 first came out I was using this backup system on my vb 3.0 - and having nothing better to use - I converted it to work on vb 3.5 (here) and since then I have cut it down and adapted it, first for vb 3.6, 3.7 and now for vb3.8.

The original version was by Trigunflame and the rights to the code were bought by Zoints (David Chapman) in January 2007. Later in 2007 David gave me permission to release my adaptation.

I have stripped out much of the extra stuff that I do not use (or indeed, could not get to work). This is a simple (Lite) version that does a php based dump of your database either as one file, or one file per table.

As of version 3.8.002, most of the options have moved to the ACP in vBulletin Options >> vBulletin Automatic Backup

Notes:
* I will not be adding anything new to this modification.
* This is a Lite version to allow people to use the basic backup functionality on 3.8.


History:

v3.8.001 : First version for vB 3.8.
v3.8.002 : Moved most of options to ACP.
v3.8.003 : Moved more options to ACP.
v3.8.004 : Gzip option backported from vb4 version.
v3.8.005 : Split option backported from vb4 version, close option removed.
v3.8.006 : Fix php 5.3 deprecated warning.

[slowphantom]

thx for the mod
and
i got some problem after i installed the 3.8 and use this

it give database error

Database error in vBulletin 3.8.2:

Invalid SQL:
SHOW CREATE TABLE `template`;

MySQL Error   : MySQL server has gone away
Error Number  : 2006

it happen so much
befor i was useing the 3.7 on 3.7 forum
but i upgread to 3.8.2 and install that mod and i cant take any back up any more
any idea ?
thx

[sargatanas]

how this thing work?, i just installed it but i cant see any menu in my vb admincp [sorry for noob question]

[doctorsyrup]

Originally Posted by sargatanas

how this thing work?, i just installed it but i cant see any menu in my vb admincp [sorry for noob question]

There is no menu for it. Go to the Scheduled Task Manager > Automatic Database Backup and you can run it manually. It is also set to run once daily by default.

[Jheyman]

Quick question I am getting this error when I hit run now on the backup job, I am sure I missed somehting but I cant seem to figure it out any help is appericated

An error occured during the Backup : Could not open Destination SQL file for writing.

[Outbackmark]

Installed and working fine, I created a folder called backup in the same folder as my forum, this differs from one site to the next, it needs to be in the same place as you see the folders for admincp, archive, attachements and so on (The place where you upload all your VB files).

The permissions are set to 755.

Make sure the folder is named the same in the mysqlconfig.php file so mine was called backup and my config looked like this

// File Saving Information
$backup['DATE'] = 'Y-M-d'; // Backup file date format (See http://uk.php.net/date)
$backup['PREFIX'] = 'Forum-'; // Backup file prefix, applied to all files
$backup['DUMP_PATH'] = './backup/'; // Path to backups folder, must have a trailing slash, folder must be writable.

Once set up, upload the config file into the includes folder and it will work, remember the ./ before the file name and the / after, that should be all you need on a linux server, so long as the folder is in the same place as your VB forum files.

All the above error means is the mod can not find or write into the folder because is is not named or placed correctly.

[PayJ]

What is the advantage of using this? Isn't this already in 3.8?

[Yonatan]

Originally Posted by Jheyman

Quick question I am getting this error when I hit run now on the backup job, I am sure I missed somehting but I cant seem to figure it out any help is appericated

An error occured during the Backup : Could not open Destination SQL file for writing.

Safe Mode is turn on in your server and block this function, so you you need to turn off the Safe Mode if it's your own server, or contact to your hosting support.

Originally Posted by PayJ

What is the advantage of using this? Isn't this already in 3.8?

It's is a automatically backup based on Cron Jobs.
It's NOT a manual backup.

[Paul M]

Originally Posted by PayJ

What is the advantage of using this? Isn't this already in 3.8?

No, there is no automatic backup facility in vbulletin.

[Tboy_forum]

Guys, I also battled my arse off trying to get this thing to work!

It does - and eventually found it was my folder path for the backup - IT MUST BE CORRECT or it aint gonna work

Thanks

[bleros]

$backup['DUMP_PATH'] = './backups/'; // Path to backups folder, must have a trailing slash, folder must be writable.

Automatic Database Backup for vBulletin 3.8
An error occured during the Backup : Could not open Destination SQL file for writing.


so must create folder in ftp with name backups or its established realy i need help i must have this becouse i dont have time to backup everyday with maus