Automated database backup

[mooneyn]

Hi,

More of less worked it out myself. Here is my code, everyone free to use / reuse / comment as they feel fit.

Most of it is inspiried by DrByte, so cheers to him.

<?php

// Change these to suit your location
$location = '/usr/home/XXXXXX/www/htdocs/XXXXadmin/';
$toolfilename = '/usr/local/bin/mysqldump';
$gzipfilename = '/usr/bin/gzip';

require($location . 'includes/configure.php');

$output = DIR_FS_ADMIN . 'backup.log';
$dump_results = DIR_FS_ADMIN . 'backup-dump.log';
$backup_file = 'db_' . DB_DATABASE . '-' . date('YmdHis') . '.sql';
$dump_params = ' "--host=' . DB_SERVER . '"';
$dump_params .= ' "--user=' . DB_SERVER_USERNAME . '"';
$dump_params .= ' "--password=' . DB_SERVER_PASSWORD . '"';
$dump_params .= ' --opt';
$dump_params .= ' --complete-insert';
$dump_params .= ' "--result-file=' . DIR_FS_BACKUP . $backup_file . '"';
$dump_params .= ' ' . DB_DATABASE;
$dump_params .= " 2>&1";

exec($toolfilename . $dump_params , $output);
exec($gzipfilename . ' ' . DIR_FS_BACKUP . $backup_file, $output);

?>