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
  #222  
Old 03-08-2007, 01:41 PM
djbaxter djbaxter is offline
 
Join Date: Aug 2006
Location: Ottawa, Canada
Posts: 2,601
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No, there's something wrong with your path to the backup directory.
Reply With Quote
  #223  
Old 03-08-2007, 01:48 PM
antiekeradio's Avatar
antiekeradio antiekeradio is offline
 
Join Date: Feb 2006
Location: Netherlands
Posts: 36
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

what i thought of as really strange is that the path i specify comes back twice within the ( and ), first time after (/tmp:/ and then after :/user/lib/php:/

anyways, i am going to try again (never had this sort of problems with paths before, and i used impex etc)
Reply With Quote
  #224  
Old 03-08-2007, 01:53 PM
TrIn@dOr TrIn@dOr is offline
 
Join Date: Nov 2006
Location: South Bend, IN
Posts: 169
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by djbaxter View Post
That usually means:

1. you haven't set the backup directory to be wirteable, OR more likely

2. you haven't correctly specified the path to the directory: note that this is the "physical" path on your server, not the URL - read previous posts in this thread by Paul M for specific instructions
  1. The directory has 777 of permissions, thats why the Y-m-d directory is created.
  2. The path used is the same used with vBadvanced CMPS (phpinfo), thats why the Y-m-d directory is created too.
Or?
Reply With Quote
  #225  
Old 03-08-2007, 03:54 PM
antiekeradio's Avatar
antiekeradio antiekeradio is offline
 
Join Date: Feb 2006
Location: Netherlands
Posts: 36
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

OK well now I am 100% sure I have filled in the directory correctly.

why? it still doesn't work but if i manually add the dir that would be generated for todays backup, it gets deleted after the error messages. same for the sql file for the access table, in that directory.

there's an error somewhere else. either in the script or in the webhost's configuration.
our server runs PHP Version 5.1.6 with MySQL 4.1.14
Reply With Quote
  #226  
Old 03-08-2007, 03:57 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

Quote:
Originally Posted by antiekeradio View Post
is there something wrong with the server setup?
Not exactly, openbasdir is a system in php that restricts what files it can write to, you can only write to files within the paths listed in the error. You really need to speak to your host, or use a path within those allowed.
Reply With Quote
  #227  
Old 03-08-2007, 04:11 PM
antiekeradio's Avatar
antiekeradio antiekeradio is offline
 
Join Date: Feb 2006
Location: Netherlands
Posts: 36
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i think the 'allowed' path gets screwed up because i see virtually the same path thice, separated by a colon.

will have to talk about this with the host (or uninstall until we found a better one ;-) )

anyways, thanks for your time and i WILL reinstall this when i can get it working!!
Reply With Quote
  #228  
Old 03-17-2007, 08:14 PM
Aclikyano Aclikyano is offline
 
Join Date: Apr 2006
Posts: 481
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Database Backup

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

(when I selected run now)
Reply With Quote
  #229  
Old 03-17-2007, 10:26 PM
djbaxter djbaxter is offline
 
Join Date: Aug 2006
Location: Ottawa, Canada
Posts: 2,601
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Aclikyano View Post
Database Backup

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

(when I selected run now)
Either

1. the path to your backup directory is incorrect; or

2. you forgot to write-enable the backup directory (7-7-7)
Reply With Quote
  #230  
Old 03-18-2007, 12:11 PM
ascender ascender is offline
 
Join Date: Feb 2007
Posts: 16
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Fantastic product, thanks for developing it and sharing.
Reply With Quote
  #231  
Old 03-18-2007, 01:08 PM
stejoh stejoh is offline
 
Join Date: Jan 2007
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Seems to work just great for me! Many thanks!

Have two questions about the config file:
What does the options below mean and what effects has the value 1 on these settings?

Quote:
// Backup Options
$backup['LOCK'] = 0; // Lock tables during dump
$backup['REPAIR'] = 0; // Repair & Optimize tables before dump
Quote:
// Combine Tables into one file
$backup['COMBINE'] = 0;
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 02:26 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.05841 seconds
  • Memory Usage 2,312KB
  • 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
  • (5)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