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

PHP database backup script_PHP tutorial

WBOY
WBOYOriginal
2016-07-13 09:44:10996browse

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...
Statement:
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