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.

[karel1985]

Hi Paul,

i found what the problem was

my server was running in Safe Mode,
i've mailed my Hosting company and they putted it off,

now it works like a charm :-)

thanks for the support !

karel

[Pure Dope]

Hm.....well the forum doesnt come back on. Same prob that other guy is having. I have yet to attempt to imiport the database to see if I get any errors, but it looks as if it got backed up ok. I see the whole big 2GB file right there.

Ill let you know what I find, if I find anything. Im not real good at this linux stuff.

[Pure Dope]

Hm....yeah Im not understanding why it doesnt turn the forum back on. I let it go with the option to not turn off forum and to lock tables. My site comes unavailable for about 30 minutes......but.....the backup seems to go fine...and the site comes back up fine too.

:shrugs:

[Paul M]

If you lock the tables then the site will be unavailable as vb will be unable to perform any database updates.

[Deimos]

Love this hack, works very well
Just a question, has anyone managed to add FTP functionality to it?
I have a remote storage space account, which I use for offsite file backups, so having the database ftp'd to another server, would be awesome

[santimariani]

I am getting the following error now:

Warning: is_file() [function.is-file]: Stat failed for /home/username/backups/06-09-2007 (errno=13 - Permission denied) in /includes/mysqlbackup.php on line 225

Warning: is_dir() [function.is-dir]: Stat failed for /home/username/backups/06-09-2007 (errno=13 - Permission denied) in /includes/mysqlbackup.php on line 260

Warning: is_dir() [function.is-dir]: Stat failed for /home/username/backups/06-09-2007 (errno=13 - Permission denied) in /includes/mysqlbackup.php on line 271
An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)

I have not seen these errors anywhere in this thread (except for the "error occured during.." one). Any thoughts? Thanks in advance.

[djbaxter]

My first guess would be the directory is write-protected, i.e., you have to set the permissions to 777 or 666.

[Frozen Tears]

Am.....

MAZING!

[santimariani]

Originally Posted by djbaxter

My first guess would be the directory is write-protected, i.e., you have to set the permissions to 777 or 666.

After months of trying, it finally works! Yes! Thank you!

Ah, how amazing it is to finally have a good host.

[Deimos]

I got a php friend of mine to modify this to send the backups to a remote server
Would it be ok to post the modifications here?