Go Back   vb.org Archive > vBulletin Modifications > Archive > Modification Graveyard
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Automatic Database Back-up Details »»
Automatic Database Back-up
Version: 1.0, by Logikos Logikos is offline
Developer Last Online: Sep 2023 Show Printable Version Email this Page

Category: Administrative and Maintenance Tools - Version: 3.5.4 Rating:
Released: 04-25-2006 Last Update: 04-25-2006 Installs: 140
Additional Files Is in Beta Stage  
No support by the author.

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...
  • 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!

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #92  
Old 05-09-2006, 12:46 AM
Quarterbore Quarterbore is offline
 
Join Date: Mar 2005
Location: Valley Forge PA
Posts: 538
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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...
Reply With Quote
  #93  
Old 05-15-2006, 12:06 PM
cclaerhout's Avatar
cclaerhout cclaerhout is offline
 
Join Date: Aug 2004
Location: Paris (France)
Posts: 448
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Feckie (Roger)
Backing up to an external ftp site

(Offsite To Where The Main Server Is)

And the answer is... ?
Reply With Quote
  #94  
Old 05-15-2006, 02:20 PM
Logikos Logikos is offline
 
Join Date: Jan 2003
Posts: 2,924
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #95  
Old 05-15-2006, 02:59 PM
cclaerhout's Avatar
cclaerhout cclaerhout is offline
 
Join Date: Aug 2004
Location: Paris (France)
Posts: 448
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks for your answer

I hope you will succeed !
Reply With Quote
  #96  
Old 05-15-2006, 05:02 PM
Yorixz Yorixz is offline
 
Join Date: Jun 2005
Location: Netherlands
Posts: 284
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #97  
Old 05-15-2006, 05:03 PM
Logikos Logikos is offline
 
Join Date: Jan 2003
Posts: 2,924
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thats a nice idea! I will look into that as well. Thanks for your vote!
Reply With Quote
  #98  
Old 05-15-2006, 07:51 PM
RemiAlone RemiAlone is offline
 
Join Date: Apr 2006
Location: Holland
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Installed it but my host has exec disabled.
Reply With Quote
  #99  
Old 05-16-2006, 08:31 PM
Tim. Tim. is offline
 
Join Date: May 2006
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #100  
Old 05-26-2006, 07:28 AM
Tralala's Avatar
Tralala Tralala is offline
 
Join Date: Jan 2006
Posts: 1,207
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Yorixz
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

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.
Reply With Quote
  #101  
Old 06-03-2006, 07:09 PM
Angelus Angelus is offline
 
Join Date: Nov 2001
Location: none
Posts: 43
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
i hope for help
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:15 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05029 seconds
  • Memory Usage 2,316KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete