brian wrote:
tedd wrote:
I was thinking that I could ftp the sql file to the clients server and
then run a php script on his server, something like:
$sql = "mysql -h$dbhost -u$dbuser -p$dbpass $dbname < $filename";
system($sql);
But, that didn't work -- however -- using mysqldump did download the
file. So, I'm close.
I know that safe_mode is ON, but I'm not sure if that's what's causing
the failure or something else.
Just a thought: did you pass the full path for $filename?
Also, pass in a return var to read:
system($sql, $ret);
if ($ret === 0) { echo 'sucess'; }
Sorry, you'll have to hunt down the other return codes that MySQl might
send back.
If safe_mode is enabled, your command will be escaped with
escapeshellcmd() but that's about it.
If you can FTP it but can't get a shell is there any chance you could
convince an admin to run the script?
Also, to be on the safe side, you might want to include
set_time_limit(0); in your script, also (if you can get system() to
work, that is).
brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
