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!

[creedmaniac]

Originally Posted by LiveWire

@creedmaniac: Thanks for the quick PM! Okay make sure that your File Dump Path setting is set to the following.

I would suggest place this in a folder outsite of the public_html folder for security reason. To do this, log into your website via FTP. This will place you in the /home/inara/ directory. Create a folder and name it whatever you want. I named mine databack.

Once you have finished that. Log into your admincp panel and make your way to the Database Backup Settigs. This is under the vBulletin Options. Make your your File Dump Path settings is set to /home/inara/databack (no ending slash). Then run the cron and give it a good 15 mins to transfer the database to that folder. The time all depends on the size of your database. Let me know if that fixed it.

that's what it's already set to, so nope...still getting a .sql and an error.sql

[Logikos]

@hadog I'm still looking into this issue with mysql5. I'm hoping to update this hack soon and see why mysql5 is causing problems.

@creedmaniac: This should add a file called 05-1-2006.sql and 05-1-2006-error.txt to your /home/inara/databack directory. If you have it set to .tar.gz, then you will only get a 05-1-2006.tar.gz file in the directory. 05-1-2006 is the date of the current backup. At the moment the error files do not process when your using the .tar.gz menthod. This isn't a bug, this is just by design. I'll be updating some settings soon.

Are you at least getting the backups to the directory?

To Everyone
Is there anyone else using this hack with MySQL5? If so, is it working?

[5wayshosting]

Thanks for this hack..

[Logikos]

No problem.

[rmxs]

hi nice hack byt i use it 3 days and my 3 backups its empty...now i change the option to do backup without compresion byt i dont thing thats my problem.
anyone have idea?

Edit:Same thing also without compres.(empty file)also one txt file apeard with this inside..

sh: line 1: mysqldump: command not found

[Logikos]

Thats what the error.txt file is for. It's letting you know that mysqldump: command not found. Means you don't have that feature installed on your server. You would have to ask your host to enable it or install it. (mysqldump)

[rmxs]

LOL i forget this step thanks for responce

[kurtbarker]

Hey LiveWire... When I used to do this manually using the ACP, I was getting database sizes of over 100mb, using the auto system i'm getting database sizes of just over 90mb... is it missing something in the backup?

[rmxs]

No its normal...my db its 80 and im get 73mb backup

[Smiry Kin's]

an option to go to a throw from back up databases would be cool..

no possible way to make this able to go to another FTP address?