Administrative and Maintenance Tools - vB Database Backup

This modification is no longer available or supported.

Note: Because I did not write the original version, but rather have modified & adapted it, support of this modification may be limited

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 and now for vb3.7.

The original version was by Trigunflame and the rights to the code were bought by Zoints (D.Chapman) in January. 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.

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 backup functionality on 3.7.


History:

v3.7.001 : First version for vB 3.7.

[Paul M]

Set up a second scheduled task.

[Markos]

Originally Posted by Paul M

Set up a second scheduled task.

ok thanks will try that lol

[Markos]

hi Paul see the way i have this set now does it mean that will run every 6 hours...?

[Paul M]

Eh ? I dont know how you have it set-up.

[Markos]

well if u look at the pic it has hours set to 6 so does that mean it will run every 6 hours or 6 oclock every day

[Paul M]

Viewing the post at work, the picture was not visible, must be hosted somewhere that is blocked. It means it will run at 6 every day.

[Markos]

Originally Posted by Paul M

Viewing the post at work, the picture was not visible, must be hosted somewhere that is blocked. It means it will run at 6 every day.

thanks

[SpyCam]

Hello,
i'm having problems with this mod.

When i have these settings:

// Backup Options 
$backup['LOCK'] = 1; // Lock Tables during dump 
$backup['REPAIR']	= 1; // Repair & Optimize Tables before dump

I get this error:
Automatic Database Backup for vBulletin 3.7
An error occured during the Backup : Could not open Destination SQL file for writing

When i have these settings:

// Backup Options 
$backup['LOCK'] = 0; // Lock Tables during dump 
$backup['REPAIR']	= 0; // Repair & Optimize Tables before dump

I get this error (white page with DB error stuff):
MySQL Error : Table 'datastore' was locked with a READ lock and can't be updated
Error Number : 1099

This is my config file contents:

<?php
/*
<!-- $Header: d:\cvs/3.7/Auto-backup/includes/mysqlbackupconfig.php,v 3.2 2008/01/06 15:32:44 pem Exp $ -->

Auto-Backup (Lite) for vBulletin 3.7 - Paul M - v 3.7.001
This lite version is adapted from the original 3.0 version by Trigunflame.
*/

  // Combine all tables into one file
  $backup['COMBINE'] = 1;  // 0 = No, 1 = Yes

  // Close Forum during Backup
  $backup['SHUTDOWN'] = 1;  // 0 = No, 1 = Yes
  $backup['MESSAGE'] = "Forumas yra laikinai isjungtas, nes yra daroma atsargine duombazes kopija.";

  // File Saving Information
  $backup['DATE'] = 'Y-M-d';  // Backup file date format (See http://uk.php.net/date)
  $backup['PREFIX']	= 'auto-';  // Backup file prefix, applied to all files
  $backup['DUMP_PATH']	= '../db_backups';  // Path to backups folder, must have a trailing slash

// -----------------------------------------------------------------------------------------------//

  // Backup Options 
  $backup['LOCK'] = 1; // 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

?>

[Paul M]

Read the notes carefully.

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

[SpyCam]

Yeah, i tried to remove the trailing slash to see if it helps and forgot to put it back

But it doesn't help anyways.

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

MySQL Error   : Table 'datastore' was locked with a READ lock and can't be updated
Error Number  : 1099