Administrative and Maintenance Tools - vB Database Backup (Lite)

As of 24 Nov 2017 this modification has been withdrawn.

Note: I did not write the original version, but rather have modified & adapted it.

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, 3.7 and now for vb3.8.

The original version was by Trigunflame and the rights to the code were bought by Zoints (David Chapman) in January 2007. Later 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.

As of version 3.8.002, most of the options have moved to the ACP in vBulletin Options >> vBulletin Automatic Backup

Notes:
* I will not be adding anything new to this modification.
* This is a Lite version to allow people to use the basic backup functionality on 3.8.


History:

v3.8.001 : First version for vB 3.8.
v3.8.002 : Moved most of options to ACP.
v3.8.003 : Moved more options to ACP.
v3.8.004 : Gzip option backported from vb4 version.
v3.8.005 : Split option backported from vb4 version, close option removed.
v3.8.006 : Fix php 5.3 deprecated warning.

[grecostimpy]

Originally Posted by Paul M

There is no limit built into this, so as long as your php does not timeout there is no reason you can t use it with a 2GB database.

Thank you for that answer. Is it safe on a database this large to keep the forums open while this runs? Mind you it is a very busy website 24/7. Thanks again for your assistance.

[jl255]

tks for this mod!

been running this for a few weeks now, and i realize that the backed up db is 2gb while the db size indicated in cpanel is close to 4gb. Does that seem right?

[Paul M]

Originally Posted by grecostimpy

Thank you for that answer. Is it safe on a database this large to keep the forums open while this runs? Mind you it is a very busy website 24/7. Thanks again for your assistance.

It wouldbe better to close it if you can, but I would not advise using the option in this mod as it can sometimes fail to open it again.

Originally Posted by jl255

tks for this mod!

been running this for a few weeks now, and i realize that the backed up db is 2gb while the db size indicated in cpanel is close to 4gb. Does that seem right?

Sorry, I cannot comment on database sizes.

[wipedout]

i have serious conserns and serious problems i require serious help!

i do realise that your exact words were: "* I will not be adding anything new to this modification. " but i beg you reconsider to add gziping of the sql files after the backup is done it would shorten down the overall backup sizes with about 75% which if someone like me who wants 4 backups a day would help alot making my backups go from 120mb per day and rather down to 45mb a day.

~Wipedout
TFD Administrator

[Paul M]

My backups are way bigger than that, why is it a serious problem ?

[hydn]

Originally Posted by wipedout

i have serious concerns and serious problems i require serious help!

Good luck with getting help. Maybe now you will. Lets hope its not an "individual server configuration" you have but that some how you have a clone setup because all servers must be the same it seems.

[chingon]

Thank you very much Paul M, your work is greatly appreciated.

[hearts]

Update - I had to add 'httpdocs'

/httpdocs/backups/

it works now.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Edited: I found answers to my post. Now I get an error:
"An error ocured during the Backup : Could not open Destination SQL file for writing. "
I read another post above that said they got this message and changed to not run in safe mode.
How do I turn off Safe Mode?
/backups/ is 0777

Thanks.
Beth

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Installation instructions below. I have done #1,2,3.

How do I do #4? Where do I go to do that?
How do I start the backup? (I did create a /backups/ directory)

Thanks,

Beth
~~~~~~~~~~~~~~~~~~

Installation.

1. Copy all files in the 'includes' folder to the server.

2. Set your choice of options in the mysqlbackupconfig.php file.

3. Upload the product XML via the Product Manager.

4. Alter the timing of the cron job to suit.

[wipedout]

Originally Posted by Paul M

My backups are way bigger than that, why is it a serious problem ?

its not a serious problem, but reducing sizes of backup would be nice.

[WildFire.ca]

Thank you sir, nice little mod.
I am having a little problem running the mod. Its giving me this error when I try to run the process. An error occurred during the Backup : Could not open Destination SQL file for writing.