MySQL Backup

[foxden]

Can anyone see what I'm doing wrong here?

$db_backup8 = "/usr/bin/./mysqldump -u username -ppassword -h db_name.mydomain.com>/home/mydomain/db_dump.sql.NOW";

$sql_dump_result = exec($db_backup8);

This does NOT work with a PHP script, but functions fine from the command line...

Thanks

[[deleted]]

'does noty work' means you get an error or what?

[foxden]

I was getting what appeared to be the results of a mysqldump --help. That is fixed now, but of course I want more out of it. I'm trying to tar the string into a file. And I'm getting a permission denied. Here is a snipet of the added code:

$create = "touch /dir/backup.txt";
$fp = fopen("/dir/backup.txt","w");
$file_stuff = "fwrite($fp, $sql_dump_result)";

$sql_dump_result1 = shell_exec($create);

$sql_dump_result2 = shell_exec($file_stuff);

[tasistro]

Who owns mysqldump and what group does it belong to?

Apache(HTTPD) could not have rights to run it.

Saludos
Gerardo

[jburfield]

Josh wrote:

Can anyone see what I'm doing wrong here?

$db_backup8 = "/usr/bin/./mysqldump -u username -ppassword -h db_name.mydomain.com>/home/mydomain/db_dump.sql.NOW";

Yeah, you aren't telling it what to back up for starters.

Try:
/usr/bin/./mysqldump -u username -ppassword -h db_name.mydomain.com DATABASE_NAME > /home/mydomain/db_dump.sql

-- Jason