Hi,
I'm trying to call mysqldump from within a php-script, like this:
$backuptime = date("ymdHi");
$backupfile = "un" . $backuptime . ".txt";
exec("mysqldump --opt -u$dbuser -p$dbpassword $dbdatabase $alltables > /web/un/backup/$backupfile");
It works fine on my local Win2k, php 4.3.1, but not on my ISP:s Sun Solaris/php 4.3.2 machine I get a parse error. What am I doing wrong?
Is there a better way to backup my database?
I made a script to use mysqldump (in my script the result is send as an email attachment, with a debug option so it tells you what may be wrong. In your case, it is possible that mysqldump is not in the path, or even absent. Read the comments in the script. It needs some time to set up, with all the paths and other settings.
http://www.hieris.info/over/backup/backup.php.txt
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php