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

Reply
 
Thread Tools
vB Database Backup Pro (Lite) for vb 3.6 Details »»
vB Database Backup Pro (Lite) for vb 3.6
Version: 2.12, by Paul M Paul M is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page

Category: Administrative and Maintenance Tools - Version: 3.6.x Rating:
Released: 09-17-2006 Last Update: 10-09-2006 Installs: 582
Auto-Templates
Re-useable Code Additional Files Translations  
No support by the author.

This modification is no longer available or supported.

When vb 3.5 first came out I was using this backup system on my vb 3.0 - and having nothing better to use - I converted it to work on vb 3.5 (here) and since then I have cut it down and adapted it for vb 3.6.

The original version was by Trigunflame and the rights to the code were bought by Zoints (D.Chapman) in January. A while ago David gave me permission to release my adaption, but until now I haven't got round to it. Trigunflame did mention a few months ago he was working on a new version, but nothing ever appeared.

I have stripped out much of the extra stuff that I do not use (or indeed, could not get to work). This is a simple (lite) version that does a php based dump of your database either as one file, or one file per table. It's been in use on our forum since the day 3.6 was installed.

Notes:
* I will not add anything new to this, or spend vast amounts of time supporting it.
* This is a Lite version to allow people to use the basic 3.0 backup functionality on 3.6.


History:

v2.10 : First internal version.
v2.11 : Bug fixes, some code changes.
v2.12 : Initial Public Release.

Show Your Support

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

Comments
  #12  
Old 09-18-2006, 05:10 PM
Neal-UK's Avatar
Neal-UK Neal-UK is offline
 
Join Date: Feb 2004
Location: Lancashire, England
Posts: 604
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have my backup off the root, but when I enter the same settings as when I do a manual backup I get the same error bashy gets.

In the config file, it does say DIR for the backup with trailing "/"

I've entered it like "/site/user/whatever/isit/dbbackup/"
Reply With Quote
  #13  
Old 09-18-2006, 05:17 PM
phpdevrus phpdevrus is offline
 
Join Date: Mar 2006
Location: San Francisco, CA
Posts: 127
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

you just need to chmod the directory to make it writable. ;-) also remember to keep it out of public_html so that it is not viewable to the web.

also keep the directory within your sites dirs and not off of / but rather a local dir for that particular site ie. /site/user/what/backups/ or /home/whatever/backups.

your script will run as the user nobody or your account user, which will not allow it to write files off of root ie. /dbbackups

hope that helps.

----

i forgot to mention... nice... :-) works fine for me and i have 900k post. it might cause a load issue but it seems the same compared to when i run mysqldump from ssh.
Reply With Quote
  #14  
Old 09-18-2006, 05:21 PM
Neal-UK's Avatar
Neal-UK Neal-UK is offline
 
Join Date: Feb 2004
Location: Lancashire, England
Posts: 604
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It's all set right then, the directory is chmod to 777 as i normally do a manual backup. It's one above public_html also for security reasons.

Can't get it to work.

EDIT: Replaced file with directory
Reply With Quote
  #15  
Old 09-18-2006, 05:22 PM
phpdevrus phpdevrus is offline
 
Join Date: Mar 2006
Location: San Francisco, CA
Posts: 127
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

no i meant chmod the directory and not the file. let me know if that works or not.
Reply With Quote
  #16  
Old 09-18-2006, 05:28 PM
Neal-UK's Avatar
Neal-UK Neal-UK is offline
 
Join Date: Feb 2004
Location: Lancashire, England
Posts: 604
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes the directory is chmod to 777, as I normally do a manual backup.

Weird, useful mod this too.
Reply With Quote
  #17  
Old 09-18-2006, 05:57 PM
Snake's Avatar
Snake Snake is offline
 
Join Date: Mar 2005
Location: Cleveland, OH
Posts: 3,832
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks for this. Sounds interesting but do you have any screenshots?
Reply With Quote
  #18  
Old 09-18-2006, 05:58 PM
Snake's Avatar
Snake Snake is offline
 
Join Date: Mar 2005
Location: Cleveland, OH
Posts: 3,832
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Nevermind. Found one in the old thread.
Reply With Quote
  #19  
Old 09-18-2006, 06:13 PM
mIRCnet's Avatar
mIRCnet mIRCnet is offline
 
Join Date: Nov 2001
Location: UAE
Posts: 39
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Paul ,
Sorry to ask you, My forum path is /home/user/public_html/forum
I want it to store the backup in this DIR /home/user/packups
can you help me please ?
Reply With Quote
  #20  
Old 09-18-2006, 07:29 PM
steadicamop's Avatar
steadicamop steadicamop is offline
 
Join Date: Jul 2004
Location: Lancashire, UK
Posts: 379
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This works very well, but I have a problem which I think isn't solveable - I think the php execution time is set at around 30 seconds, which often times out when it's backing up a table, and will only ever reach postindex before it ends, never carrying out a full backup - is there any way around this? I really would like this as it's damn handy to have daily backups!!!

Plus as I've just discovered, it leaves the forum offline!
Reply With Quote
  #21  
Old 09-18-2006, 08:26 PM
Alrasam Alrasam is offline
 
Join Date: Jan 2004
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks Paul
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:16 PM.


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.04938 seconds
  • Memory Usage 2,302KB
  • 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
  • (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
  • (3)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (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
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • 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