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.

[Robbey]

Originally Posted by Paul M

Fix the error in your config file is what you do.

Whatever you edited (on line 14 I would guess) has a mistake in it that you need to correct.

I didnt edit anything in that file though.

[Paul M]

Then your file is corrupted. There is no such error in the proper copy.

[Robbey]

Originally Posted by Paul M

Then your file is corrupted. There is no such error in the proper copy.

I was using notepad, I used wordpad and it made it better, kept on having whacky characters for spaces.

Thanks. Great hack. Worked with no errors.

[sparky5693]

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.

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'.

If I start using this, and merge all sql data into the one file as mentioned, do I need to make any other changes to be able to use the backup this will create?

[92GreenGT]

I had this working before, but now that we switched servers I can't figure it out to save my life.

Here is what I have as my path in the backupconfig file:
'/var/www/vhosts/mysite.com/httpdocs/back-up/'

Is this not right for a path? The folder is CHMOD to 777, so techically it should work correct?
I still get the error when I go to "Run Now" on the scheduled task manager. On the main page of the admin panel it says "Server Type - Linux Safe Mode". Does this have any reason as to why I can't get it to work? Thanks!

-Edit-
Where it says mysite.com, I actually have my forum url. I didn't want someone to mention that as a problem, lol.

[Paul M]

Based on that, "../back-up/" should work.

[92GreenGT]

Still doesn't work:

Database Backup

An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)

Whats weird, is it seems to make a folder for the backup inside the correct folder, but there is never anything in the folder? If it's creating a folder inside the correct folder, wouldn't that be the correct path? I can't understand why it would make a folder with the date but be empty? Thanks!

[Paul M]

Sorry but i cant help you with server permissions, talk to your host.

[92GreenGT]

Originally Posted by Paul M

Sorry but i cant help you with server permissions, talk to your host.

So thats why its making the folder but not putting anything in it becuase its not allowing it to write?

[Paul M]

Originally Posted by 92GreenGT

So thats why its making the folder but not putting anything in it becuase its not allowing it to write?

Correct, your server is not allowing the write operation.