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.

[Hellraider]

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.

Thanks, works fine for me.

[Paul M]

Originally Posted by Reven

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.

If you don't mind I'll think about borrowing this code and adding some extra options at some point (when I'm not so busy).

[92GreenGT]

I found this mod by searching for backup things, im just now learning about how to do them etc etc. So I will ask this before I post a reply saying I get some error message.hehe

$backup['DUMP_PATH']	= '/path/to/backups/';  // Path to backups folder, with trailing slash

I dont understand this, not the way everyone else has been asking questions about though. What I dont understand is, am I supposed to go into my FTP and make a folder called whatever I want for the backups to go into? I made a folder on the root I guess(sorry if my terms are wrong) but I made a folder named Backups. If this is correct how would I word the path for that? The rest I understand but this has me confused. Thanks

[Menime]

When I try to run this I get the following error message:

Database Backup

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

[madkeen]

Thank you
Installed and working fine

[da420]

Originally Posted by Menime

When I try to run this I get the following error message:

Database Backup

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

the location you are saving the file to is not writeable.

[Menime]

Originally Posted by da420

the location you are saving the file to is not writeable.

The folder I have it set to is set at 777.

[Paul M]

You may have other (php) restrictions in place.

[Menime]

Could you be a little more specific about that Paul? I keep thinking I am missing something stupid and I can't figure it out.

[Paul M]

Since I have no idea how your server/hosting is set-up then I can't be specific. My guess would be a php open_basedir restriction.