mysqldump help

[qadeer_ahmad]

i am trying to get backup of database with mysqldump i tries

$dbhost="localhost";
$dbuser="root";
$dbpass="123";
$dbname="vshare_db";
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname);

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

also i try this

$create_backup = exec("mysqldump --opt --host=localhost --user=root--password=123 vshare_db > backup.sql");

and

$command = "C:\\mysql\\bin\\mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname | gzip > $backupFile";
system($command);

all the command create files what i name but empty files.

currently i am working in xxamp(php5) with winxp.

Please help.

[illzz]

In the first and third examples, remove the space between the [-p] and the password. The way you have it, you will be prompted for a password and then attempt to dump the databases [123] and [vshare_db]. And if no password is supplied, you get an access denied error in STDERR and nothing in STDOUT resulting in the empty file you see.

From the mysqldump man page:

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

For the second example, you need a space between root and --password.