The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
Automatic Database Back-up Details »» | |||||||||||||||||||||||||
Automatic Database Back-up 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...
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! Show Your Support
|
Comments |
#92
|
|||
|
|||
Is there any advantage to using this over a traditional server driven CRON job?
For those that can not get this to run on your server because of the settings... if you server allows you to run CRON jobs I have a page that can help you program your own CRON jobs to back up your MySQL databases here: http://adultwebbusiness.com/adultbus...topic.php?t=54 No worry, there is no adult content on there Oh yea, that is one of my sites I have not upgraded to vB yet too... |
#93
|
||||
|
||||
Quote:
And the answer is... ? |
#94
|
|||
|
|||
I'll see what I can do. That is something that I've never done and will need alot of research and testing before I can insert that addon to this hack.
|
#95
|
||||
|
||||
Thanks for your answer
I hope you will succeed ! |
#96
|
|||
|
|||
Wonderful addon, you got my vote in the poll for sure.
I've got one little feature request which I'm sure of that there will be others who'd like it as well; maybe you can add it so you can specify the max. number of backups you want to keep stored. I, and I'm sure I'm not alone, am on a shared hosting so I haven't got "unlimited" space, therefore I'd love to see a feature to simply have 3 backups at all time; when a new one is made the last one could be deleted to make room. Keep up the great work and hopefully you'll add it |
#97
|
|||
|
|||
Thats a nice idea! I will look into that as well. Thanks for your vote!
|
#98
|
|||
|
|||
Installed it but my host has exec disabled.
|
#99
|
|||
|
|||
Installed and running now. When I run it though my site slows to a crawl, a lot of timeouts and such.
How long does it take to make a backup? (1gig sql uncompressed db here) Can I stop it halfway through somehow? EDIT: Also, I only see how to make this run Every X Time. Is there a way to say run at 5am GMT+1 every day, for example? EDIT2: Alright it seems the lag was caused because the script ran 3 SQL Dumps at the same time. Every time the server admin tried to kill one it started over again. Any idea why this happened? The script was set to run once every 23 hours. |
#100
|
||||
|
||||
Quote:
Agreed, great idea. As it stands now I'll probably have to manually clean out the backup folder from time to time. I also think it's a good idea to suggest putting a simple index.html file in File Dump Path... otherwise in the off-chance someone guesses the backup directory name, they'd be able to download all of the forum backups simply by navigating to it in their browser. |
#101
|
|||
|
|||
hi.
the hack ist very well. thanks for this. BUT i have one error message: Code:
Datenbankfehler in vBulletin 3.5.3: Invalid SQL: UPDATE session SET lastactivity = 1149365202, location = '/admincp/cronadmin.php?do=runcron&cronid=15', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0 WHERE sessionhash = '1104b4313e8dc9116022d6011e23ece3'; MySQL-Fehler : Lost connection to MySQL server during query Fehler-Nr. : 2013 Datum : Saturday, June 3rd 2006 @ 10:07:13 PM Skript : http://www.twingo24.de/admincp/cronadmin.php?do=runcron&cronid=15 Referrer : http://www.twingo24.de/admincp/cronadmin.php?do=modify IP-Adresse : xxx Benutzername : Karlheinz Klassenname : vb_database |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|