Website Backup To Amazon S3 Storage (PHP Edition)

<?php
 
//to use this script
//1) Download S3.php from http://undesigned.org.za/2007/10/22/amazon-s3-php-class
//2) Place the S3.php file in the same folder as this script
//3) Adjust these variables accordingly
 
$access_key = '';
$secret_key = '';
$bucket = 'backups';
 
$site_name = 'mysite';
$site_directory = "/path/to/public_html";
 
$db_host= "localhost";
$db_user = "";
$db_pass= "";
$db_name= "";
 
$mail_on_error = TRUE;
$mail_to = "";
 
//4)call this script with curl or wget in a cron task
//curl --silent --compressed http://example.com/s3_backup.php?key=trc_2011
//-or-
//wget -O - -q -t 1 http://www.example.com/s3_backup.php?key=trc_2011
 
//little bit o' security so script cannot be misused
if($_GET['key'] == 'trc_2011'){
 
  set_time_limit(300);
 
  require 'S3.php';
 
  try{
    $s3 = new S3($access_key, $secret_key);
    $s3->putBucket($bucket, S3::ACL_PRIVATE);
 
    //get current dir
    $cwd = getcwd();
 
    //create database dump
    echo "Creating database backup...<br/>";
    flush();
    $db_backup_file = $cwd.'/'.$site_name.'.sql';
    exec("mysqldump --add-drop-table --user=$db_user --password=$db_pass --host=$db_host $db_name > $db_backup_file");
 
    //store it
    echo "Uploading database backup...<br/>";
    flush();
    $s3->putObjectFile($db_backup_file, $bucket, $site_name.'/'.$site_name.'.sql', S3::ACL_PRIVATE);
 
    //delete it
    unlink($db_backup_file);
 
    //create filesystem backup
    echo "Creating filesystem backup...<br/>";
    flush();
    $fs_backup_file = $cwd.'/'.$site_name.'.tgz';
 
    //change to site directory so .tgz will have correct paths when extracted
    chdir($site_directory);
 
    //create backup
    exec("tar -czf $fs_backup_file *");
 
    //change back to original directory
    chdir($cwd);
 
    //store it
    echo "Uploading filesystem backup...<br/>";
    flush();
    $s3->putObjectFile($fs_backup_file, $bucket, $site_name.'/'.$site_name.'.tgz', S3::ACL_PRIVATE);
 
    //delete it
    unlink($fs_backup_file);
 
    echo "Backup Complete";
  }
  catch(Exception $e){
    echo $e->getMessage();
    if($mail_on_error){
      $subject = "Site Backup Script Error - ".$site_name;
      $body = "S3 Site Backup Script Failed : ".$e->getMessage();
      mail($mail_to, $subject, $body);
    }
  }
 
}
 
?>