Having An Issue Backing Up MY Database From Php

Question

the issue that I'm having is with the fopen(), fwrite(), and fclose() function. This is the error I am receiving:

Warning: fopen(/db-backup-salisbury_school-20121128-021138.sql) [function.fopen]: failed to open stream: Permission denied in C:\inetpub\wwwroot\omarejaz\sbyschool\q5.php on line 177

Warning: fwrite() expects parameter 1 to be resource, boolean given in C:\inetpub\wwwroot\omarejaz\sbyschool\q5.php on line 178

Warning: fclose() expects parameter 1 to be resource, boolean given in C:\inetpub\wwwroot\omarejaz\sbyschool\q5.php on line 179

The code for this portion of php can be found below any help would be greatly appreciated!

 * Save SQL to file
 * @param string $sql
 */
protected function saveFile(&$sql, $outputDir = '.')
{
    if (!$sql) return false;

    try
    {
        $handle = fopen($outputDir.'/db-backup-'.$this->dbName.'-'.date("Ymd-His", time()).'.sql','w+');
        fwrite($handle, $sql);
        fclose($handle);
    }
    catch (Exception $e)
    {
        var_dump($e->getMessage());
        return false;
    }

    return true;
}

} ?>

Make sure the permissions on the output directory are set correctly. The username that runs the webserver must have write access to it. — rws907
I really don't understand what you mean any way that you could make it bit more simple. I am very new when it comes to this. — Mr. Hunt

rws907 rws907 · Accepted Answer · 2012-11-28T15:21:12

I believe he is running a Windows Webserver with IIS - judging by the C:\Inetput\wwwroot directory structure... so in Windows you need to approach it this way

If your script is located here

C:\inetpub\wwwroot\omarejaz\sbyschool\q5.php

Then you need to specify the full directory using proper Windows Directory structure in your Output Directory. Keep in mind that you may have to escape the \'s since, in PHP \ is and escape character.

$OutputDir = "C:\\inetpub\\wwwroot\\omarejaz\\sbyschool\\tmp";

Then in Windows make sure that you have the proper permissions set on the "tmp" folder to allow for IIS to write to it.

Having An Issue Backing Up MY Database From Php

2 Answers