Contributions

Changes:

Modified email function to widen server compatibility

Main Features of Database Backup Manager:

Better support for large databases
Existing Backup files can be compressed plus improved support for compression.
Selective Backups can be created (on a per table bases)
Selective Restores can be made (on a per table bases) given a compatible backup file (from this or Auto-Backup Database)
Database Backups can be emailed
Log files within the backup folder can be viewed or deleted
Backup file list can be sorted on name, date and size (ascending or descending).

This version is compatible with osC 2.3.x and below

Full Package

Removed phpMailer class due to excessive memory usage when emailing backups, email function now uses pear class or if that's un-available the standard php mail function.

This version is compatible with osC 2.3.x and below

Full Package

Modified layout for 2.3.x,
Moved & modified download function,
Added download(display) plus deletion of log files if found in folder,
added ability to email backup files,
Replaced any depreciated functions plus a few minor display modifications.

Log files are produced by Auto Backup Database ( http://addons.oscommerce.com/info/8374 ) which will create automatic backups periodically that are compatible with Database Backup Manager.

Added a bugfix for a bug found by stubbsy (code tried to remove an sql file that had already been gzip'ed).
Added some functionality to test if exec is a disabled function (used for gzip or zip using the server commands). In that case backup.php goes in "safe mode setting".
Moved the directory images in the package one level higher (erroneously put it in directory includes instead of on the same level, thanks to FIMBLE for catching that one).
Removed the large gzip'ed table (for testing) from the package. Download version 1.3 for that.

Added a bugfix for a too small read buffer when reading the table list in the head of the backup (thanks to Sam/spooks).
Changed two functions that generate the checkboxes to have a valid id in the HTML.
Added a large table (gzipped) to the package for people who want to test the new features but (still) have a small database.

In previous versions the database table structure of the table sessions and whos_online could and would not be added to a full backup of the database. This would result in an incomplete database if the backup was restored to an empty one. So this was added back.

There was an error in the restore function. When a backup was halted while reading the contents of a table that should not be restored, in the next pass the backup would start restoring the table where the reading stopped (so in the table that should not be restored, leading to errors about duplicate keys). That was fixed in this version.

Three files were changed:
admin/backup.php
admin/includes/functions/db_backup.php
admin/includes/languages/english/backup.php

Small change in admin/backup.php where the sorting of the contents of the backup directory would echo a warning: array_multisort() [function.array-multisort]: Argument #1 is expected to be an array or a sort flag in backup.php on line 1112
Now the sorting is wrapped in a statement that looks if there is anything to sort.

This contribution aims to get the database backup manager in osC 2.2 to work better with large databases especially on servers where safe_mode is set to on.

Support thread: http://forums.oscommerce.com/index.php?showtopic=293949