<?php
/**
 * A simple PHP script that performs a MYSQL backup and then moves or copies the to the Amazon S3 cloud.
 * Created by Keith Mander (keithmander.com). Feel free to tweak to your heart's content. Just please don't sell it.	
 */

if (!class_exists('S3')) require_once 'class.php'; // requires A3 class file (from: http://undesigned.org.za/2007/10/22/amazon-s3-php-class)

// AWS access info
if (!defined('awsAccessKey')) define('awsAccessKey', 'ACCESSKEY');
if (!defined('awsSecretKey')) define('awsSecretKey', 'SECRETKEY');

define("CLEANUP_TYPE", 1);		// 0 = none; 1 = remove latest backup file only; 2 = remove all files from backup directory

$bucketName = "BUCKETNAME";	// the script will create the bucket if it does not already exist
$dbHost = "HOSTNAME";	// usually just localhost
$dbUser = "USERNAME";
$dbPass = "PASSWORD";
$dbName = "DATABASENAMES";		// you can also backup two or more databases by simply separating their names with a space character
$backupDir = "/FULL/PATH/TO/TMP/DIRECTORY";  // a directory to store temporary backups before moving them to A3. Folder requires write access.
$backupPath = $backupDir."/".$dbName.date("Ymd").".gz";  // Here, we add the date to filenames in the format of eg. blog20081206.gz

// check for CURL
if (!extension_loaded('curl') && !@dl(PHP_SHLIB_SUFFIX == 'so' ? 'curl.so' : 'php_curl.dll')) {
	exit("ERROR: CURL extension not loaded".PHP_EOL);
}
// check the backup directory
if (!file_exists($backupDir)) {
	// creates the backup directory
	mkdir($backupDir);	
}
// backup the database
$cmd = "mysqldump --host=".$dbHost." --user=".$dbUser." --password=".$dbPass." ".$dbName." | gzip > ".$backupPath;
system($cmd);
if (!file_exists($backupPath)) {
	exit("ERROR: failed to create backup file!".PHP_EOL);
}
// instantiate the S3 manager
$s3 = new S3(awsAccessKey, awsSecretKey);
// check if the backup bucket already exists
$bucks = $s3->listBuckets();
$buckId = array_search($bucketName, $bucks);
if ($buckId<0) {
	// create the backup bucket
	if (!$s3->putBucket($bucketName, S3::ACL_PUBLIC_READ)) {
		exit("ERROR: failed to create backup bucket!".PHP_EOL);		
	}
}
// put the backup file into the bucket
if (!$s3->putObjectFile($backupPath, $bucketName, baseName($backupPath), S3::ACL_PUBLIC_READ)) {
	exit("ERROR: failed to put file '".$backupPath."' to backup bucket '".$bucketName."'".PHP_EOL);
}
// perform the cleanup, if needed
if (1==CLEANUP_TYPE) {
	// remove the backup file
	unlink($backupPath);
}
else if (2==CLEANUP_TYPE) {
	// clear the backup directory
	foreach(glob($backupDir.'/*') as $sf) {
        if (!is_dir($sf)) {
        	unlink($sf);
        }
    }
}
?>