Administrative and Maintenance Tools - vB Database Backup (Lite)

As of 24 Nov 2017 this modification has been withdrawn.

Note: I did not write the original version, but rather have modified & adapted it.

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, first for vb 3.6, 3.7 and now for vb3.8.

The original version was by Trigunflame and the rights to the code were bought by Zoints (David Chapman) in January 2007. Later in 2007 David gave me permission to release my adaptation.

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.

As of version 3.8.002, most of the options have moved to the ACP in vBulletin Options >> vBulletin Automatic Backup

Notes:
* I will not be adding anything new to this modification.
* This is a Lite version to allow people to use the basic backup functionality on 3.8.


History:

v3.8.001 : First version for vB 3.8.
v3.8.002 : Moved most of options to ACP.
v3.8.003 : Moved more options to ACP.
v3.8.004 : Gzip option backported from vb4 version.
v3.8.005 : Split option backported from vb4 version, close option removed.
v3.8.006 : Fix php 5.3 deprecated warning.

[Nadeemjp]

*uninstalled*

[starli]

-fixed- ^^

[Yonatan]

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:

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

help please,
yonatan

[nectons]

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]

Originally Posted by Yonatan

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.

[Yonatan]

Originally Posted by yingzhou

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

not backup.

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]

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?


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:

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]

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]

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]

Originally Posted by JonUrban

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

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

Good luck