Go Back   vb.org Archive > vBulletin Modifications > Archive > Modification Graveyard
Reload this Page Administrative and Maintenance Tools - vBulletin Cron Based Database Backup
FAQ Community Calendar Today's Posts Search

Reply
Page 28 of 107 « First 182627 28 29303878 Last »
 
Thread Tools
vBulletin Cron Based Database Backup Details »»
vBulletin Cron Based Database Backup
Version: 4.2.0.2, by Paul M Paul M is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page
Category: Administrative and Maintenance Tools - Version: 4.2.x Rating:
Released: 12-27-2009 Last Update: 11-25-2013 Installs: 1434
Uses Plugins
Additional Files Translations  
No support by the author.

As of 23 Nov 2017 this modification has been withdrawn.

This is a cut down version based on a backup system written by Trigunflame for vb 3.0. It is a simple vBulletin cron trigged php system that does a dump of your database - either as one complete file, or as one file per table. Especially useful now that IB removed the old ACP backup option in vBulletin 4. Files can be (G)Zipped to save space.

All the options are located in the ACP in vBulletin Options >> vBulletin Automatic Backup

To install, download and unzip the files, and follow the instructions in the text file.


History:

v4.0.1 : 28-Dec-2009 : Initial release for vb 4.0.0 Gold.
v4.0.2 : 29-Dec-2009 : Added ability to block process larger tables.
v4.0.3 : 27-Jun-2010 : Added Gzip option.

v4.1.0 : 04-Dec-2010 : Updated for vBulletin 4.1.0.

v4.1.7.0 : 16-Oct-2011 : Updated for vBulletin 4.1.7.

v4.2.0.0 : 24-May-2012 : Updated for vBulletin 4.2.0.
v4.2.0.1 : 17-Mar-2013 : Removed vboptions from backup call..
v4.2.0.2 : 25-Nov-2013 : Fix php 5.3 deprecated warnings, added mysqldump backup.

Show Your Support

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

Comments
  #272  
Old 08-17-2010, 09:24 AM
FASEOFMARS FASEOFMARS is offline
 
Join Date: Mar 2010
Posts: 105
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
it says all the options are in vbulletin options > vbulletin automatic backup...

but i see no option to backup the database! just the backup path ect..

how do i initiate the backup?
Reply With Quote
  #273  
Old 08-17-2010, 09:53 AM
ProFifaLeagues's Avatar
ProFifaLeagues ProFifaLeagues is offline
 
Join Date: Aug 2009
Location: Uk
Posts: 1,191
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Its done each day by a cron job mate
Reply With Quote
  #274  
Old 08-17-2010, 10:14 AM
FASEOFMARS FASEOFMARS is offline
 
Join Date: Mar 2010
Posts: 105
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
k ill see how it goes then.. thanks...
Reply With Quote
  #275  
Old 08-17-2010, 10:23 AM
FASEOFMARS FASEOFMARS is offline
 
Join Date: Mar 2010
Posts: 105
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
im hearing mentions of a "run now" button?
Reply With Quote
  #276  
Old 08-17-2010, 10:24 AM
FASEOFMARS FASEOFMARS is offline
 
Join Date: Mar 2010
Posts: 105
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
and comments like these:

"Processed Database in 3.74 seconds

Backup Completed Successfully
Done"

were would it display this information???
Reply With Quote
  #277  
Old 08-17-2010, 12:06 PM
FASEOFMARS FASEOFMARS is offline
 
Join Date: Mar 2010
Posts: 105
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
nevermind i found it in scheduled tasks....
Reply With Quote
  #278  
Old 08-17-2010, 12:42 PM
FASEOFMARS FASEOFMARS is offline
 
Join Date: Mar 2010
Posts: 105
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
right i have another question..

i need to allow write access to the backup directory..

but if i allow read & write access to everyone it could compromise the site...

any idea's on a safe way to allow write access for apache?
Reply With Quote
  #279  
Old 08-17-2010, 01:40 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Either find out what userid apache is using and just allow it access (not sure how easy that is in linux), or use a directory outside of the web root, so only you have access via ftp.
Reply With Quote
  #280  
Old 08-22-2010, 10:33 AM
Jaxel Jaxel is offline
 
Join Date: Sep 2005
Posts: 1,160
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Okay... I got several questions...

When I "Run Now", it takes 237 seconds, thats a little under 4 minutes. During this time, is my forum closed? The old version of this mod would close my forum, and I liked that. I would like to have my tables locked while this is running; but if the forum is not closed, then that would create an issue...

Next, the file it created was 415mb in size... according to PhpMyAdmin, my database is 490mb in size; why is there a difference? I am not using GZIP. If I use GZIP, it brings the file down to 108mb... wow...

If I enable "Repair Tables" option, it adds a whopping 12 minutes to the backup process! Is there a reason why repair and optimize would take this long? Is there a reason NOT to auto repair and optimize with each backup? Usually doing an R&P will remove 100mb of overhead from the database. (I backup once a week)

And is there a reason NOT to use blocked backups? It just seems like a great "in case shit happens" feature.
Reply With Quote
  #281  
Old 08-22-2010, 12:31 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
1. No, this does not close the forum. That option was removed as it was unreliable (on re-opening).

2. Database size and backup size are completely different things. Gzip will reduce the size greatly.

3. You do not normally need to use those options, in fact, if you did repairs daily it could possibly be detremental.

4. There is no reason not to use them if you prefer it - on most systems it will make very little difference.
Reply With Quote
Reply
Page 28 of 107 « First 182627 28 29303878 Last »

« Previous Thread | Next Thread »

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 01:35 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05451 seconds
  • Memory Usage 2,321KB
  • 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)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
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (14)post_thanks_box_bit
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (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
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • 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