Administrative and Maintenance Tools - Automatic Database Back-up

Vote This mod HOTM Here

Automatic Database Back-up

www.vBHackers.com

Keywords
Automatic, Database, Backup, Cron

What this does
This is a port of Brad's hack that can be found here. This will backup your database using the vBCron system in vBulletin and send the file to a directory that you specified in the vBulletin Options area.


IMPORTANT NOTE TO ALL THAT USE THIS SCRIPT
This script invokes an outside process that runs in the backround on your server to backup and compress your database. It is important to remember that this is not an instant process, do not enter you ftp as soon as the script says it is done and try to download your backup. It will likely be incomplete and your server will probbly still be writting the file to disk.

I ussally give the process an hour or two before I mess with the file, larger databases will take more time of course.

To do list...

• Time to install: 5 minutes
• Queries to run: 0
• File Mods: 0
• Templates to edit: 0
• Templates to add: 0
• New Phrases: 5
• New Plugins: 0

Credits
Thanks to Brad for allowing me to port this.

Install This Product
Show your support and click the install button!

Testing Information
I've been using this for vBHackers.com since I first upgrade. I have all my backups being sent to a directory, outside of the public_html. I've yet to experiance any problems. I have had to use one of the backups before, and all worked well.

Product History
Wednesday, April 26, 2006 - Public Released

Help & Support
Before asking for support, please make sure you have done all the necessary changes! If you still need support, please post a reply here and double check that you have clicked the Install Button. I will try to support this hack the best I can. Support is not guaranteed!

Please post any bugs and errors here. Hope you like it, feedback is always welcomed!

[Logikos]

I backup every 12 hours over-righting the old backup. Then I go to the directory once or twice a week and clean it up manually. Gotta have some work as an admin

[Boofo]

I'm sure I can figure out how to add the setting for it.

[Logikos]

When you do, don't forget to share it with us.

[puertoblack2003]

Originally Posted by nvhlinh

I try to run the script in Sheduled Tasks and it creates a error-file with this error message:

mysqldump: Out of memory (Needed 661284 bytes)
mysqldump: Got error: 2008: MySQL client run out of memory when retrieving data from server

even though i like the hack i can't installed it...i'm assuming you're with dreamhost...i send them an email because i had the same problem and this is there response hopr this can help...

Hello,

Your database is large at 124MB and we divide the server up into multiple
Mysql instances each with a 50MB memory limit. You will not be able to
backup the database on your own because of this. Dont worry though, we
backup the database for you every day.

Thanks!

[Boofo]

Originally Posted by LiveWire

When you do, don't forget to share it with us.

You already had the setting there, editing the php file is all that it should take.

[bashy]

Hi peeps

This dont appear to be working for m8
It says

Automatic Database Back-up

Done

yet the folder is empty, I have manually ran this about 5 tims now pmsl..

The php is in the cron directory....
I do have the correct path to the file, found using the php info

Perhaps i will have about 5 in the dir in the morning lol

Baffled me is

[Boofo]

Originally Posted by bashy

Hi peeps

This dont appear to be working for m8
It says

Automatic Database Back-up

Done

yet the folder is empty, I have manually ran this about 5 tims now pmsl..

The php is in the cron directory....
I do have the correct path to the file, found using the php info

Perhaps i will have about 5 in the dir in the morning lol

Baffled me is

Did you chmod the directory to 777 like it says to?

[shadowdancer36]

Where are the options at that you show in your screen shot? I've looked all over and haven't seen it.

I think this is a great idea. You think you can add a way to send out a message to users online saying system maintence is bout to happen, blah blah blah... and disable the board until the download is complete? Then bring it back up and notify the admin that it is done? Makes me think back to the old days of BBSin when TAG or Teleguard did it's tasks.

[Boofo]

Look in the vBulletin Options under Database Backup Settings.

[Zidane007nl]

Installed it without problems. Great job. That will hopefully protect me more from my forum being hacked...