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]

That is known to happen from time to time - the only answer is dont use that option. Its not necessary to close the board.

[Pavlus]

Ok but there is also another complication, now backup stops at some table and dont go forward. From 23mb of database only 6mb have been backuped :/

I didnt changed anything, forum stands on shared gosting, do you thing that admins could provide me with new restrictions? Maybe script gets timeouted?

[Angels1928]

Can someone reupload the file that was posted in the beginning of this thread, the one that finds the file's location in means of "home/root/public_html" or something like that? I need to change my "backup location".

edit--

Nevermind, found it elsewhere on the 'net. Here it is, reuploaded on here

[rockinaway]

I get this error:

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

What is wrong?

[pspmaster93]

heres what error it gives me when i go to scheduled tasks and try and run it

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

heres what i put for config

<?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'] = "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']	= 'warez-4u.com/backup/';  // Path to backups folder, must have a trailing slash

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

  // 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

?>

[Super Jinni]

Installed and works perfectly..

thanks Paul

[Paul M]

Originally Posted by pspmaster93

heres what error it gives me when i go to scheduled tasks and try and run it

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

heres what i put for config

Either the backup path is wrong, or your webserver does not have permission to write to it. If I were guessing, I would say the former.

[rockinaway]

I have checked the destination folder and chmodded the directory, yet I get the same error.. why?

[Paul M]

I cannot possibly answer that, security/permissions are server specific, speak to your host.

[Vinyljunky]

Paul,

Have you released a Pro version?

I'd like something that only keeps x backups etc....

Thanks

VinylJunky