MySql Yedek Alma Dosyası

define('DB_HOST', 'localhost');
define('DB_NAME', 'veritabani_adi');
define('DB_USER', 'veritabani_kullaniciadi');
define('DB_PASSWORD', 'parola');
define('BACKUP_SAVE_TO', 'yedek_alinacak_dizin');
 
$time = time();
$day = date('j', $time);
if ($day == 1) {
$date = date('Y-m-d', $time);
} else {
$date = $day;
}
 
$backupFile = BACKUP_SAVE_TO . '/' . DB_NAME . '_' . $date . '.gz';
if (file_exists($backupFile)) {
unlink($backupFile);
}
$command = 'mysqldump --opt -h ' . DB_HOST . ' -u ' . DB_USER . ' -p\'' . DB_PASSWORD . '\' ' . DB_NAME . ' | gzip > ' . $backupFile;
system($command);