The Arcive of Official vBulletin Modifications Site.

vBulletin Cron Based Database Backup · **Released**: 12-27-2009

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.

smirkley · #**802** 01-17-2013, 01:41 PM

I think the best advantage that I could think of is (and Paul correct me if I am wrong), is some shared servers may not have the ability to restore a large file before timing out. So you could instead restore a table at a time.

artos0131 · #**803** 01-17-2013, 11:28 PM

Is there any way to automatically delete backups that are older than X days? That would be cool to save some disk space.

smirkley · #**804** 01-18-2013, 12:29 AM

I only use the date of the month in the filename, and have verified that when the month rolls around, it deletes and creates a new file for that date. I end up with no more than 31 files.

Paul M · #**805** 01-18-2013, 12:44 AM

Quote:

Originally Posted by dirkji

Is there an advantage to one of these?

Depends on what you want. Its easier to restore a single table if you split them, but in most cases you will want to restore an entire database, in which case a whole file is better.

JFYI, I use the single file option.

dirkji · #**806** 01-18-2013, 08:22 AM

Ok, thanks guys.

artcrimes · #**807** 01-18-2013, 11:56 AM

Niceee

SPVB · #**808** 01-20-2013, 12:36 PM

After a few failed attempts at identifying the relative path to /backups/, the mod is working like a charm! I had tried previously tried almost everything to set up a backup cron job through the forum host without success.

FYI changed ../../backups/ to ././backups after finding the tip in the mod comments

dbarry · #**809** 01-23-2013, 09:20 PM

Great Mod! Works like a champ!

dizzynation · #**810** 02-08-2013, 04:50 AM

Voted MOTM

snowlion · #**811** 02-11-2013, 02:47 AM

Can I delete or drop or truncate cronlog table because it is too large and the backup process stop at

Quote:

Processing ***_cronlog (2186338)
......................................
--- Processed 437000 Rows

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.17417 seconds Memory Usage 2,317KB Queries Executed 27 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (11)post_thanks_box (16)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (3)post_thanks_postbit (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

15 благодарности(ей) от:
dellow, dlewisr, elsa23, findingpeace, Hostboard, kemana, nacaruncr, prandah, RichieBoy67, Rubio, sarvarjafari, seb5594, tareqbd, to_die4

Благодарность от:
artos0131

Благодарность от:
smirkley

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!