mysqldump

[scuba]

I have been playing with mysqldump and have use a script like:

<?

include("dataincludes/connect.inc");

$sql_dump = "mysqldump -u root $Marketplace_International > dbbackup.sql";

$sql_dump_result = exec($sql_dump);

echo "
\n sql_dump_result is " . $sql_dump_result;

return $sql_dump;
}
?>

right now, it creates the dbbackup.sql file but it is empty. I tried the same command from the mysql server and it works fine but when used in my script it comes up blank.

any help would be great.

Steve

[Anon]

Is the variable $Marketplace_International set? Or was the dollar sign an accident?

Chris King

[scuba]

$ was an accident but it still doesn't work right now I have:

<?

include("dataincludes/connect.inc");

$sql_dump = "myslqdump --tab=(http://mydir) --fields-terminated-by=',' (mydatabase)";

$sql_dump_result = exec($sql_dump);

echo "
\n sql_dump_result is " . $sql_dump_result;

return $sql_dump;
}
?>

I tried this but what returns on screen is:
sql_dump_result is myslqdump --tab=(http://mydir) --fields-terminated-by=',' (mydatabase)

plus i don't see any files created.

[Anon]

Ah, well, I believe your problem lies here. The manual page here:

http://www.php.net/exec

Shows us that the result of the exec is returned to an array that is the second argument to exec. So try reworking that line to read:

exec($sql_dump, $sql_dump_result);
Also, make sure you use the -u<username> option for mysqldump to make sure you are connecting as the correct user that has permissions to dump the database. Hope that helps.

Chris King