<?php

// mySQL backup & mail v1.02
// created by: Justin O. Kirk
// 
// copyrighted © 2001-2002 Justin Kirk

// Enhancements added by: King of Fools
// 
// http://www.king-of-fools.com
// October, 2003
// { Added compression option }
// { Added datestamp option }


// Run Script As:
// php -q /home/yourusername/locationofscript/backup_db.php 
//
// * Must be run using ssh or cron
// * Browser execution will fail
// * Take appropriate security precautions
// (Your DB Password is in this file)


//*** BEGIN variables ***//

// Backup Time Variables
  $backupdate = date("F j, Y");
  $backuptime = date("H:i");

//*** Edit Below ***//

// ==========================
// MySQL DATABASE INFORMATION
// ==========================

  // database host: (blank if localhost)
  $dbhost = '';
  
  // name of the database:
  $database = 'dbname';   
  
  // username with db access:
  $username = 'dbuser';
  
  // password for username:
  $password = 'dbpassword';

// ==============================
// BACKUP FILENAME & LOCATION
// ==============================

  // filename for the backup: (no extension)
  $backupas = "mysql";
  
  // absolute path to backup destination: (no trailing slash)
  $backupto = '/home/username/tmp';

// ===================
// E-MAIL INFORMATION:
// ===================

  // who the mail is from.
  $mailname = 'autobackup';
  
  // reply address (not needed)
  $mailfrom = '';
  
  // email address to send the database to.
  $mailto = 'you@yourdomain.com';
  
  // subject of email.
  $subject = "MySQL Backup - $backupdate";
  
  // message body.
  $message = "Backup Created at $backuptime on $backdate:";

// ========
// OPTIONS:
// ========

  $send_email       = '1';
  // 1=send backup copy via e-mail.     0= backup data, don't e-mail.
  
  $delete_local     = '1';
  // 1=delete local copy when done.     0=leave local copy when done.
  
  $compress_archive = '1';
  // 1=compress archive file with gzip. 0=I like large emails.
  
  $date_stamp       = '1';
  // 1=add datestamp to archive file.   0=Always use same backup name

//*** END of variables. ***//

//*************************************//
//*** Do Not Edit Beyond This Point ***//
//*************************************//
// Resolve Archive Target:
  if ($date_stamp) { $backupas = $backupas.'_'.date("Ymd"); }
  $backupfile = $backupas.'.sql';

// Call Functions
  backupdb();
  if ($compress_archive) { compressdb(); }
  if ($send_email)       { makeandsend(); }
  if ($delete_local)     { removedb(); }


// Functions
function backupdb() {
  global $dbhost,$username,$password,$database,$backupto,$backupfile;
  if($dbhost == "") {
    $backupcommand = "mysqldump -u$username -p$password $database >$backupto/$backupfile";
  } else {
    $backupcommand = "mysqldump -h$dbhost  -u$username -p$password $database >$backupto/$backupfile";
  }
  passthru ("$backupcommand", $error);
  if($error) { echo ("Dump Problem: $errorn"); exit;}
}

function compressdb() {
  global $backupto,$backupfile;
  $compresscmd = "cd $backupto; gzip -f $backupfile";
  passthru ("$compresscmd", $error);
  if($error) { echo ("GZip Problem: $errorn"); exit; }
  $backupfile = $backupfile.'.gz';
}

function removedb() {
  global $backupto,$backupfile;
  if(!unlink("$backupto/$backupfile")) { echo ("Cannot Remove $backupto/$backupas"); exit;}
}

function makeandsend() {
  global $backupto,$backupfile,$message,$mailto,$subject,$mailname,$mailfrom,$database;
  $mail_boundary = '--=nextpart_' . md5(uniqid(time()));
  $mail_head = "From: $mailnamernReply-to: $mailfromrn";
  $mail_head .= "MIME-Version: 1.0rn";
  $mail_head .= "Content-type: multipart/mixed; boundary="$mail_boundary"";
  $mail_head .= "rnrn";
  $mail_head .= "This is a multi-part message in MIME format.";
  $mail_head .= "rnrn";

  $db_file = $backupto.'/'.$backupfile;
  $fp = fopen($db_file, "r");
  $file = fread($fp, filesize($db_file));
  $file = chunk_split(base64_encode($file));

  $mail_body = "--$mail_boundaryrn";
  $mail_body .= "Content-type: text/plain; charset=us-asciirn";
  $mail_body .= "Content-transfer-encoding: 8bitrnrn";
  $mail_body .= " $messagern";
  $mail_body .= "--$mail_boundaryrn";

  $filename = basename($db_file);

  $mail_body .= "Content-type: application/octet-stream; name="$filename"rn";
  $mail_body .= "Content-transfer-encoding:base64rn";
  $mail_body .= "Content-Disposition: attachment; filename="$filename"rnrn";
  $mail_body .= $file. "rnrn";
  $mail_body .= "--$mail_boundary--";

  mail($mailto, $subject, $mail_body, $mail_head);
}

?>