mysql dump creates empty file

I've got this problem: I'm trying to backup a table from my database to
a .sql file. I'm running mysqldump command from php file, and the
result file is empty. Where's the problem?

Code:
include "settings.inc";
include "db.php";

global $dbase;
global $duser;
global $dpass;

DBConnect();

$backup = "mysqldump -h localhost -u $duser -p $dpass $dbase table_name
> backup/table_name.sql";
shell_exec($backup);

DBClose();
?>

Re: mysql dump creates empty file

vesakilp@gmail.com wrote:
> I've got this problem: I'm trying to backup a table from my database to
> a .sql file. I'm running mysqldump command from php file, and the
> result file is empty. Where's the problem?
>
> Code:
> > include "settings.inc";
> include "db.php";
>
> global $dbase;
> global $duser;
> global $dpass;
>
> DBConnect();
>
> $backup = "mysqldump -h localhost -u $duser -p $dpass $dbase table_name
>> backup/table_name.sql";
> shell_exec($backup);
>
> DBClose();
> ?>
>
In theory this should work, but change your shell_exec($backup); to


$error_message=shell_exec($backup);
echo "Command used: ".$backup."
\nOutput from command:
".$error_message."
\n";

in your script, and then you see how your command line looks like and what the
command does output. By the way, as you are using the mysqldump command, you
don't need to connect to the database in the php script.

At least in the mysql command you don't have spaces between -u and the
password, the same for -p too and most likely for the -h too.

$backup = "mysqldump -hlocalhost -u$duser -p$dpass $dbase table_name >
backup/table_name.sql";


//Aho

Re: mysql dump creates empty file

> In theory this should work, but change your shell_exec($backup); to
>
>
> $error_message=shell_exec($backup);
> echo "Command used: ".$backup."
\nOutput from command:
> ".$error_message."
\n";
>
> in your script, and then you see how your command line looks like and what the
> command does output. By the way, as you are using the mysqldump command, you
> don't need to connect to the database in the php script.
>
> At least in the mysql command you don't have spaces between -u and the
> password, the same for -p too and most likely for the -h too.
>
> $backup = "mysqldump -hlocalhost -u$duser -p$dpass $dbase table_name >
> backup/table_name.sql";
>
>
> //Aho

Well I did as told, and this was result:

Code:
include "settings.inc";

global $dbase;
global $duser;
global $dpass;

$backup = "mysqldump -hlocalhost -u$duser -p$dpass $dbase table >
backup/table.sql";
$error_message = shell_exec($backup);
echo "Command used: ".$backup."
\nOutput from command:
".$error_message."
\n";
?>

Error message:
Command used: mysqldump -hlocalhost -u -p