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.

[Paul M]

Not much a can say to that

[Joe2288]

I'm also getting the error

An error occured during the Backup :

My backup path is ././backups/ and it does create folders with the current date when I manually start the process but nothing else.

Any ideas?

[Paul M]

././backups/ should really be ./backups/

You need to check folder permissions.

[Joe2288]

I have folder permission set at 777 and as I mentioned it does create subfolders with the current date so I think the permission is set correctly.

I changed the path to ./backups/ still the same error.

[Joe2288]

Ok, I checked a little further into this problem. It does have something to do with permissions.
Folder /backups/ permission is 0777 owner me
Folder /backups/2009-09-17 permission 0777 owner www-data ... does this matter?

So I went on and edited mysqlbackup.php in order to remove the creation of folder as this is somehow creating the problem for me ....

// Cron Based Automated Backup
function cronBackup()
{
/*
Set Full Dump Path.
*/
//$this->FULL_PATH = $this->DUMP_PATH.$this->DATE.'/'.$this->PREFIX.$this->DATE;
$this->FULL_PATH = $this->DUMP_PATH.'/'.$this->PREFIX.$this->DATE;

/* Short Path */

//$this->SHORT_PATH = $this->DUMP_PATH.$this->DATE;
$this->SHORT_PATH = $this->DUMP_PATH;

/*
Close Forum.
*/
if ($this->SHUTDOWN) { $this->forumStatus(0); }

/*
Remove previous SQL Files.
*/
//$this->removeDir($this->SHORT_PATH);
//$this->createDir($this->SHORT_PATH);

/* Clear Cache */
clearstatcache();
..............
............

I no longer have dated folders, but it is working now.

[Allan]

Originally Posted by VedicJunction

Hi Paul!,, since i cannot wait for the next version of the mod, i tried to patch the mod with this option... .... i thought of uploading my modifications so that other ppl can benefit.. hope you dont mind...

i have added two options :

IF you choose to "COMBINE FILES" Then:-

1. All the backups now goes into a single backup dir.
2. If on Linux... then you also have a option to produce a compressed .gz file.

Installation :

1. install the original mod.
2. replace mysqlbackup.php with the attached one.
3. Uninstall the product.
4. Re-import the product with the attached xml file.

Important info..
1. the relative path do not work for me... i used full path (/home/sdadsf/backup/)
2. Do not use this if you do not want to combine your files..
3. I am not a php programmer .. so use it at your own risk.!!

Thank you, but don't work for me

[ChopSuey]

Tried everything, read all posts, getting an error.

[need2fart]

When I try it, it backs up everything but when it gets to my posts it just stops and says done?

Processing podcastitem (No Data)
Processing poll (218) : Processed 218 Rows in 0.016 seconds
Processing pollvote (8249) : Processed 8249 Rows in 0.327 seconds
Processing post (136557)

Thats all I see and it says done... I don't think it is right tho because it didn't say the time processed.

Can someone help me with this I think it timed out. =(

[ChopSuey]

How did you get it to work? Whats your path for it?

[Paul M]

Originally Posted by need2fart

Thats all I see and it says done... I don't think it is right tho because it didn't say the time processed.

Can someone help me with this I think it timed out. =(

That certainly looks like it failed, and timeout is the most likely reason.