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.

Superorb · #**712** 09-17-2012, 04:00 PM

Quote:

Originally Posted by Trumpetrhapsody

I just tossed this code in there to keep only the latest 5 backups:

Does this work for you? I have 6 files in my backupDB directory and after running the script I still have 6 files. The backups weren't created every day though, they were a few days apart for some of them. I placed the code in the same spot in my mysqlbackup.php file.

Trumpetrhapsody · #**713** 09-17-2012, 05:11 PM

Sorry, I meant to say 6. If you have no more than 6 files you won't see any get removed. You can adjust the number it keeps around.

Superorb · #**714** 09-17-2012, 05:32 PM

Quote:

Originally Posted by Trumpetrhapsody

Sorry, I meant to say 6. If you have no more than 6 files you won't see any get removed. You can adjust the number it keeps around.

I uploaded a few dummy files to my testvb and it still doesn't delete them. The dir is 755 so deleting should be fine. I have 7 files in that dir and it's set to keep 5 files.

ZombieAndy · #**715** 09-17-2012, 07:52 PM

Im probably being really dumb here paul but everytime i try to run this i just get:

Code:

Automatic Database Backup for vBulletin
Backup Error : Could not write to destination file ( .../backups/2012-09-17/Forum-2012-09-17-Aaggregate_temp_1347351000.sql )

And ive tried different varients of the address, both full and relative.. have made sure the directory permissions are set to 777.. what else can i do?

Superorb · #**716** 09-17-2012, 08:00 PM

Quote:

Originally Posted by ZombieAndy

Im probably being really dumb here paul but everytime i try to run this i just get:

Code:

Automatic Database Backup for vBulletin
Backup Error : Could not write to destination file ( .../backups/2012-09-17/Forum-2012-09-17-Aaggregate_temp_1347351000.sql )

And ive tried different varients of the address, both full and relative.. have made sure the directory permissions are set to 777.. what else can i do?

Should it be 3 dots or two? [.../]?

ZombieAndy · #**717** 09-17-2012, 08:08 PM

If your trying to create relative path it should actually be 1 stop (./backups/)

What you see is my dodgy editing for the post.

Anyway, it dosnt work with either a relative or full path in there.

Paul M · #**718** 09-17-2012, 10:05 PM

Quote:

Originally Posted by Superorb

Should it be 3 dots or two? [.../]?

Two.

Superorb · #**719** 09-17-2012, 10:13 PM

Quote:

Originally Posted by Paul M

Two.

I know

betterthanyours · #**720** 09-23-2012, 10:07 AM

Is there anything similar that will backup and then also upload to remote site at all?

Delfi_r · #**721** 09-23-2012, 03:28 PM

Quote:

Originally Posted by Trumpetrhapsody

I just tossed this code in there to keep only the latest 5 backups:

Code:

// Delete Old Backups
	....	
	}

You can call it whenever you want, I put it after the "Repair and Optimize" section, before the "Start Initial Dump" section.

Wich file I should modify?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.13061 seconds Memory Usage 2,330KB Queries Executed 25 (?)
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 (3)bbcode_code (6)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 (14)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)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_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

The Arcive of Official vBulletin Modifications Site.

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