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.

[Paul M]

Once you are connected to mysql in SSH ;

use mydatabase

then

source Live-2007-07-08-full-backup.sql

[Mecho]

Paul i couldnt find how can i make database as a just one file . i read config file but i couldnt find it . would u plz tell me what exactly i have to do for make backup just one file ??

thanks

[McCarroll21]

Originally Posted by Mecho

Paul i couldnt find how can i make database as a just one file . i read config file but i couldnt find it . would u plz tell me what exactly i have to do for make backup just one file ??

thanks

In the mysqlbackupconfig.php file, change this:

PHP Code:

$backup['COMBINE'] = 0; 


to this:

PHP Code:

$backup['COMBINE'] = 1; 


[Paul M]

Originally Posted by Mecho

Paul i couldnt find how can i make database as a just one file . i read config file but i couldnt find it . would u plz tell me what exactly i have to do for make backup just one file ??

You read the whole config file ?

The comment for the setting seems obvious to me - please can you explain why it isn't - because you're not the first person to ask, and I really don't understand why.

// Combine Tables into one file
$backup['COMBINE'] = 0;

[Mecho]

yea u right . maybe the reason was my bad English or ..

thanks anyway for ur help

[BadgerDog]

Anyone?

I've been backing up religiously using this mod, then manually deleting any backups that were older than 7 days. I've been using "Combine=0" and ending up with many many files.

What would be the advantage (if any) to going to a single file backup with "Combine=1"?

Second, is there a web site, or anywhere I can go to learn how I would restore my database, in either form?

Thanks

Regards,
Badger

[Paul M]

The advantage of single files is you can restore a single table if required. The disadvantage is you need to join them if you want to restore everything in one go. It's personal choice.

[Distance]

You should add how to combine the files in your first post Paul

Distance

[Paul M]

Originally Posted by Distance

You should add how to combine the files in your first post Paul

That's entirely dependant on your OS - and I draw the line at teaching people how to use their Operating System.

[Zidane007nl]

Thanks for releasing this mod. It works like a charm.