Administrative and Maintenance Tools - vB Database Backup Pro (Lite) for vb 3.6

This modification is no longer available or supported.

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 for vb 3.6.

The original version was by Trigunflame and the rights to the code were bought by Zoints (D.Chapman) in January. A while ago David gave me permission to release my adaption, but until now I haven't got round to it. Trigunflame did mention a few months ago he was working on a new version, but nothing ever appeared.

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. It's been in use on our forum since the day 3.6 was installed.

Notes:
* I will not add anything new to this, or spend vast amounts of time supporting it.
* This is a Lite version to allow people to use the basic 3.0 backup functionality on 3.6.


History:

v2.10 : First internal version.
v2.11 : Bug fixes, some code changes.
v2.12 : Initial Public Release.

[David Gillaspey]

The config file has a setting for closing the forum (or not). Is it, in fact, necessary to close the forum during the automated backup?

Thanks.

Sincerely,

David Gillaspey

[Paul M]

If you run your backups in a quite period then no, it's not. I don't use that option.

[David Gillaspey]

OK. Thanks, Paul.

Sincerely,

David Gillaspey

[Joey805]

How does this handle the old backup files? Will it delete backups, say after a week old automatically? Or do they just keep getting placed in the backup folder and you have to go manually delete them so you don't eventually run out of disk space?

[Paul M]

You must manually delete them.

[BigJohnny]

Originally Posted by Paul M

You must manually delete them.

aww crap.... that was the best feature of the old version.......

oh well.... i like the way this backs up better though

[Reven]

I've added a bit of code into mysqlbackup.php to compress the resultant SQL file with gzip. My database is about 35MB, and it's making it 5MB.

If you want to do the same, here is what to do. Please note, though, that this will only work if you have chosen to combine all data into one SQL file and not split each table into its own file.

File: ./includes/mysqlbackup.php

FIND (lines 525 to 527):

PHP Code:

                // Free Memory
                $this->MYSQL->free_result($rows);
            } 


ADD BELOW:

PHP Code:

            // Compress file
            if(extension_loaded('zlib') && $this->COMBINE)
            {
                echo "Creating gzip file from SQL file<br />"; vbflush();

                $file = fopen($this->FILE, 'r');
                $data = fread($file, filesize($this->FILE));
                fclose($file);

                $file = gzopen($this->FILE, 'w9');
                gzwrite($file, $data);
                gzclose($file);

                rename($this->FILE, $this->FILE . '.gz');
            } 


You must also have the zlib extension compiled into PHP. Most shared hosts will have zlib installed as well as most PHP installations in general. The script will not attempt to compress the file unless zlib is installed. You can find out if you have zlib by entering the Admin CP and going to Maintenance > View PHP Info and looking in the Configuration Command section for '--with-zlib'.

[Spun2U]

Very nice!!

Thanks Paul!

[zetetic]

Originally Posted by Reven

I've added a bit of code into mysqlbackup.php to compress the resultant SQL file with gzip.

Thanks!

[TheFrienzNet]

Originally Posted by Reven

I've added a bit of code into mysqlbackup.php to compress the resultant SQL file with gzip. My database is about 35MB, and it's making it 5MB.

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 172643155 bytes) in /usr/local/psa/home/vhosts/frienz-network.com/httpdocs/includes/mysqlbackup.php on line 534

Hmph.. I guess the memory exhausted?