I wish to restore the data of tables of my database into Excel(.xls) or any other format. Below is my code.
There is no error. But I cannot see the output. Please tell me what is wrong with my code. Please rectify.PHP 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);
?>
My environment is as below:
Windows XP
WampServer
Thanks a lot in advance.




Reply With Quote