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!

[rinkrat]

Works great, and even gets compressed. Sweet!

[Logikos]

Glad you like rinkrat!

[hadog]

Hi
I installed
I get an error file created when run

'mysqldump' is not recognized as an internal or external command,
operable program or batch file.

I am running mysql5 if that is a help

[Feckie (Roger)]

Originally Posted by LiveWire

@briansol I could look into this over the weekend.
@Feckie (Roger) Example? Whats an FTP Backup?

Backing up to an external ftp site

(Offsite To Where The Main Server Is)

[gedsta]

Warning: exec(): Unable to fork [mysqldump --add-drop-table -hlocalhost -uxxxx -pxxxx xxxx_ 2>c:/Inetpub/vhosts/xxxx/httpdocs/forum/xxxx/databack//04-29-2006-error.txt >c:/Inetpub/vhosts/xxxx/httpdocs/forum/xxxx/databack//04-29-2006.sql] in \includes\cron\databack.php on line 21

help please :-)

[Logikos]

@hadog, I'll have to see what to use for mysql5. For the time being, I would disable this product.

@gedsta, it looks like the script was trying to fork too many times. Ask your host to increased the process limit for exec() and give it a shot. Should work after that.

[yinyang]

installed and working flawlessly. thanks!

[BeaLzeBuB]

Originally Posted by BeaLzeBuB

thats is thank you man.
installed

now waiting

it is working great

[creedmaniac]

is this supposed to create a date.sql and a date-error.sql everytime it runs? (i'm hoping it's supposed to be making the error.sql...cuz if it's not something's wrong with mine...it's going to the correct folder though so i don't know what else would be wrong)

[Sleazy]

Hi,

For some reason this hack creates the tar files in my backup folder each day but they are always empty. Any idea of what maybe causing this?

Thanks