PHP5 Anyone see what I'm doing wrong in this small script ... am crying at the moment

[Jethro]

<?php

$dbhost = 'host';
$dbuser = 'user';
$dbpass = 'password';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'database';
mysql_select_db($dbname) or die ("Database Selection Wrong");

$backupfile = "holycowitsdata.sql";
$command = "mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname | gzip > $backupfile";
//echo($command);
system($command);

mysql_close($conn);

echo("done and dusted");
?>

It's generating the backupfile but is not actually dumping any data to it ....

 

[anotheralias]

I can't help you obviously, but ... been there, so I Liked you since I can't hand you a shot of bourbon or something. (Or the whole bottle.)

 

[SchmitzIT]

Have you tried manually running the string generated by echo($command) from a shell window?

 

[Shadab]

You have a space between -p and your password ($dbpass).

Format: --password[=password], -p[password]

The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the option and the password.

Source: MySQL 5.1 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program

 

[Elizabeth]

You have a space between -p and your password ($dbpass).

It's the small things that will drive you crazy!

 

[g0rn]

By the way, you do not need to connect to the database from the php script, you only need to execute mysqldump command and it will connect and dump everything itself.

 

[Jethro]

You have a space between -p and your password ($dbpass).

Thanks dude, working like a charm

g0rn am opening the database to ensure I have the correct details as this small script is being run over multiple dbs for a full scale move. An open ensures I have the correct details each time it's run.