#!/usr/bin/php
<?php
	define("MYSQL_USERNAME", "backup");
	define("MYSQL_PASSWORD", "changeme");
	define("MYSQL_HOST", "localhost");

	define("MYSQLDUMP_OPTS", "--hex-blob --compatible=mysql40");

	define("BD_BACKUPS_DIR", "/backups/mysql/");
	
	$date = date("dmYHi");

	mysql_connect(MYSQL_HOST, MYSQL_USERNAME, MYSQL_PASSWORD);
	$db_list = mysql_list_dbs();
	echo "Backup started ". date("d-m-Y H:i a") . "\n";
	$total_dbs = 0;
	$total_errors = 0;
	while ($row = mysql_fetch_object($db_list)) {
		$db = $row->Database;
		$logname = BD_BACKUPS_DIR. "$db-$date.sql";
	    echo $logname;
	    /* dump the db */
	 	$ret = -100;
	 	$line = system("mysqldump --databases $db --host ". MYSQL_HOST ." --user ". MYSQL_USERNAME ." --password=". MYSQL_PASSWORD ." ". MYSQLDUMP_OPTS ." --result-file=$logname", $ret);
	 	if($ret != 0) {
	 		echo "\nError $logname $line\n";
	 		$total_errors++;
	 		continue;
	 	}
	 	/* sleep 2 seconds, we don't want to hug the CPU */	 	
	 	sleep(2);
	 	/* bzip2  it */
	 	$ret = -100;
	 	$line = system("bzip2 $logname --force -q --best", $ret);
	 	if($ret != 0) {
	 		echo "\nError $logname $line\n";
	 		$total_errors++;
	 		continue;
	 	}	 	
		$total_dbs++;	 	
	    echo "\n";
	}
	echo "Backup ended ". date("d-m-Y H:i a") . "\n";
	echo "Total Databases: $total_dbs\n";
	echo "Total Errors: $total_errors\n\n";
?>