Home > Backend Development > PHP Tutorial > PHP database backup script_PHP tutorial

PHP database backup script_PHP tutorial

WBOY
Release: 2016-07-13 09:44:10
Original
1001 people have browsed it

php database backup script

php database backup script

The code is as follows:

 

// Backup database

 $host = "localhost";

 $user = "root"; //Database account

 $password = ""; //Database password

 $dbname = "mysql"; //Database name

// The account number, password, and name here are all passed from the page

 if (!mysql_connect($host, $user, $password)) // Connect to mysql database

 {

echo 'Database connection failed, please check and try again';

exit;

 }

 if (!mysql_select_db($dbname)) // Whether the database exists

 {

echo 'Database does not exist:' . $dbname . ', please check and try again';

exit;

 }

mysql_query("set names 'utf8'");

 $mysql = "set charset utf8; ";

 $q1 = mysql_query("show tables");

while ($t = mysql_fetch_array($q1))

 {

 $table = $t[0];

 $q2 = mysql_query("show create table `$table`");

 $sql = mysql_fetch_array($q2);

 $mysql .= $sql['Create Table'] . "; ";

 $q3 = mysql_query("select * from `$table`");

while ($data = mysql_fetch_assoc($q3))

 {

 $keys = array_keys($data);

$keys = array_map('addslashes', $keys);

$keys = join('',`', $keys);

 $keys = "`" . $keys . "`";

 $vals = array_values($data);

$vals = array_map('addslashes', $vals);

$vals = join("','", $vals);

 $vals = "'" . $vals . "'";

 $mysql .= "insert into `$table`($keys) values($vals); ";

 }

 }

 $filename = $dbname . date('Ymjgi') . ".sql"; //Storage path, stored in the outermost layer of the project by default

 $fp = fopen($filename, 'w');

fputs($fp, $mysql);

 fclose($fp);

echo "Data backup successful";

 ?>

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1049989.htmlTechArticlephp database backup script The php database backup script code is as follows: ?php // Backup database $host = localhost; $user = root; //Database account $password = ; //Database password $dbname...
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template