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.

[Jase2]

Hi Paul,

A few questions. Currently, I have one .sql per table. How would I change this? Also, what would you recommend: One file named the same each time so that it is overwritten, or one .sql per table. Personally, I think if you should ever need to restore a backup, then one .sql per table is possibly better, since you may only need to restore a certain table, ect.

Oh, as mine currently is, one .sql per table, I usually delete one or two backups after a few days and save usually three, but when I delete them, I ALWAYS optimize the tables afterwards. Is this needed or not?

[Paul M]

You change it in the config file.

I have one file per table, you can always join them together later if needed.

You rarely need to optimize tables.

[Jase2]

Ok, thanks for your reply Paul, much appreciated.

[malomairy]

just installed it and it worked fine by pressing run now, i have the following questions:

1- Cron didn't start as scheduled, i put day of week to * and day of month to * and hour to 4AM, so this should backup the DB everyday at 4AM, one day passed with no backup. is there anything else i have to do?

2- which is better backup up DB on one file, or have it Table by Table?

3- I've never done restore so far, so how and what is the fastest way to restore DB?

Thanks Paul for this great Mod.

[tazzarkin]

Thanks for posting this thread. It's always good to have more than one option.

----------------

Originally Posted by Jase2

Might as well just set up a cron job.

https://vborg.vbsupport.ru/showthread.php?t=169550

Regards Jason

[tazzarkin]

Originally Posted by seangworld

so is this in lieu of using the backup in the acp?

if i use this, will be easier to use the file from this script to upload to lets say a new db and new installation of my site? cuz i know the one in the acp that comes with the forum sucks and i could never get it to actually work, always having to start from scratch.

--------------------------

No one ever answered seangworld, and I pretty much have the same question.

How is this better than the backup in the acp?

[XFSImperial]

I've installed this mod on a forum of mine, it has worked well so I decided to install it on another. I'm getting this error though:

Parse error: syntax error, unexpected T_STRING in D:\Websites\xboxnation\forums\includes\mysqlbackup config.php on line 24

Running IIS on Windows 2003, any suggestions?

[Paul M]

Correct the error you have made editing the file.

[War_force]

Automatic Database Backup for vBulletin 3.7
An error occured during the Backup : Could not open Destination SQL file for writing.

what can I do?

[Pavlus]

I have a little problem here.

Sometimes when i use option - close board due to backup, board will not automaticaly open after process.

Today i just disabled it because morning backup failed. My database is very small about 23mb, when i making backup - manualy using this product - process stops at one of the tables polls f.e and its stucked....

Any ideas? From today everything was ok.