back up mysql databases to dropbox

mysql_backup_to_dropbox.php

<?php

// https://github.com/jakajancar/DropboxUploader
require_once './DropboxUploader.php';

// dump mysql file
$myUser = 'root';
$myPass = 'root';
$myHost = 'localhost';
$myDbs  = array('db1', 'db2');
$destDir = './backup/';

$date = date('Ymd');
$files = array();
foreach ($myDbs as $v) {
	$file = $destDir.$v.'-'.$date.'.sql.gz';
	$files[] = $file;
	exec("/usr/bin/mysqldump -u $myUser -h $myHost -p$myPass --opt $v | /bin/gzip -9 > $file");
}

// upload
$dropUser = '[email protected]';
$dropPass = 'password';

$uploader = new DropboxUploader($dropUser, $dropPass);
foreach ($files as $v) {
	$uploader->upload($v);
	// unlink($v);
}