<?php
/**************************/
$db_server='localhost';
$db_name='name of your database';
$db_user='database username';
$db_pass='database password';
$fileprefix = "prefix for your backup files";
$backupfolder = "full system path to where the backups should be stored";
$archivefolder = "full system path to where weekly archives should be stored";
$cutoff = 86400*7; // we'll keep one week of backups. Change "7" to something else to store more days of backups.
$archivecutoff = 86400*14; // we'll keep two weeks of backups
/**************************/

/**** DON'T EDIT BELOW THIS LINE UNLESS YOU KNOW WHAT YOU'RE DOING *****/
set_time_limit(0);
$timestamp = date("mdY");

exec("/usr/local/bin/mysqldump -h".$db_server." -u".$db_user." -p".$db_pass." ".$db_name." > ".$backupfolder.$fileprefix."_".$timestamp.".sql");
exec("gzip ".$backupfolder.$fileprefix."_".$timestamp.".sql");

// each Saturday morning, move oldest backup into an archive
if (date("w")==6) {
	$oldstamp = date("mdY",mktime(0,0,0,date("n"),date("j")-6));
	//$oldstamp = "122305_afternoon";
	if (file_exists($backupfolder . $fileprefix ."_".$oldstamp.".sql.gz")) {
		copy($backupfolder . $fileprefix . "_".$oldstamp.".sql.gz",$archivefolder . $fileprefix . "_".$oldstamp.".sql.gz");
	}
}

// delete all backups of this database older than one week
if (is_dir($backupfolder)) {
	if ($dh = opendir($backupfolder)) {
		while (($file = readdir($dh)) !== false) {
       		if (ereg($fileprefix,$file) and (time()-$cutoff)>filemtime($backupfolder . $file)) {
       			@unlink($backupfolder . $file);
       			//echo "filename: $file";
       		}
		}
		closedir($dh);
	}
}

// delete all backups of this database older than two week
if (is_dir($archivefolder)) {
	if ($dh = opendir($archivefolder)) {
		while (($file = readdir($dh)) !== false) {
       		if (ereg($fileprefix,$file) and (time()-$archivecutoff)>filemtime($archivefolder . $file)) {
       			@unlink($archivefolder . $file);
       			//echo "filename: $file";
       		}
		}
		closedir($dh);
	}
}
?>