Go Back   vb.org Archive > vBulletin Modifications > Archive > Modification Graveyard

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
  #362  
Old 07-12-2007, 05:08 PM
BadgerDog BadgerDog is offline
 
Join Date: Oct 2006
Location: Toronto
Posts: 1,789
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Paul M View Post
The advantage of single files is you can restore a single table if required. The disadvantage is you need to join them if you want to restore everything in one go. It's personal choice.
Thanks Paul....

Yup, for the first time last night, I set the config to do one file and that's what I got. One humungous single file for restore, if I ever needed it.

Regards,
Badger
Reply With Quote
  #363  
Old 07-20-2007, 01:35 AM
Fireproof Fireproof is offline
 
Join Date: Apr 2007
Posts: 155
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Holy cow - worked the first try!! Awesome mod - thank you very much!!
Reply With Quote
  #364  
Old 07-26-2007, 07:45 PM
Cyricx Cyricx is offline
 
Join Date: Aug 2002
Location: Missouri
Posts: 1,144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Necrosaro420 View Post
Any ideas why I get this message every time I run it? Plus I dont have an option in the control panel anywhere for some reason to set my options, I have installed it correctly. Thanks

Error:

An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)
You likely need to chmod the destination directory to 777.

Make sure you set up your settings in the config file for the mod



Great hack!!! Love it!! Really helps out when my host doesn't always give me the best SSH access
Reply With Quote
  #365  
Old 07-27-2007, 05:42 PM
Deimos Deimos is offline
 
Join Date: Oct 2002
Posts: 529
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Has anyone figured out how to put a conditional in, to delete backups which pass a certain age? like 7 days or something?
Reply With Quote
  #366  
Old 07-27-2007, 06:05 PM
BadgerDog BadgerDog is offline
 
Join Date: Oct 2006
Location: Toronto
Posts: 1,789
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Deimos View Post
Has anyone figured out how to put a conditional in, to delete backups which pass a certain age? like 7 days or something?
I second that.... :up:

It would be very useful... a rolling 7 days of backups as an example...

Regards,
Badger
Reply With Quote
  #367  
Old 08-01-2007, 04:32 AM
David Lama David Lama is offline
 
Join Date: Apr 2007
Posts: 82
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

this may be a dumb question.. but where on my server should i put the files in the includes folder?
Reply With Quote
  #368  
Old 08-02-2007, 01:10 AM
twilighthush twilighthush is offline
 
Join Date: Aug 2006
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Destination folder is chmodded to 0777, however I'm still getting the error:

Quote:
An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)
I changed the path to: /home/users/public_html/forum/[foldernamehere]

It is a password locked folder -- from the outside. But it shouldn't affect backup, because I know I can manually back up via AdminCP. Please advise.
Reply With Quote
  #369  
Old 08-02-2007, 01:15 AM
Deimos Deimos is offline
 
Join Date: Oct 2002
Posts: 529
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by BadgerDog View Post
I second that.... :up:

It would be very useful... a rolling 7 days of backups as an example...

Regards,
Badger
I'm having a friend of mine program it in, so once she's done it, I'll post the modified/added code here.
Reply With Quote
  #370  
Old 08-02-2007, 01:35 AM
twilighthush twilighthush is offline
 
Join Date: Aug 2006
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Edited path to root forum so it reads like:

$backup['DUMP_PATH'] = '/home/users/cabbage/'; // Path to backups folder, with trailing slash

and chmodded the folder to 777.

Still not working. Any ideas?
Reply With Quote
  #371  
Old 08-05-2007, 02:28 PM
philip_g philip_g is offline
 
Join Date: Dec 2004
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by twilighthush View Post
Edited path to root forum so it reads like:

$backup['DUMP_PATH'] = '/home/users/cabbage/'; // Path to backups folder, with trailing slash

and chmodded the folder to 777.

Still not working. Any ideas?
dunno, mine would only work correctly without the trailing / but then wouldn't actually write the file. I gave up lol
Reply With Quote
Reply

Thread Tools

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 08:19 PM.


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.05891 seconds
  • Memory Usage 2,304KB
  • 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
  • (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
  • (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_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