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]

Thats a mysql error, that basically means something tried to update the table after you locked it. Personally i wouldnt use the lock functionality, but if you do, you will most likely get errors if you leave your forum open.

[SpyCam]

Can you give me an example of configuration that would work for sure?

With the following one i still get "Automatic Database Backup for vBulletin 3.7. An error occured during the Backup : Could not open Destination SQL file for writing." error:

<?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'] = 0; // Lock Tables during dump 
  $backup['REPAIR']	= 0; // 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

?>

[SpyCam]

No solution?

[Paul M]

The error is down to your server permissions, I cannot provide answers for individual servers.

[CheeSie]

I love this script, but it cant handle my 1.3gb database!

But it always stops when processing my post table

Is there a way I can prevent it from timing out?
.. Or somehow make it do one table at a time?

[Paul M]

It does one table at a time.

My database is bigger than that, and works fine.

[steven s]

I get Internal Server Error after the script runs 1/4 of the way.
I do not suspect it is a problem with the mod as I have been getting this error with other auto backup scripts.

My file is ~440Mb.
What should I be asking my provider to change?

[Paul M]

No idea, "Internal Error" is a pretty meaningless generic message, you need a more specific message.

[GoTTi]

hey paul, ive been using this mod for a long time, and running into a problem...

it turns the forum off, but doesnt turn it back on after it is done backing up. what should i do? reinstall the mod?

[Paul M]

Disable that option, its always been unreliable.