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');
Can you have a filename with a
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
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
-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:
?php
session_start();
You don't need to start a session...
require(./config.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
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\
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
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 would
8 matches
Mail list logo