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
  #242  
Old 03-26-2007, 06:05 AM
stejoh stejoh is offline
 
Join Date: Jan 2007
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Paul M View Post
It ends up wherever you point the backup path.
I have a question about the backup path in the mysqlbackupconfig.php-file, I could not find the anwser in previous posts:
I currently use this code and it works just fine.
PHP Code:
$backup['DUMP_PATH'] = DIR.'/backup/'
The DIR point to "www.domain.org/forum/" and my backups works just fine.

However, I would like to backup to a folder outside the forum-folder. But I have not managed to get the syntax right. Naturally, I created the folder 'backup' on the server before editing the config-file.
I get the following error messgae :
Quote:
An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)
I have tried several alternatives (see below) but none has worked.
PHP Code:
$backup['DUMP_PATH'] = 'http://www.domain.org/backup/'
PHP Code:
$backup['DUMP_PATH'] = '/www.domain.org/backup/'
PHP Code:
$backup['DUMP_PATH'] = '/backup/'

Is it at all possible to make the script to write the backup outside the forum-folder, and if yes,
Reply With Quote
  #243  
Old 03-26-2007, 11:37 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

Use '../' to move 'up' a level.

e.g.

PHP Code:
$backup['DUMP_PATH'] = '../backup/'
or
PHP Code:
$backup['DUMP_PATH'] = '../../backup/'
Reply With Quote
  #244  
Old 03-26-2007, 11:50 AM
stejoh stejoh is offline
 
Join Date: Jan 2007
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Paul M View Post
Use '../' to move 'up' a level.
PHP Code:
$backup['DUMP_PATH'] = '../backup/'
Thanks for quick help! Worked just perfect! :up:
Reply With Quote
  #245  
Old 03-28-2007, 11:47 AM
2meplie 2meplie is offline
 
Join Date: Nov 2006
Location: Quebec city, Qc, Canada
Posts: 43
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Got this error when trying to run the backup:

Fatal error: Cannot instantiate non-existent class: mysqlbackup in /home/.../public_html/forum/includes/cron/cronbackup.php on line 19
Reply With Quote
  #246  
Old 03-28-2007, 12:01 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 uploaded all the files, to the correct place ?
Reply With Quote
  #247  
Old 03-28-2007, 12:09 PM
2meplie 2meplie is offline
 
Join Date: Nov 2006
Location: Quebec city, Qc, Canada
Posts: 43
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes

mysqlbackup.php
mysqlbackupconfig.php

in forum/includes

cronbackup.php

in forum/inlcudes/cron
Reply With Quote
  #248  
Old 03-28-2007, 02: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

Then I have no idea - the class is clearly defined in mysqlbackup.php

Have you edited any of the files ?
Reply With Quote
  #249  
Old 03-28-2007, 02:38 PM
hotmasala4u hotmasala4u is offline
 
Join Date: Nov 2006
Posts: 64
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

So This Auto backup ur forums???

can u give me some more details like where it saves and other stuf plz
Reply With Quote
  #250  
Old 03-28-2007, 08:05 PM
antiekeradio's Avatar
antiekeradio antiekeradio is offline
 
Join Date: Feb 2006
Location: Netherlands
Posts: 36
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

the whole thread (5 pages) is about this stuff.

you might want to read before you ask...


PS still have not got it working. figured out that the error message returns an array of possible write locations, separated by colons. Whatever I put into the 'dump to' path, the paths shown in the error message remain the same.
the array is as follows.

Quote:
Warning: is_file() [function.is-file]: open_basedir restriction in effect. File(/my/correctly/set/path/incl/writeable/chmod) is not within the allowed path(s): (/tmp:/home/xirictrl/hosted/www/[my_account_dirs]:/usr/lib/php:/var/xirictrl/hosted/www/[my_account_dirs]) in /includes/mysqlbackup.php on line 225
I don't really think these dirs are hardcoded into the php configuration, so somewhere between php input and file output, things just go wrong...

[edit]weird thing is that the adminCP backup function works like a charm. file gets written to the root nicely (mind you, the root is in the array above! perhaps it would work if the cronbackup would try to save the files to my document root?)[/edit]
Reply With Quote
  #251  
Old 03-29-2007, 11:38 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

open_basdir is a php setting that restricts what folders you webserver can write to - you need to speak to your host about that.
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 01:23 AM.


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.11112 seconds
  • Memory Usage 2,321KB
  • 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
  • (7)bbcode_php
  • (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
  • (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