Backup database to S3 bucket

cron.php

<?php

$date = date("Y-m-dTH:i:s");
$file = 'db.backup.' . $date . '.sql.gz';

error_log("Database Backup Started - " . $file);

exec('touch ' . $file);
exec('chmod 600 ' . $file);
exec('mysqldump -u user --password="password" --add-drop-table --single-transaction database_name | gzip > ' . $file);
exec('aws s3 mv ' . $file . ' s3://cdn.domain.com/db-backups/ --region us-west-1 --endpoint-url http://s3.amazonaws.com --acl bucket-owner-full-control');

error_log("Database Backup Complete- " . $file);