PHP script to backup database

Question

I have tried to backup my MySQL databases using PHP, yet when I set the path for the backup I receive another path when running the script.

this is my script:

$baseDir = 'backup/';
$db;
$table;
$server = $_SERVER['HTTP_HOST'] . substr($_SERVER['SCRIPT_NAME'],0,strrpos($_SERVER['SCRIPT_NAME'],'/'));

this is inside the backup function:

global $baseDir;
global $db;
global $server;
$backupFile = $server . "/$baseDir$db/$tab.sql";
$query = mysql_query("SELECT * INTO OUTFILE '$backupFile' FROM $tab");
if(!$query)
    echo "\t" .mysql_error() .PHP_EOL;
else
    echo " backuped." . PHP_EOL;

the path I get is: c:\wamp\bin\mysql\mysql5.1.36\data\localhost\db\backup\contact_keeper\accounts.sql with erroCode: 2 (can`t write/create).

A better solution is to use mysqldump - dev.mysql.com/doc/refman/5.1/en/mysqldump.html — ajreal
– ajreal, Commented Nov 27, 2010 at 15:16

Marc B · Accepted Answer · 2010-11-27 13:36:17Z

2

SELECT ... INTO OUTFILE is limited to only CREATING a new file. It cannot overwrite an existing file as a security measure. As well, make sure that the account that MySQL is running under in Windows has write permissions on that ...\backup\contact_keeper directory. It may have only read/execute.

answered Nov 27, 2010 at 13:36

Marc B

362k44 gold badges433 silver badges508 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP script to backup database

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related