help with mysqldump

[foxden]

/usr/bin/./mysqldump -u db_name -pdb_password db_table

/home/my_dir/db_dump.sql

This works great from the command line, but when trying to execute as a shell command, system, or exec from within a PHP script it fails. Here is my PHP code:

$db_backup = "/usr/bin/./mysqldump -u db_name -pdb_password db_table

/home/my_dir/db_dump.sql";

$sql_dump_result = system($db_backup);

[kidestranged]

I'm not sure what the problem is but here's the way I do it.

$dump_command = "/usr/local/mysql/bin/mysqldump -u myusername -pmypassword databasename tablename > path/to/my/backup.txt";

$sql_dump_result = system($dump_command);

give it a shot.

[kidestranged]

the last part should read:

/path/to/my/backup.txt";
(absolute path)

[foxden]

I am receiving an error at line # xxx

xxx begins where $sql_dump_result = system($db_backup);

Any ideas?
I can't give the exact error, my host is down 🙁