Datenbank Script - Datenbank auf Server automatisch anlegen lassen. Datenbank Sicherung per PHP / CRON

 

<?php
/**
*
* Database Backup
*
**/

// use this function if your script is running for long time
// and uncheck logging when you create the cron
ignore_user_abort();

// configuration
$host = 'localhost'; //must be edited
$username = 'username'; //must be edited
$password = 'password'; //must be edited
$database = 'database_name'; //must be edited
$path = '/home/myuser/backups/'; //must be edited


$filename = $database.'_'.date('Y-m-d_H:i:s').'.gz';
$backup = $path.$filename;

$backup_command = "mysqldump --opt -h $host -u $username -p$password $database | gzip > $backup";

if(exec($backup_command)=='' && file_exists($backup))
{
echo "Backup succesfuly created";
}
else
{
echo "Error creating backup";
}
?>