Making a database backup help

[Imad]

Hi guys, I'm trying to create this database backup script but it isn't working. 

 

Here's the code:

 

// Database backup system
$settime = date(_mdys);
$namer = "$dbname$settime.txt";
$backupdoc = "inc/backup/$namer";

$query = "SELECT * INTO OUTFILE '$backupdoc' FROM comments";
if (mysql_query($query)) {
echo "<br />The Backup created successfully!";
}
else {
echo "<br />The Backup couldn't be created!"; }

 

Any help would be appreciated.

 

[Imad]

Everything seems fine, but it still won't work.  I gave this a try:

$settime = date(_mdys);
$namer = "$dbname$settime.txt";
$backupdoc = fopen("inc/backup/$namer","w");

$query = "SELECT * INTO OUTFILE '$backupdoc' FROM users";
if (mysql_query($query)) {
echo "<br />The Backup created successfully!";
}
else {
echo "<br />The Backup couldn't be created!"; }

 

But it just creates a blank file as I expected. Any Ideas??

Regards.

[corbin]

Chances are, mysql interprets relative paths as relative to the MySQL binary....

 

Try giving it a full path (eg: /inc/backup/blahblah)

[Imad]

Thanks for your help. Unfortunately it didn't work. I can't possibly find anything wrong with my script, but I might be missing something.

Any other ideas?

Thanks.

[eddierosenthal]

this line:

$backupdoc = fopen("inc/backup/$namer","w");

 

fopen returns a file handler, not a string. and so when you passed what you thought was

a filename you passed to the mysql query a pointer ( internal).

try passing the full name of the output file to the query.

hth