MySQL Backup Script

backup-mysql.php

<?php
function backup($database, $path) {
    if (!file_exists($path)) {
        mkdir($path);
    }
    if (!is_dir($path)) {
        echo 'Could not create directory: ' . $path . PHP_EOL;
        return;
    }
    file_put_contents("$path/$database.timestamp", date('Y-m-d H:i:s'));
    echo "Dumping schema for $database to $path/$database.schema.sql" . PHP_EOL;
    echo `mysqldump --no-data --routines --add-drop-database $database > $path/$database.schema.sql`;
    echo PHP_EOL;
    echo "Dumping data for $database to $path/$database.data.sql" . PHP_EOL;
    echo `mysqldump --no-create-info --hex-blob $database > $path/$database.data.sql`;
    echo PHP_EOL;
}
backup('DB_NAME_1', '/var/deployments/www.SITE_URL_1.co.nz/backups');
backup('DB_NAME_2', '/var/deployments/www.SITE_URL_2.co.nz/backups');
backup('DB_NAME_ETC', '/var/deployments/www.SITE_URL_ETC.co.nz/backups');