vb.org Archive
Page 2 of 19 1 2 3412 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   [vbcron] Automatic database backup [v1.3] (https://vborg.vbsupport.ru/showthread.php?t=62149)

mOdEtWo 03-04-2004 03:22 PM
This is a great hack, I'll install this one.

Also, good suggestion, Natch. I was on my way to request something like this. A sql file takes up lots of space when the forum is large (we have around 80,000 now), so making it a tar.gz is making the file compact and downloadable. ;)

Yay! Best hack so far!



EDIT: A suggestion. What about the script being able to disable the boards and display a "We're doing database maintenance, come back in 10 minutes" type of message? Is this possible?

Also, I get a Fatal error: Call to undefined function: query() in /var/www/vb3/includes/functions.php on line 501 error message once the script is done. What does it mean?

mharmon 03-04-2004 03:24 PM
This worked great.. a few questions though -- Will it overwrite the old dump each day?
Also -- it also wrote an XXXXXXXX-error.txt file along with the dump but it's empty.

Fi_InCogNiTo 03-04-2004 03:31 PM
Worked great on RC4. Also worked with the tar.gz

Thanks =D

mOdEtWo 03-04-2004 03:48 PM
Quote:
Originally Posted by mharmon
This worked great.. a few questions though -- Will it overwrite the old dump each day?
Also -- it also wrote an XXXXXXXX-error.txt file along with the dump but it's empty.
this file, and the sql file, is deleted once the tar.gz process is finished.

Ryan Ashbrook 03-04-2004 06:36 PM
Exactly what I was looking for! Thank you!

Brad 03-04-2004 07:01 PM
Hey guys, im busy today (I just got done dumping a ton of trash with a tractor! LOL) but if I get time I may update this one today, if not tomorrow.

Planned improvements:

Zip file type support
Delete last backup when doing current one
Close boards when backing up
Clear session table before backup
Options to NOT include stuff like the postcache in the backup

ThePartyBorg 03-04-2004 07:02 PM
Mmh, now this is helpfull, just question. Is it also possible to dumb the file on an other server. We don't really have to place to store backups on the webserver. So I collect them at my own server instead at the moment, would be a dream if all the handelings I need to do would be taken over by this script.

Brad 03-04-2004 07:03 PM
TPB:

I'll look into that for you, however the backup would then consume alot of bandwidth with the transfer to the new server :)

anabolicedge 03-04-2004 07:23 PM
after uploading to the server, how does it run? How often will it backup? More info please, and thanks!

Natch 03-04-2004 07:31 PM
Quote:
Originally Posted by anabolicedge
after uploading to the server, how does it run? How often will it backup? More info please, and thanks!
You would need to set up a new "scheduled task" or cron job with the script as the action ... otherwise it's just a nice file that don't do much ...


All times are GMT. The time now is 12:22 AM.
Page 2 of 19 1 2 3412 Last »
Show 40 post(s) from this thread on one page

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.01095 seconds
  • Memory Usage 1,734KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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