php script to backup a mysql database

[cleary1981]

Hi,

 

Does anyone know of a good script i could use to backup my database. Im using windows and I want to back my db up locally but I want the script to run say once a week. Any pointers are much appreciated. I found this script but cant get it to work properly.

 

<?php


$backupFile = 'c:\backup\backup_';
$tableName  = 'supplier';
$dbname = 'tes';
$dbhost = 'localhost';
$dbuser = 'admin';
$dbpass = 'password';

$backupFile = $dbname . date("Y-m-d-H-i-s") . '.gz';
$command = "mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname | gzip > $backupFile";
system($command);


?> 

[Mchl]

Personally I use MySQL admin from MySQL GUI Tools. Lets you schedule regular backups. Only thing is, it's not compatible with mysqldump. so you have to restore through MySQL admin as well.