Administrative and Maintenance Tools - vB Database Backup

This modification is no longer available or supported.

Note: Because I did not write the original version, but rather have modified & adapted it, support of this modification may be limited

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, first for vb 3.6 and now for vb3.7.

The original version was by Trigunflame and the rights to the code were bought by Zoints (D.Chapman) in January. In 2007 David gave me permission to release my adaptation.

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.

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 backup functionality on 3.7.


History:

v3.7.001 : First version for vB 3.7.

[sexyeyes83]

Thank you, works great

[1quick1]

Installed. Works like a charm just like the 3.6.xx version.

[karel1985]

Hi Paul,

i recently updated my board to 3.7 (2 weeks ago), before i had the 3.6 version installed.
Now the last 2 days, my board doens't come online anymore after the backup.

Should i upgrade to this version (are there changes with the 3.6v?) or what would be the problem?

I haven't change a thing....

[Paul M]

Turn off the board close option.

[yaoren]

Works awesome! Thanks for this!

[Jase2]

Hi Paul,

Is this meant to close your forums? Reason I ask, is because when I tested it out before, it didn't close my forums. I clicked "Run Now".

Do I just set this too 1? :

Close Forum during Backup
  $backup['SHUTDOWN'] = 0;

Can any problems arise from having your forum stay open, or is it best to close them?

Also, how do we get it to save as one .sql file, and not a .sql file for each table?

[Paul M]

Yes, you would set that to 1. I dont close my forums.

As i recall, for one file you would set the combine option to 1.

[Jase2]

I see. Thanks, Paul!

[peterska2]

I've installed this and while it's running quite happily on some of my sites, it isn't working on others.

It appears that it dies and skips the rest of the table after 1.9GB even if the tables are backed up individually. With a 10GB post table on one site and a 2.5GB post table on another this isn't therefore giving the expected results.

Is there a way to get it to handle large tables correctly, or do I need to give up on it as a bad job on these particular sites? The whole reason I installed it is to save me having to log into SSH every day to take backups, but it is looking like it isn't going to stop my need for that at the moment.

[Paul M]

As I recall, this has a 1 hour script timeout so maybe you are exceeding that. Try upping it to 2 hours. There are no size restrictions in this other than ones the OS you are running may apply.