Gaétan Collaud

<?php
 
set_time_limit(0);
$deb = microtime(true);
echo "start backup\n";
 
$servers = array(
	1 => array('monftp.mondomaine.me', 'myFTPUser', 'myFTPPass', '/myBackupDir'),
	2 => array('nestle.com', 'george', 'clonney', './nespresso'),
);
 
// name => array(local dir, array(server1, server2, ...))
$backupDir = array(
	'configSys' => array('/etc/', array(1)),
	'syncany' => array('/var/www/syncany', array(1, 2)),
	'www' => array('/var/www', array(1))
);
 
// bdd name => array(server1, server2, ...)
// 'all' mean all databases
$backupMysql = array(
	'all' => array(1)
	'syncany' => array(2)
);
 
$TMP_DIR = '/var/tmp/'; // temp dir
$EMAIL = 'myEmailAddress'; //email address
$DAY = 30; //time to live of backup in days
 
$sql_host = 'localhost'; //mysql host
$sql_user = 'mySqlUser'; //mysql user
$sql_pass = 'mySqlPass'; //mysql pass
 
$errorMsg = "Errors list : \n\n";
$oneErr = false;
function addError($msg){
	global $errorMsg, $oneErr;
	$errorMsg .= "\t".$msg."\n";
	echo "ERROR : ".$msg."\n";
	$oneErr = true;
}
 
$infosMsg = "Infos list : \n\n";
function addMsg($msg){
	global $infosMsg;
	$infosMsg .= "\t".$msg."\n";
	echo $msg."\n";
}
 
$now = date('Y-m-d');
 
//localdir backup
foreach($backupDir as $name => $backup){
	$dir = $backup[0];
	addMsg("Backup of local dir : '$dir'");
	$file = "file-$name-$now.tar.gz";
	exec("tar -zcvf $TMP_DIR/$file $dir");//compression
 
	foreach($backup[1] as $srvID){
		$srv = $servers[$srvID];
		addMsg("\ttry to send to : ".$srv[0]);
		$conn = ftp_connect($srv[0], 21) or addError('Cannot connect to '.$srv[0]);
		ftp_login($conn, $srv[1], $srv[2]) or addError('Cannot login to '.$srv[0]);
		ftp_put($conn, $srv[3]."/".$file, "$TMP_DIR/$file", FTP_BINARY);
		ftp_close($conn);
	}
	exec("rm $TMP_DIR/$file");
}
addMsg("");
 
//backup of database
$listDB;
exec("mysql -u $sql_user -h $sql_host -p$sql_pass -Bse 'show databases'", $listDB);
 
foreach($backupMysql as $name=> $listSrv){
	addMsg("backup of bdd : $name");
	$list = $name == 'all' ? $listDB : array($name);
	$listFile = array();
	foreach($list as $db){
		if($db == 'information_schema') continue;
		$file = "mysql-$db-$now.gz";
		$listFile[] = $file;
		exec("mysqldump -u $sql_user -h $sql_host -p$sql_pass $db | gzip -9 > $TMP_DIR/$file");
	}
 
	foreach($listSrv as $srvID){
		$srv = $servers[$srvID];
		addMsg("\ttry to send to ".$srv[0]);
		$conn = ftp_connect($srv[0], 21) or addError('Cannot connect to '.$srv[0]);
		ftp_login($conn, $srv[1], $srv[2]) or addError('Cannot login to '.$srv[0]);
		foreach($listFile as $file){
			ftp_put($conn, $srv[3]."/".$file, "$TMP_DIR/$file", FTP_BINARY);
		}
		ftp_close($conn);
	}
 
	foreach($listFile as $file)
	exec("rm $TMP_DIR/$file");
}
 
//remove old backups
foreach($servers as $srv){
	addMsg("Delete of old file on : ".$srv[0]);
	$conn = ftp_connect($srv[0], 21) or addError('Cannot connect to '.$srv[0]);
	ftp_login($conn, $srv[1], $srv[2]) or addError('Cannot login to '.$srv[0]);
	ftp_chdir($conn, $srv[3]);
	foreach(ftp_nlist($conn, '') as $file){
		$delta = (time()-ftp_mdtm($conn, $file))/(3600*24);
		if($delta>$DAY){
			ftp_delete($conn, $file);
			addMsg("\t $file");
		}
	}
	ftp_close($conn);
}
 
addMsg("\nBackup done in :".(round(microtime(true)-$deb))."sec");
$titre = $oneErr ? "[ERREUR] " : "";
$titre .= "Backup ".exec("hostname");
mail($EMAIL, $titre, $infosMsg."\n\n".$errorMsg);
?>