How to create a backup of database using php script. I am facing a error

Question

I m trying this code but it shows a error

"Could not take data backup:

Can't create/write to file '\transfer\employees.sql' (Errcode: 2)"

when I click on my button to create a backup file.

<?php
$dbhost = "localhost";
$dbusername = "root";
$dbpassword = "";
$dbdatabase = "ghis_verf";
$conn = mysql_connect($dbhost,$dbusername,$dbpassword);
if(! $conn )
{
      die('Could not connect: ' . mysql_error());
}
$table_name = "employees";
$backup_file  = "/transfer/employees.sql";
$sql = "SELECT * INTO OUTFILE '$backup_file' FROM $table_name";
mysql_select_db($dbdatabase,$conn) or die("Cannot select database");
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
    die('Could not take data backup: ' . mysql_error());
}
echo "Backedup  data successfully\n";
?>

Do you have writing permission in that folder?

azeós
– azeós

2014-01-28 05:35:37 +00:00
Commented Jan 28, 2014 at 5:35 — azeós
– azeós, Commented Jan 28, 2014 at 5:35

ScayTrase · Accepted Answer · 2014-01-28 05:44:38Z

1

I think you do not have folder /transfer at the root of your web server or does not have permissions to write to it.

Make sure you can perform su -c "touch /transfer/employees.sql" www-data (replace www-data with proper user for you system). If no - check permissions or folder existence.

answered Jan 28, 2014 at 5:44

ScayTrase

1,83023 silver badges36 bronze badges

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

Comments

sagunms · Accepted Answer · 2014-01-28 09:30:30Z

1

It may be due insufficient write privilege. If you're using Linux, you may want to create the folder first as a placeholder with sufficient permissions for Apache to write to:

$ cd /path/to/app
$ mkdir transfer
$ chmod 777 transfer

See if the following PHP script works for you:

<?php
$dbhost = "localhost";
$dbusername = "root";
$dbpassword = "";
$dbdatabase = "ghis_verf";
$table_name = "employees";
$backup_file = "transfer/employees.sql";
$cmd = "mysqldump -h {$dbhost} -u {$dbusername} -p '{$dbpassword}' {$dbdatabase} {$table_name} > {$backup_file}";
system($cmd);
?>

Also /transfer is the absolute root path in your file system. Maybe it's something like /var/www/transfer? Or change it to absolute path such as transfer/.

Hope it helps.

edited Jan 28, 2014 at 9:30

answered Jan 28, 2014 at 9:09

sagunms

8,5455 gold badges44 silver badges43 bronze badges

Comments

Bhaktaraz · Accepted Answer · 2014-01-28 07:08:33Z

0

Please check the link below to export database via PHP code. Hope this will work for you. http://phptipmaster.blogspot.com/2013/01/mysql-database-export-via-php-code.html

answered Jan 28, 2014 at 7:08

Bhaktaraz

4915 silver badges15 bronze badges

Collectives™ on Stack Overflow

How to create a backup of database using php script. I am facing a error

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related