Go Back   vb.org Archive > vBulletin Modifications > Archive > Modification Graveyard
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vBulletin Cron Based Database Backup Details »»
vBulletin Cron Based Database Backup
Version: 4.2.0.2, by Paul M Paul M is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page

Category: Administrative and Maintenance Tools - Version: 4.2.x Rating:
Released: 12-27-2009 Last Update: 11-25-2013 Installs: 1434
Uses Plugins
Additional Files Translations  
No support by the author.

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.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #832  
Old 03-12-2013, 09:46 PM
Deuces73 Deuces73 is offline
 
Join Date: Jul 2011
Posts: 5
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Overlooked the " 1 file " setting , as i read that default settings where the way to go and assumed that 1 file would be default.

So if anyone encounters a simular problem , try setting :

Code:
Set to yes to combine all tables into one backup file.
to " Yes " as it appears to be on no by default.

Result :


Processed Database in 50.898 seconds

Backup Completed Successfully
Done


Reply With Quote
  #833  
Old 03-23-2013, 04:09 PM
Bengie Bengie is offline
 
Join Date: Sep 2011
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
1. Copy all files in the 'includes' folder to the server.

2. Upload the product XML via the Product Manager.

3. Set your choice of options in the ACP (vBulletin Options).

4. Alter the timing of the cron job to suit.
Well that's me lost already, sorry but I haven't a clue what this means.

I haven't seen it mentioned, does this do a recovery as well ?
Reply With Quote
  #834  
Old 03-23-2013, 07:18 PM
smirkley smirkley is offline
 
Join Date: Apr 2008
Posts: 627
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If you mean a database recovery, this mechanism just creates the backup files.

For me, I would do a recovery via phpMyAdmin in my server control panel, using the backup file I selected.
Reply With Quote
  #835  
Old 03-26-2013, 12:54 AM
JfoxEdge JfoxEdge is offline
 
Join Date: Apr 2012
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Having a problem. VB 4.1.12. No idea where to look. When I try to run a backup by clicking Run Now from the Scheduled Task Manager, I immediately get a message that says:

Automatic Database Backup for vBulletin
Backup Aborted : vBulletin Options Error

Any help would be appreciated.

Thanks!
Reply With Quote
  #836  
Old 03-26-2013, 05:31 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Are you using some form of datastore cache ?

Basically that means the code failed to load your options.
Reply With Quote
  #837  
Old 03-28-2013, 04:59 AM
Sios Sios is offline
 
Join Date: Mar 2011
Posts: 22
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm new altogether to this "cron job" and don't understand how to run the backup.

I already have the Mod marked as Installed as well as the mod installed through my FTP.

So my questions are:

- What do I do from here?

- How do I access this "cron jobs" and set it up?

- How do I make it automated to run per week basis?
Reply With Quote
  #838  
Old 03-29-2013, 01:52 AM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Do you install the product as well ? That create the cron job for you.
Reply With Quote
  #839  
Old 03-29-2013, 02:12 AM
flash84 flash84 is offline
 
Join Date: Apr 2012
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Sios View Post
I'm new altogether to this "cron job" and don't understand how to run the backup.

I already have the Mod marked as Installed as well as the mod installed through my FTP.

So my questions are:

- What do I do from here?

- How do I access this "cron jobs" and set it up?

- How do I make it automated to run per week basis?

For the settings go to:
AdminCP > Options > vBulletin Automatic Backup

For the cron job schedule go to:
AdminCP > Scheduled Task Manager > Automatic Database Backup for vBulletin
Reply With Quote
  #840  
Old 03-29-2013, 02:25 AM
smirkley smirkley is offline
 
Join Date: Apr 2008
Posts: 627
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Sios View Post
I'm new altogether to this "cron job" and don't understand how to run the backup.

I already have the Mod marked as Installed as well as the mod installed through my FTP.

So my questions are:

- What do I do from here?

- How do I access this "cron jobs" and set it up?

- How do I make it automated to run per week basis?
And I know this thread has 56 pages so far, but trust me from experience, most questions you could ask are in here somewhere.

It took me about two times reading all the pages to figure it out.

I'm kinda slow sometimes.
Reply With Quote
  #841  
Old 04-28-2013, 03:36 AM
flash84 flash84 is offline
 
Join Date: Apr 2012
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Just tried this on a larger database and though I had timeout issues but it turns out that the database backup file gets too large for the file system and the server kills the script.

This is an issue which could be affecting people with large databases. If the backup file gets to 2Gigabytes (2,147,483,648 Bytes) it will stop creating the file and you will see "child pid xxxxx exit signal File size limit exceeded (25)" in the server error log. The backup file will be stuck at 2,147,483,647 Bytes.

This is because linux can only create files up to 2GB on a 32bit operating system.

To get around this just change the "Combine Files" setting to "No" and each table will be backed up individually. So long as an individual table is no large than 2GB it will work
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:22 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05334 seconds
  • Memory Usage 2,325KB
  • 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
  • (1)bbcode_code
  • (3)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