PHP Script for mysql backup

[lexer]

Hi

I've a php script for making a mysql db backup, I can browse a folder where to save the backup (it works), I want to change the code for saving the backup on a webserver folder example:

c:\backup

This is my code:

<?php
//Current Date
$date_month = date('m');
$date_year = date('Y');
$date_day = date('d');
$Date = "$date_year-$date_month-$date_day";

//File Name
$filename = "mydb_$Date.sql";

//My DB
$user = "root";
$passwd = "xpass";
$db = "users";

header("Pragma: no-cache");
header("Expires: 0");
header("Content-Transfer-Encoding: binary");
header("Content-type: application/force-download");
header("Content-Disposition: attachment; filename=$filename");


//Make the backup
$execute = "c:\wamp\bin\mysql\mysql5.0.51a\bin\mysqldump.exe -u $user --password=$passwd --opt $db";
system($execute, $result);

if ($result) { echo "<H1>Error on: $execute</H1>\n"; }

?>

Any Ideas?

Thanks!!!

 

[jpadie]

something like this?

$execute = "c:\wamp\bin\mysql\mysql5.0.51a\bin\mysqldump.exe -u $user --password=$passwd --opt $db [red]c:\mydatabase.db[/red]";
system($execute, $result);

make sure that the relevant directory is writable by the php process

 

[lexer]

Thanks jpadie

The below code works fine:

<?php
//Current Date
$date_month = date('m');
$date_year = date('Y');
$date_day = date('d');
$Date = "$date_year-$date_month-$date_day";

//My BD
$user = "root";
$passwd = "mysq1";
$bd = "users";

//Make the backup
$execute = "c:\wamp\bin\mysql\mysql5.0.51a\bin\mysqldump.exe -u $user --password=$passwd --opt $bd > c:\backup\mydb_$Date.sql.sql";
system($execute, $result);



if ($result) { 
echo "<H1>Error on: $execute</H1>\n"; }
else { 
echo "Backup Ready: ". $Date; }

?>

 

[feherke]

Hi

$date_month = date('m');
$date_year = date('Y');
$date_day = date('d');
$Date = "$date_year-$date_month-$date_day";

Why not just one [tt]date()[/tt] call ?

[navy]$Date[/navy] [teal]=[/teal] [COLOR=darkgoldenrod]date[/color][teal]([/teal][green][i]'Y-m-d'[/i][/green][teal]);[/teal]

Feherke.

http://rootshell.be/~feherke/