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)

Paul M 12-27-2009 10:00 PM

vBulletin Cron Based Database Backup
 
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.


utahraves 12-28-2009 07:01 PM

Woot woot. Why did they take it out in the first place? duh... i used it all the time.

Floris 12-28-2009 07:09 PM

I care for my site, so I do not trust apache/php/mysql limits from the browser. And use a shell to back it up. This way apache can be down, but I can still make a database. And after 15mb for example on most hosts I still get a complete sql dump.

But strange that they removed it. I guess they didn't add any value to backing up database or something. Good to see a vBulletin.org administrator show he cares about sites too and adding this as a plugin to version 4.

dodgeboard.com 12-28-2009 07:28 PM

Thanks Paul, for your work on this.

Q: How does this deal with PHP script timeouts? Will it work with a 200 mb database for example?

I know that MSD will use refreshes and resume routines to get around script timeouts for large databases...will this do the same?

TIA

Alecsmith 12-28-2009 07:34 PM

Installed very good wwork paul :)

Paul M 12-28-2009 07:49 PM

Quote:

Originally Posted by dodgeboard.com (Post 1940759)
Q: How does this deal with PHP script timeouts? Will it work with a 200 mb database for example?

It sets the timeout to 1 hour (unless your php setup disallows this).

My database it well over 1GB, and i use this daily (it takes < 5 minutes to run the backup).

Adem GEN? 12-28-2009 07:54 PM

Thank you very much
Installed

BlackJacket 12-28-2009 08:10 PM

This was the last mod i have been waiting for. Thank you very much Paul. Your work is much appreciated.

dodgeboard.com 12-28-2009 08:18 PM

Quote:

Originally Posted by Paul M (Post 1940774)
It sets the timeout to 1 hour (unless your php setup disallows this).

My database it well over 1GB, and i use this daily (it takes < 5 minutes to run the backup).


AWESOME! Great Work Paul. Always love your mods! <clicks install>

Adem GEN? 12-28-2009 08:30 PM

My bad English

Installed forum
AND
I wanted to make a backup manually
Can not write file error has
AND
Forum no files within the directory was deleted or I do not see all did not stay

Error occurred: 403 - no permission


All times are GMT. The time now is 07:38 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.04563 seconds
  • Memory Usage 1,739KB
  • 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
  • (2)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