Go Back   vb.org Archive > vBulletin Modifications > Archive > Modification Graveyard
Reload this Page Administrative and Maintenance Tools - vBulletin Cron Based Database Backup
FAQ Community Calendar Today's Posts Search

Reply
Page 10 of 107 « First 89 10 11122060 Last »
 
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
  #92  
Old 01-25-2010, 08:38 AM
ChopSuey ChopSuey is offline
 
Join Date: Jun 2009
Location: Alaska
Posts: 2,140
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Awesome paul, thanks again.
Reply With Quote
  #93  
Old 01-25-2010, 01:12 PM
Mistamike17 Mistamike17 is offline
 
Join Date: Jul 2007
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Having issues:

An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)

I've tried every possible directory combination I can think of, but no dice. I've CHMOD'd and also still had no luck. Any ideas?

Forum files are in public_html/website/. I've tried ../backups/, ../../backups/, etc. All of them to no avail.

TIA for help.
Reply With Quote
  #94  
Old 01-25-2010, 03:06 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
Have you actually created the backup directory you are trying to use ?
Reply With Quote
  #95  
Old 01-25-2010, 05:05 PM
ChopSuey ChopSuey is offline
 
Join Date: Jun 2009
Location: Alaska
Posts: 2,140
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
/home/yourname/backups/

create a folder same directory as public_html
Reply With Quote
  #96  
Old 01-26-2010, 01:47 AM
Hondarydr Hondarydr is offline
 
Join Date: Oct 2009
Posts: 5
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Alright I got everything installed but when I click Run Now I get this error:
Code:
Backup Error : Could not write to destination file ( /public_html/forum/backup/Forum-01-25-2010-Full-Backup.sql )
I know it is not a good location for the file but I am just testing it. I also made that folder writable so I don't know what's going on.
Any suggestions?
Reply With Quote
  #97  
Old 01-26-2010, 02:53 AM
trilogy33 trilogy33 is offline
 
Join Date: Jan 2008
Location: UK
Posts: 70
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Just out of curiosity, is it a good idea to "Lock Tables" when doing the backup?
I seem to remember we had that enabled on the old v3.x one.
Reply With Quote
  #98  
Old 01-26-2010, 08:12 AM
ChopSuey ChopSuey is offline
 
Join Date: Jun 2009
Location: Alaska
Posts: 2,140
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Hondarydr View Post
Alright I got everything installed but when I click Run Now I get this error:
Code:
Backup Error : Could not write to destination file ( /public_html/forum/backup/Forum-01-25-2010-Full-Backup.sql )
I know it is not a good location for the file but I am just testing it. I also made that folder writable so I don't know what's going on.
Any suggestions?
Wow its supposed to be like this
/home/username/backups
/home/username/public_html

Get it? Your making your backups public lol.
Reply With Quote
  #99  
Old 01-26-2010, 08:30 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
Quote:
Originally Posted by trilogy33 View Post
Just out of curiosity, is it a good idea to "Lock Tables" when doing the backup?
I seem to remember we had that enabled on the old v3.x one.
It depends, it means no tables can be updated while the backup is running, which is ideal - however, it also means your forum will not function until the backup has completed.
Reply With Quote
  #100  
Old 01-26-2010, 08:47 PM
Hondarydr Hondarydr is offline
 
Join Date: Oct 2009
Posts: 5
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by ChopSuey View Post
Wow its supposed to be like this
/home/username/backups
/home/username/public_html

Get it? Your making your backups public lol.
Sorry I'm a noob at this lol I still don't understand. Could you explain it a little more?
Thanks

EDIT: Never mind I got it all fixed, thanks
Reply With Quote
  #101  
Old 01-26-2010, 08:53 PM
trilogy33 trilogy33 is offline
 
Join Date: Jan 2008
Location: UK
Posts: 70
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Paul M View Post
It depends, it means no tables can be updated while the backup is running, which is ideal - however, it also means your forum will not function until the backup has completed.
Yes thanks Paul. I'd noticed that happen on the older version.
No biggie, as the task is in the early hours, take just a few seconds and the notice is displayed.
That's cool
Reply With Quote
Reply
Page 10 of 107 « First 89 10 11122060 Last »

« Previous Thread | Next Thread »

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 02:25 PM.

Contact Us - Archive - Top

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.05326 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
  • (2)bbcode_code
  • (4)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
  • (2)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