vb.org Archive - Administrative and Maintenance Tools

Page 5 of 45

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Administrative and Maintenance Tools - vB Database Backup (Lite) (https://vborg.vbsupport.ru/showthread.php?t=201319)

Nadeemjp

01-21-2009 11:39 PM

*uninstalled*

starli

01-22-2009 08:16 AM

-fixed- ^^

Yonatan

01-26-2009 04:53 PM

I edit "mysqlbackupconfig.php" - to:

PHP Code:


		
			
<?php
/*
<!-- $Header: d:\cvs/3.8/Auto-backup/includes/mysqlbackupconfig.php,v 1.1 2008/10/05 15:33:17 pem Exp $ -->
Auto-Backup (Lite) for vBulletin 3.8 - Paul M - v 3.8.001
This lite version is adapted from the original 3.0.x version by Trigunflame.
*/
// ---------- Main Options, alter these to suit your set-up ----------//
  // Combine all tables into one backup file
  $backup['COMBINE'] = 1;  // 0 = No, 1 = Yes
  // Close Forum during Backup (not recommended)
  $backup['SHUTDOWN'] = 0;  // 0 = No, 1 = Yes
  $backup['MESSAGE'] = "The Forum is closed because a database backup is in progress.";
  // File Saving Information
  $backup['DATE'] = 'Y-M-d';  // Backup file date format (See http://uk.php.net/date)
  $backup['PREFIX'] = 'Forum-';  // Backup file prefix, applied to all files
  $backup['DUMP_PATH'] = './backups/';  // Path to backups folder, must have a trailing slash, folder must be writable.
 
// ---------- Other Options, do not alter unless you understand what you are doing ----------//
  // Backup Options 
  $backup['LOCK'] = 0; // Lock Tables during dump 
  $backup['REPAIR'] = 1; // Repair & Optimize Tables before dump
  // Backup Type To Use
  $backup['TYPE'] = 2; // 1 = Only Specified Tables, 2 = All except Specified Tables
  $backup['TABLES'] = array(); // Table List - e.g. array('table1', 'table2')
  // Backup Optimizations 
  $backup['INNODB'] = 0; // Set to 1 if you have Innodb Tables 
  // Execution Function 
  $backup['COMMAND'] = 'exec'; // exec, system or passthru
?>

and i change "CHMOD" to "backups" folder to "0777" - and i still get this error:

Quote:

An error occured during the Backup : Could not open Destination SQL file for writing.

help please,
yonatan :)

nectons

01-27-2009 12:27 AM

Hi Paul.

It works perfect 2 weeks now without any problem. I have an accident yesterday and i decide to make a restore. Everething worked perfect. ONLY one problem. All my styles messed up.. lost backgrounds, buttons.. everething. I didnt know why.

But.. after a rebuilt style in meintanance all my styles worked again perfect. Is this a problem? Should i have to worry for anything?... I lost many threads/posts and about 50 new registered users.. I dont want to loose more.

Please help me.

And another one question. Is anything i can do to take backup every 3 or 6 hours? Or.. is it possible to takes backups every one hour BUT to delete backups older than 2 days for example? I found if i choose asterisk at month/week/day and choose asterisk at a hour it takes backups every one hour.

But its gonna full the space at my server and maybe it is heavy too.. Can you please tel me if anyway to take backups every 3 or 6 hours or like i said even more frequently at 1 hour but i don have to delete anything my self ?... I mean to somehow the cron to delete backups older than 2 days?

yingzhou

01-28-2009 11:18 AM

Quote:

Originally Posted by Yonatan (Post 1725377)

I edit "mysqlbackupconfig.php" - to:

PHP Code:


		
			
<?php

/*

<!-- $Header: d:\cvs/3.8/Auto-backup/includes/mysqlbackupconfig.php,v 1.1 2008/10/05 15:33:17 pem Exp $ -->

Auto-Backup (Lite) for vBulletin 3.8 - Paul M - v 3.8.001

This lite version is adapted from the original 3.0.x version by Trigunflame.

*/

// ---------- Main Options, alter these to suit your set-up ----------//

  // Combine all tables into one backup file

  $backup['COMBINE'] = 1;  // 0 = No, 1 = Yes

  // Close Forum during Backup (not recommended)

  $backup['SHUTDOWN'] = 0;  // 0 = No, 1 = Yes

  $backup['MESSAGE'] = "The Forum is closed because a database backup is in progress.";

  // File Saving Information

  $backup['DATE'] = 'Y-M-d';  // Backup file date format (See http://uk.php.net/date)

  $backup['PREFIX'] = 'Forum-';  // Backup file prefix, applied to all files

  $backup['DUMP_PATH'] = './backups/';  // Path to backups folder, must have a trailing slash, folder must be writable.



// ---------- Other Options, do not alter unless you understand what you are doing ----------//

  // Backup Options 

  $backup['LOCK'] = 0; // Lock Tables during dump 

  $backup['REPAIR'] = 1; // Repair & Optimize Tables before dump

  // Backup Type To Use

  $backup['TYPE'] = 2; // 1 = Only Specified Tables, 2 = All except Specified Tables

  $backup['TABLES'] = array(); // Table List - e.g. array('table1', 'table2')

  // Backup Optimizations 

  $backup['INNODB'] = 0; // Set to 1 if you have Innodb Tables 

  // Execution Function 

  $backup['COMMAND'] = 'exec'; // exec, system or passthru

?>

and i change "CHMOD" to "backup" folder to "0777" - and i still get this error:

help please,
yonatan :)

you must creat a folder name: $backup['DUMP_PATH'] = './backups/

not backup. :D

Yonatan

01-28-2009 11:24 AM

Quote:

Originally Posted by yingzhou (Post 1727097)

you must creat a folder name: $backup['DUMP_PATH'] = './backups/

not backup. :D

Oops :S
by mistake i wirte "backup" instead of "backups".
but, in backups folder. it's make folders(like: 2009-Jan-28 and etc), but not sql files.

Lautaro

01-29-2009 07:56 AM

I have a few questions about this modification:

1.- How do I secure the 'backups' folder?? ( CHMOD settings )
- is this a good configuration of it?
https://vborg.vbsupport.ru/attachmen...1&d=1233222781

2.- Where do i change the time when I want the backup to be made?

3.- Is there any way to make the backups path outside the public_html folder?
when saying outsite public_html i mean here:
https://vborg.vbsupport.ru/attachmen...1&d=1233222781
making a folder there called backups..
if yes, how will the backup path be?
my forum is located here: '/public_html/forum'

Thats all.

FCDobbs

01-29-2009 02:47 PM

Paul, thank you for this mod.
It is working fine for me.

One issue I have is with the number of backups being taken/stored (1 per day).
After a few weeks, my site hosting company is going to start charging me
for the extra disk space I am using.

I know you have no plans to modify this Mod and I don't expect you to.

But could you advise as to how I might be able to set up a CRON job to delete folders which are more than 7 days old ?

Thanks

JonUrban

01-30-2009 12:59 AM

Dumb question 101:

I installed the product, followed the directions. However, I am not sure how to

4. Alter the timing of the cron job to suit.

I'm not a real web expert, just a plodder. Can someone point me in the right direction?

THANKS

Yonatan

01-30-2009 05:14 AM

Quote:

Originally Posted by JonUrban (Post 1728640)

Go to ACP -> Scheduled Tasks -> Scheduled Task Manager - Now edit "Automatic Database Backup for vBulletin 3.8" and save!

Good luck ;)

All times are GMT. The time now is 07:17 AM.

Page 5 of 45

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01417 seconds Memory Usage 1,773KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: