vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=231481

vBulletin Cron Based Database Backup
by Paul M
28 Dec 2009 20:11

2 Attachment(s)
As of 23 Nov 2017 this modification has been withdrawn.

This is a cut down version based on a backup system written by Trigunflame for vb 3.0. It is a simple vBulletin cron trigged php system that does a dump of your database - either as one complete file, or as one file per table. Especially useful now that IB removed the old ACP backup option in vBulletin 4. Files can be (G)Zipped to save space.

All the options are located in the ACP in vBulletin Options >> vBulletin Automatic Backup

To install, download and unzip the files, and follow the instructions in the text file.


History:

v4.0.1 : 28-Dec-2009 : Initial release for vb 4.0.0 Gold.
v4.0.2 : 29-Dec-2009 : Added ability to block process larger tables.
v4.0.3 : 27-Jun-2010 : Added Gzip option.

v4.1.0 : 04-Dec-2010 : Updated for vBulletin 4.1.0.

v4.1.7.0 : 16-Oct-2011 : Updated for vBulletin 4.1.7.

v4.2.0.0 : 24-May-2012 : Updated for vBulletin 4.2.0.
v4.2.0.1 : 17-Mar-2013 : Removed vboptions from backup call..
v4.2.0.2 : 25-Nov-2013 : Fix php 5.3 deprecated warnings, added mysqldump backup.


utahraves 28 Dec 2009 21:01

Woot woot. Why did they take it out in the first place? duh... i used it all the time.

Floris 28 Dec 2009 21:09

I care for my site, so I do not trust apache/php/mysql limits from the browser. And use a shell to back it up. This way apache can be down, but I can still make a database. And after 15mb for example on most hosts I still get a complete sql dump.

But strange that they removed it. I guess they didn't add any value to backing up database or something. Good to see a vBulletin.org administrator show he cares about sites too and adding this as a plugin to version 4.

dodgeboard.com 28 Dec 2009 21:28

Thanks Paul, for your work on this.

Q: How does this deal with PHP script timeouts? Will it work with a 200 mb database for example?

I know that MSD will use refreshes and resume routines to get around script timeouts for large databases...will this do the same?

TIA

Alecsmith 28 Dec 2009 21:34

Installed very good wwork paul :)

Paul M 28 Dec 2009 21:49

Quote:

Originally Posted by dodgeboard.com (Post 1940759)
Q: How does this deal with PHP script timeouts? Will it work with a 200 mb database for example?

It sets the timeout to 1 hour (unless your php setup disallows this).

My database it well over 1GB, and i use this daily (it takes < 5 minutes to run the backup).

Adem GENĒ 28 Dec 2009 21:54

Thank you very much
Installed

BlackJacket 28 Dec 2009 22:10

This was the last mod i have been waiting for. Thank you very much Paul. Your work is much appreciated.

dodgeboard.com 28 Dec 2009 22:18

Quote:

Originally Posted by Paul M (Post 1940774)
It sets the timeout to 1 hour (unless your php setup disallows this).

My database it well over 1GB, and i use this daily (it takes < 5 minutes to run the backup).


AWESOME! Great Work Paul. Always love your mods! <clicks install>

Adem GENĒ 28 Dec 2009 22:30

My bad English

Installed forum
AND
I wanted to make a backup manually
Can not write file error has
AND
Forum no files within the directory was deleted or I do not see all did not stay

Error occurred: 403 - no permission

dodgeboard.com 29 Dec 2009 05:56

Things looked like they were going fine until....

Processing poll (72) : Processed 72 Rows in 0.006 seconds
Processing pollvote (2284) : Processed 2284 Rows in 0.176 seconds
Processing post (127205) : Processed 127205 Rows in 18.943 seconds
Processing postedithistory (2571) : Processed 2571 Rows in 0.629 seconds
Processing posthash (7) : Processed 7 Rows in 0.015 seconds
Processing postindex (2778108)

No errors...just froze.

After about an hour on postindex, I gave up. Apparantly, this doesn't work so well on Hostgator shared hosting.

It was worth a try. Thanks anyway Paul. I use many other mods you've created.

UNinstalling.

JHUMON 29 Dec 2009 06:34

Thanks a lot.

Bouncer222 29 Dec 2009 07:27

So how do you set the time interval for it to create a backup? And does it create only mysql or public_html (my forums directory) backups or both of them in the backups folder?

I would like to make it per week. How I do that?

M3xital 29 Dec 2009 08:45

Thanks! Works great.

KEKforce 29 Dec 2009 11:10

Quote:

Originally Posted by dodgeboard.com (Post 1941179)
Things looked like they were going fine until....

Processing poll (72) : Processed 72 Rows in 0.006 seconds
Processing pollvote (2284) : Processed 2284 Rows in 0.176 seconds
Processing post (127205) : Processed 127205 Rows in 18.943 seconds
Processing postedithistory (2571) : Processed 2571 Rows in 0.629 seconds
Processing posthash (7) : Processed 7 Rows in 0.015 seconds
Processing postindex (2778108)

No errors...just froze.

After about an hour on postindex, I gave up. Apparantly, this doesn't work so well on Hostgator shared hosting.

It was worth a try. Thanks anyway Paul. I use many other mods you've created.

UNinstalling.

Got the same problem.....


All times are GMT. The time now is 02:00.

Powered by vBulletin® Version 3.8.14
Copyright © 2020, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.