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 (https://vborg.vbsupport.ru/showthread.php?t=167276)

HybridIllusions 04-28-2008 01:26 AM

I've modified this script to create a folder per day, while it creates a backup file in the folder every 6 hours. How is this different? Well, instead of it rewriting the file, it'll make a new one, thus a 6 hour cron per day gives around 4 backup files per folder. I did this by forcing the file name to be a time, instead of a date, as well as

Thus it just creates a new file for each time that a new backup is made, in one folder per day (since the folder name is just the date and not the time, thus it doesn't create another one). How does this help? Well, it helps keep backups of times where the forums could be up and running great, but prevent backing up or replacing a backup of when the forums were hacked or whatever.

So, lets say your forum was backed up. Awesome! Now, sometime before the next backup, a hacker or someone you thought you could trust goes crazy and deletes all posts, users, or just generally messes up the software data. Well, unless caught before the next backup and the forums are running fine enough to use crons, then it'll replace the old backup file with the screwed up one. Thus, the backup won't help in that situation...

So, I just have it do a 6 hour backup per day, thus around 4 backup files in one daily folder. Anyways, just wanted to explain this, and am willing to help or re-release my modified version that does just this. However, I would need permission first, so that's why I'm posting.

If not, oh well. Thanks for releasing a killer mod! Definitely making me feel at ease :D

nothing4me 05-02-2008 07:14 PM

I get the error:
Quote:

An error occured during the Backup : Could not open Destination SQL file for writing.

HybridIllusions 05-02-2008 10:00 PM

Quote:

Originally Posted by nothing4me (Post 1506066)
I get the error:

Make sure the path to store the backups is correct (must create a all folders in the path, if not already created)

drsli 05-04-2008 03:28 PM

Quote:

Originally Posted by Paul M (Post 1498333)
As I recall, this has a 1 hour script timeout so maybe you are exceeding that. Try upping it to 2 hours. There are no size restrictions in this other than ones the OS you are running may apply.

First of all - thank you very much for providing this useful enhancement! :)

Regarding the timeouts I wonder about the flaweless function of this tool within my server-restrictions: as my provider told me, there is a timeout of 30 seconds regarding perl- and php-sripts. My database is growing beyond 30 mbs, maybe that could provoke an interruption of the backup-tool with an incomplete dump?

Paul M 05-04-2008 04:02 PM

This should override the 30 second default timeout in php.

Phaedrus 05-04-2008 04:21 PM

How different is this from the 3.6 version that I currently run?

Paul M 05-04-2008 04:58 PM

Minor changes, no need to change it if the 3.6 version is running ok for you.

Phaedrus 05-04-2008 07:41 PM

Quote:

Originally Posted by Paul M (Post 1508292)
Minor changes, no need to change it if the 3.6 version is running ok for you.

Very good. I'll mark this one as installed though.

I love this mod. It has made my life much easier.

SMO 05-05-2008 12:01 AM

Paul, just to clarify, and more for my sake... does this have the capability to back up to db on my server automatically and dump thie old one? Where does it save? In what format does it save? Sorry if this had been answered but I couldnt find the exact issues.

thanks

Phaedrus 05-05-2008 01:04 AM

Quote:

Originally Posted by SMO (Post 1508750)
Paul, just to clarify, and more for my sake... does this have the capability to back up to db on my server automatically and dump thie old one? Where does it save? In what format does it save? Sorry if this had been answered but I couldnt find the exact issues.

thanks

This simply backs up your database to somewhere on your server according to the cron timer..

You tell it which file it writes to. Mine goes into a file above the public area so nobody can access it but me...

It has no ability to upload the db, you would have to do that through more mundane means.


All times are GMT. The time now is 05:49 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.01212 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
  • (5)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