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]

You Lost connection to MySQL server during the cron. This could have been a number of things and not just this hack. Try running the script again. If the problem still continues then let me know. You might have to ask you host why this is happening. BTW, how big is your forum?

[FreshFroot]

The weird part I had, was when I ran the task, I checked my folder. It has 2 files, 06-7-2006-error.txt and has a 06-7-2006-.sql......

What's that mean? My database wasn't backed up properly?

[Logikos]

The 06-7-2006-.sql should be your database file. The error text is there to tell you if any errors occoured while backing up the system. How big is your 06-7-2006-.sql file?

[FreshFroot]

I believe it is 25MB... which seems too small I think? The sql file says 0kb, so I wouldn't be able to figure out the error?

[AndyP]

Installed and got it working (after taking a while to figure out the settings I needed).
Great mod. Just what we needed.

[Replicators]

My host automatically does this, but i think this is even better as i can have my other admins do a restore without having to go in the ops. Great mod for people who don't have hosts that do this automatically!

[Boofo]

Mine did too and when the HD crashed and I lost the site, guess which drive the backup they do was on. :cross-eyed:

[briansol]

something seems odd in my backup from last night. Out of no where it jumps extensively.

I store attachments in the file system, so thats not the cause. I KNOW I didn't have 80mb worth of members and posts yesterday.

Anyone see anything like this before? I have no error logs or anything...

:banana:

[melefire]

Thanx works great