<?php

/*======================================
=            PHP MySQL Backup          =
======================================*/

if(function_exists('exec'))
{

	// Back-up folder
	$folder_to_backup = "/path/to/folder";
	$backup_folder = "/path/to/backup/folder";
	exec("tar -cvf $backup_folder/backupfile.gz $folder_to_backup/* --exclude='$folder_to_backup/*.gz'", $results, $result_value);
	if ($result_value == 0){
		echo "The archive has been successfully created!";
	} else {
		echo "Archive creation failed!";
	}

	// Back-up MySql database
	$mysql_host = "localhost";
	$mysql_user = "username";
	$mysql_pass = "password";
	$mysql_database = "my_database";
	$backup_folder = "/path/to/backup/folder";

	exec("mysqldump -h $mysql_host -u $mysql_user -p$mysql_pass $mysql_database  > $backup_folder/my-sql-backup.sql", $results, $result_value);
	if ($result_value == 0){
		echo "The MySql backup successfully created!";
	} else {
		echo "MySql backup creation failed!";
	}

}

/*=====  PHP MySQL Backup  ======*/

?>