Ken ..

You have to replace

exec("mysqldump -u\"$sqlusername\" -p\"$sqlpassword\" \"$sqldatabase\" >
$backupdir/$nam.sql");

With this

exec("mysqldump -u \"$sqlusername\" --password=\"$sqlpassword\"
\"$sqldatabase\" > $backupdir/$nam.sql");

Please not the space after -u

And i agree owen about

2. $backupdir MUST BE writeable by apache

IT HAS TO WORK MAN !!


Cordialmente
Daniel Massón => Ingeniero de desarollo
[EMAIL PROTECTED]
www.imagine.com.co
Tels: (57)(1) 2182064 - 6163218
Bogotá - Colombia
------------------------------------------------------------------------
- Soluciones web para internet e intranet
- Asesoría y Soporte Técnico
- Licenciamiento de Software 
 



-----Mensaje original-----
De: Ken [mailto:[EMAIL PROTECTED]] 
Enviado el: miércoles, 09 de octubre de 2002 22:36
Para: [EMAIL PROTECTED]
Asunto: Re: [PHP] Re: MySQL back up


Okay here is the new code and this is still not working.

<?php

require("./config.php");

$sqlserver = $server1;
$sqlusername = $username1;
$sqlpassword = $password1;
$sqldatabase = $database1;

//******************************
$nam_bak=date('D,d-m-Y');

exec("mysqldump -u\"$sqlusername\" -p\"$sqlpassword\" \"$sqldatabase\" >
$backupdir/$nam.sql");

exec("gzip $backupdir/$nam.sql");

?>



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to