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 - vB Database Backup (Lite) (https://vborg.vbsupport.ru/showthread.php?t=201319)

Paul M 06-26-2010 08:34 PM

Quote:

Originally Posted by MonkYZ (Post 2059786)
I don't understand what you mean. If i go in my Scheduled Task Manager and look for Automatic Database Backup for vBulletin i can only set what day of the week, day of the month and hour i want to backup. I don't understand how can i limit the number of files (what lowercase L means ? where do i find that ?)...

vBulletin Options > vBulletin Automatic Backup > Date Format

(Setting for Backup file date format ).

Quote:

Originally Posted by Simon Lloyd (Post 2059960)
Paul, i'm also interested in doing this, i have my cron job set to every sunday, how do i get it to overwrite the previous weeks entry?

As above - if the generated filename is/are the same, it will simply replace the existing file(s).

Simon Lloyd 07-25-2010 02:15 PM

Quote:

Originally Posted by Paul M (Post 2060059)
vBulletin Options > vBulletin Automatic Backup > Date Format

(Setting for Backup file date format ).


As above - if the generated filename is/are the same, it will simply replace the existing file(s).

Hi paul, i currently use this mod and it's already saved me a nightmare!, however i wanted the back-up performed every Sunday, you kindly gave the solution of using a lowercase L, i do now get a backup every sunday but it's a single file where the ones before gave me a dated folder with each component backed up separately, how do i get back to having each element backed up as before but just on a sunday?

Zylantex 07-25-2010 04:23 PM

Great add-on. Thanks OP.

Paul M 07-25-2010 04:40 PM

Quote:

Originally Posted by Simon Lloyd (Post 2074273)
Hi paul, i currently use this mod and it's already saved me a nightmare!, however i wanted the back-up performed every Sunday, you kindly gave the solution of using a lowercase L, i do now get a backup every sunday but it's a single file where the ones before gave me a dated folder with each component backed up separately, how do i get back to having each element backed up as before but just on a sunday?

Just set the vb cron job to run once a week (on Sunday) using the standard date format.

GoTTi 08-23-2010 04:46 AM

getting this error:

Automatic Database Backup for vBulletin
An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)

Zylantex 08-23-2010 09:51 AM

Suggestion:

Daily backups are great but unless I download the backups and delete them promptly they eat up my disk space allowance on my host. The ability to do a backup on multiple selected days of the week would be really useful. It would let users back up weekly or twice a week, say Monday and Thursday, or any other combination of days that suits.

At the moment the only alternative to daily seems to be monthly and thats a bit risky imho.

melbo 09-20-2010 06:23 PM

Thanks for the update with gzip. I also just set my date code to 'l'. I used to go in weekly and delete all but 2 backups and now I don't have to anymore. Truly automatic! It does take up ~ 2.5 GB buts that's a small price to pay

Simon Lloyd 09-20-2010 11:18 PM

Paul, i love this mod and couldn't live without it now but i do experience a small problem more often than not, when using the option to close forum during back up i'll find that i sign on the next day and find that the forums are still closed, i then have to turn off your mod, CLOSE the forums in vboptions (yes i know its already closed) then open the forum again and reinstate your mod, any idea what could be causing the lock up, is there some way of adding an extra check to see if the back up activity has stopped then make the forum closed status time out?

Right now i leave the option off but it could spell disaster eventually as my database is over 2gb.

Paul M 09-21-2010 07:41 AM

That option has always had issues, and as I didnt write it, ive never had the time to look into why.

I suggest you simply dont use it (I dont). It was removed from the 4.0 version.

You can always use the lock tables option, but only do it at a very quiet period as visitors will experince the forum hanging while you do, and eventually you will start to get "too many connections" errors as the mysql process queue backs up waiting for write access.

Simon Lloyd 09-22-2010 05:29 AM

Thanks for coming back to me, i've also turned off the lock tables too now as i don't want to get a barrage of database error emails :)


All times are GMT. The time now is 03:00 PM.

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.01740 seconds
  • Memory Usage 1,741KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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