How to simply back up and restore MySql in php, restore mysql in php

This article describes the simple method of backing up and restoring MySql in php. Share it with everyone for your reference, the details are as follows:

1. Backup:

<&#63;php
header ( "content-Type: text/html; charset=utf-8" );
//備份數(shù)據(jù)庫(kù)
$host="localhost";
$user="root";//數(shù)據(jù)庫(kù)賬號(hào)
$password="123456";//數(shù)據(jù)庫(kù)密碼
$dbname="test";//數(shù)據(jù)庫(kù)名稱
//這里的賬號(hào)、密碼、名稱都是從頁(yè)面?zhèn)鬟^(guò)來(lái)的
if(!mysql_connect($host,$user,$password)) //連接mysql數(shù)據(jù)庫(kù)
{
 echo '數(shù)據(jù)庫(kù)連接失敗，請(qǐng)核對(duì)后再試';
 exit;
}
if(!mysql_select_db($dbname)) //是否存在該數(shù)據(jù)庫(kù)
{
 echo '不存在數(shù)據(jù)庫(kù):'.$dbname.',請(qǐng)核對(duì)后再試';
 exit;
}
mysql_query("set names 'utf8'");
$mysql= "set charset utf8;\r\n";
$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'].";\r\n";
  $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);\r\n";
  }
}
$filename="data/".$dbname.date('Ymjgi').".sql"; //存放路徑，默認(rèn)存放到項(xiàng)目最外層
$fp = fopen($filename,'w');
fputs($fp,$mysql);
fclose($fp);
echo "數(shù)據(jù)備份成功";
&#63;>

2. Restore

<!--
 author:果凍
 qq:52091199
 blog:http://wyg517.blog.163.com
-->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<&#63;php
$filename = "test20101216923.sql";
$host="localhost"; //主機(jī)名
$user="root"; //MYSQL用戶名
$password="123456"; //密碼
$dbname="test"; //在此指定您要恢復(fù)的數(shù)據(jù)庫(kù)名，不存在則必須先創(chuàng)建,請(qǐng)自已修改數(shù)據(jù)庫(kù)名
mysql_connect($host,$user,$password);
mysql_select_db($dbname);
$mysql_file="data/".$filename; //指定要恢復(fù)的MySQL備份文件路徑,請(qǐng)自已修改此路徑
restore($mysql_file); //執(zhí)行MySQL恢復(fù)命令
function restore($fname)
 {
 if (file_exists($fname)) {
  $sql_value="";
  $cg=0;
  $sb=0;
  $sqls=file($fname);
  foreach($sqls as $sql)
  {
  $sql_value.=$sql;
  }
  $a=explode(";\r\n", $sql_value); //根據(jù)";\r\n"條件對(duì)數(shù)據(jù)庫(kù)中分條執(zhí)行
  $total=count($a)-1;
  mysql_query("set names 'utf8'");
  for ($i=0;$i<$total;$i++)
  {
  mysql_query("set names 'utf8'");
  //執(zhí)行命令
  if(mysql_query($a[$i]))
  {
   $cg+=1;
  }
  else
  {
   $sb+=1;
   $sb_command[$sb]=$a[$i];
  }
  }
  echo "操作完畢，共處理 $total 條命令，成功 $cg 條，失敗 $sb 條";
  //顯示錯(cuò)誤信息
  if ($sb>0)
  {
  echo "<hr><br><br>失敗命令如下：<br>";
  for ($ii=1;$ii<=$sb;$ii++)
  {
   echo "<p><b>第 ".$ii." 條命令（內(nèi)容如下）：</b><br>".$sb_command[$ii]."</p><br>";
  }
  }  //-----------------------------------------------------------
 }else{
  echo "MySQL備份文件不存在，請(qǐng)檢查文件路徑是否正確！";
 }
 }
&#63;>

Readers who are interested in more PHP-related content can check out the special topics of this site: "Summary of PHP database operation skills based on pdo", "PHP MongoDB database operation skills collection", "php object-oriented programming introductory tutorial", "php Summary of String Usage", "Introduction Tutorial on PHP MySQL Database Operation" and "Summary of PHP Common Database Operation Skills"

I hope this article will be helpful to everyone in PHP programming.