vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Administrative and Maintenance Tools - vBulletin Cron Based Database Backup (https://vborg.vbsupport.ru/showthread.php?t=231481)

FASEOFMARS 08-17-2010 09:24 AM

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?

ProFifaLeagues 08-17-2010 09:53 AM

Its done each day by a cron job mate

FASEOFMARS 08-17-2010 10:14 AM

k ill see how it goes then.. thanks...

FASEOFMARS 08-17-2010 10:23 AM

im hearing mentions of a "run now" button?

FASEOFMARS 08-17-2010 10:24 AM

and comments like these:

"Processed Database in 3.74 seconds

Backup Completed Successfully
Done"

were would it display this information???

FASEOFMARS 08-17-2010 12:06 PM

nevermind i found it in scheduled tasks....

FASEOFMARS 08-17-2010 12:42 PM

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?

Paul M 08-17-2010 01:40 PM

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.

Jaxel 08-22-2010 10:33 AM

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.

Paul M 08-22-2010 12:31 PM

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.


All times are GMT. The time now is 08:58 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.01331 seconds
  • Memory Usage 1,730KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete