Okay, I took out all the reason for error, I took the variables out of the
code and replaced them with the actual values. I do not execute the gzip
function. All I get is an empty file. Also I made sure the back up directory
is set to 777.
Now phpMySQLAdmin will perform the same function, so ther
- 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: [
> Okay here is the new code and this is still not working.
>
>
> require("./config.php");
>
> $sqlserver = $server1;
> $sqlusername = $username1;
> $sqlpassword = $password1;
> $sqldatabase = $database1;
>
> //**
> $nam_bak=date('D,d-m-Y');
Can you have a filename
Haven't really been following this thread but you may want to make sure that
1. mysqldump & gzip are executable by apache
2. $backupdir is writeable by apache
3. You have taken into consideration your php safe mode settings
Cheers,
Owen Prime
http://www.noggin.com.au
Ken wrote:
> Okay here is
Okay here is the new code and this is still not working.
$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
I agree everything, but
Im not very sure if this is going to work:
> $backup=@passthru("mysqldump --opt \"$sqldatabase\" >
> $backupdir/$nam.sql");
You need to send mysqldump the username and password. Syntax is
Mysqldump -uuser -ppassword databasename > fi
> -Original Message-
> From: Ken [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 09, 2002 7:25 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Re: MySQL back up
>
> Here is the code I tired to use:
>
>
> session_start();
You don't need to start a session...
> require("./config.ph
> Why don't you just do a hard backup of the files from the db. Find out
the
> location of the data folder where thd db saves its tables, perform a
tar
> cvzf data_folder and then pipe it directly to the user for download
via
> http.
>
> Havent tryed it that way, but should work. Another thing wo
8 matches
Mail list logo
