MySQL Database Backup

[systech44]

I wish to restore the data of tables of my database into Excel(.xls) or any other format. Below is my code.

 

<?php

mysql_connect("localhost","root","");
mysql_select_db("test");

$dbname    = "test";
$dbhost	= "localhost";
$dbuser	= "root";
$dbpass	= "";
$backupFile	= "restore";

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

?>

 

There is no error. But I cannot see the output. Please tell me what is wrong with my code. Please rectify.

 

My environment is as below:

Windows XP

WampServer

 

Thanks a lot in advance.

[oni-kun]

Note: When safe mode is enabled' date=' you can only execute files within the safe_mode_exec_dir. For practical reasons, it is currently not allowed to have ".." components in the path to the executable.[/quote']

 

With safe mode enabled' date=' the command string is escaped with escapeshellcmd(). Thus, echo y | echo x becomes echo y \| echo x.[/quote']

[systech44]

Thanks for the reply. But I will be obliged if you please elaborate this matter. Also please try to modify the code, if possible. Thanks you once again.