php 数据库备份、还原

1. mydb.php <span style="color: #008000;">//</span><span style="color: #008000;">DB类</span>
2. backup.php <span style="color: #008000;">//</span><span style="color: #008000;">备份脚本</span>
3. restore.php <span style="color: #008000;">//</span><span style="color: #008000;">还原脚本</span>
<span style="color: #000000;">
mydb</span>.<span style="color: #000000;">php

</span><?
<span style="color: #0000ff;">class</span><span style="color: #000000;"> db{

</span><span style="color: #0000ff;">var</span> <span style="color: #800080;">$linkid</span><span style="color: #000000;">;
</span><span style="color: #0000ff;">var</span> <span style="color: #800080;">$sqlid</span><span style="color: #000000;">;
</span><span style="color: #0000ff;">var</span> <span style="color: #800080;">$record</span><span style="color: #000000;">;

</span><span style="color: #0000ff;">function</span> db(<span style="color: #800080;">$host</span>="",<span style="color: #800080;">$username</span>="",<span style="color: #800080;">$password</span>="",<span style="color: #800080;">$database</span>=""<span style="color: #000000;">)
{
</span><span style="color: #0000ff;">if</span>(!<span style="color: #800080;">$this</span>->linkid)    @<span style="color: #800080;">$this</span>->linkid = <span style="color: #008080;">mysql_connect</span>(<span style="color: #800080;">$host</span>, <span style="color: #800080;">$username</span>, <span style="color: #800080;">$password</span>) or <span style="color: #0000ff;">die</span>("连接服务器失败."<span style="color: #000000;">);
@</span><span style="color: #008080;">mysql_select_db</span>(<span style="color: #800080;">$database</span>,<span style="color: #800080;">$this</span>->linkid) or <span style="color: #0000ff;">die</span>("无法打开数据库"<span style="color: #000000;">);
</span><span style="color: #0000ff;">return</span> <span style="color: #800080;">$this</span>-><span style="color: #000000;">linkid;}

</span><span style="color: #0000ff;">function</span> query(<span style="color: #800080;">$sql</span><span style="color: #000000;">)
{</span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$this</span>->sqlid=<span style="color: #008080;">mysql_query</span>(<span style="color: #800080;">$sql</span>,<span style="color: #800080;">$this</span>->linkid)) <span style="color: #0000ff;">return</span> <span style="color: #800080;">$this</span>-><span style="color: #000000;">sqlid;
</span><span style="color: #0000ff;">else</span><span style="color: #000000;"> {
    </span><span style="color: #800080;">$this</span>->err_report(<span style="color: #800080;">$sql</span>,<span style="color: #008080;">mysql_error</span><span style="color: #000000;">);
</span><span style="color: #0000ff;">return</span> <span style="color: #0000ff;">false</span><span style="color: #000000;">;}
}

</span><span style="color: #0000ff;">function</span> nr(<span style="color: #800080;">$sql_id</span>=""<span style="color: #000000;">)
{</span><span style="color: #0000ff;">if</span>(!<span style="color: #800080;">$sql_id</span>) <span style="color: #800080;">$sql_id</span>=<span style="color: #800080;">$this</span>-><span style="color: #000000;">sqlid;
</span><span style="color: #0000ff;">return</span> <span style="color: #008080;">mysql_num_rows</span>(<span style="color: #800080;">$sql_id</span><span style="color: #000000;">);}

</span><span style="color: #0000ff;">function</span> nf(<span style="color: #800080;">$sql_id</span>=""<span style="color: #000000;">)
{</span><span style="color: #0000ff;">if</span>(!<span style="color: #800080;">$sql_id</span>) <span style="color: #800080;">$sql_id</span>=<span style="color: #800080;">$this</span>-><span style="color: #000000;">sqlid;
</span><span style="color: #0000ff;">return</span> <span style="color: #008080;">mysql_num_fields</span>(<span style="color: #800080;">$sql_id</span><span style="color: #000000;">);}

</span><span style="color: #0000ff;">function</span> nextrecord(<span style="color: #800080;">$sql_id</span>=""<span style="color: #000000;">)
{</span><span style="color: #0000ff;">if</span>(!<span style="color: #800080;">$sql_id</span>) <span style="color: #800080;">$sql_id</span>=<span style="color: #800080;">$this</span>-><span style="color: #000000;">sqlid;
</span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$this</span>->record=<span style="color: #008080;">mysql_fetch_array</span>(<span style="color: #800080;">$sql_id</span>))    <span style="color: #0000ff;">return</span> <span style="color: #800080;">$this</span>-><span style="color: #000000;">record;
</span><span style="color: #0000ff;">else</span> <span style="color: #0000ff;">return</span> <span style="color: #0000ff;">false</span><span style="color: #000000;">;
}

</span><span style="color: #0000ff;">function</span> f(<span style="color: #800080;">$name</span><span style="color: #000000;">)
{
</span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$this</span>->record[<span style="color: #800080;">$name</span>]) <span style="color: #0000ff;">return</span> <span style="color: #800080;">$this</span>->record[<span style="color: #800080;">$name</span><span style="color: #000000;">];
</span><span style="color: #0000ff;">else</span> <span style="color: #0000ff;">return</span> <span style="color: #0000ff;">false</span><span style="color: #000000;">;
}

</span><span style="color: #0000ff;">function</span> close() {<span style="color: #008080;">mysql_close</span>(<span style="color: #800080;">$this</span>-><span style="color: #000000;">linkid);}

</span><span style="color: #0000ff;">function</span> lock(<span style="color: #800080;">$tblname</span>,<span style="color: #800080;">$op</span>="WRITE"<span style="color: #000000;">)
{</span><span style="color: #0000ff;">if</span>(<span style="color: #008080;">mysql_query</span>("lock tables ".<span style="color: #800080;">$tblname</span>." ".<span style="color: #800080;">$op</span>)) <span style="color: #0000ff;">return</span> <span style="color: #0000ff;">true</span>; <span style="color: #0000ff;">else</span> <span style="color: #0000ff;">return</span> <span style="color: #0000ff;">false</span><span style="color: #000000;">;}

</span><span style="color: #0000ff;">function</span><span style="color: #000000;"> unlock()
{</span><span style="color: #0000ff;">if</span>(<span style="color: #008080;">mysql_query</span>("unlock tables")) <span style="color: #0000ff;">return</span> <span style="color: #0000ff;">true</span>; <span style="color: #0000ff;">else</span> <span style="color: #0000ff;">return</span> <span style="color: #0000ff;">false</span><span style="color: #000000;">;}

</span><span style="color: #0000ff;">function</span><span style="color: #000000;"> ar() {
      </span><span style="color: #0000ff;">return</span> @<span style="color: #008080;">mysql_affected_rows</span>(<span style="color: #800080;">$this</span>-><span style="color: #000000;">linkid);
    }

</span><span style="color: #0000ff;">function</span><span style="color: #000000;"> i_id() {
    </span><span style="color: #0000ff;">return</span> <span style="color: #008080;">mysql_insert_id</span><span style="color: #000000;">();
}

</span><span style="color: #0000ff;">function</span> err_report(<span style="color: #800080;">$sql</span>,<span style="color: #800080;">$err</span><span style="color: #000000;">)
{
</span><span style="color: #0000ff;">echo</span> "Mysql查询错误<br>"<span style="color: #000000;">;
</span><span style="color: #0000ff;">echo</span> "查询语句：".<span style="color: #800080;">$sql</span>."<br>"<span style="color: #000000;">;
</span><span style="color: #0000ff;">echo</span> "错误信息：".<span style="color: #800080;">$err</span><span style="color: #000000;">;
}
</span><span style="color: #008000;">/*</span><span style="color: #008000;">***************************************类结束**************************</span><span style="color: #008000;">*/</span><span style="color: #000000;">
}</span>?><span style="color: #000000;">

backup</span>.<span style="color: #000000;">php

</span><?

<span style="color: #0000ff;">error_reporting(E_ALL & ~ E_NOTICE);</span>

<span style="color: #0000ff;">global</span> <span style="color: #800080;">$mysqlhost</span>, <span style="color: #800080;">$mysqluser</span>, <span style="color: #800080;">$mysqlpwd</span>, <span style="color: #800080;">$mysqldb</span><span style="color: #000000;">;
</span><span style="color: #800080;">$mysqlhost</span>="localhost"; <span style="color: #008000;">//</span><span style="color: #008000;">host name</span>
<span style="color: #800080;">$mysqluser</span>="root";                <span style="color: #008000;">//</span><span style="color: #008000;">login name</span>
<span style="color: #800080;">$mysqlpwd</span>="";                <span style="color: #008000;">//</span><span style="color: #008000;">password</span>
<span style="color: #800080;">$mysqldb</span>="";          <span style="color: #008000;">//</span><span style="color: #008000;">name of database</span>

<span style="color: #0000ff;">include</span>("mydb.php"<span style="color: #000000;">);
</span><span style="color: #800080;">$d</span>=<span style="color: #0000ff;">new</span> db(<span style="color: #800080;">$mysqlhost</span>,<span style="color: #800080;">$mysqluser</span>,<span style="color: #800080;">$mysqlpwd</span>,<span style="color: #800080;">$mysqldb</span><span style="color: #000000;">);
</span><span style="color: #008000;">/*</span><span style="color: #008000;">--------------界面--------------</span><span style="color: #008000;">*/</span><span style="color: #0000ff;">if</span>(!<span style="color: #800080;">$_POST</span>['act']){<span style="color: #008000;">/*</span><span style="color: #008000;">----------------------</span><span style="color: #008000;">*/</span>
<span style="color: #800080;">$msgs</span>[]="服务器备份目录为backup"<span style="color: #000000;">;
</span><span style="color: #800080;">$msgs</span>[]="对于较大的数据表，强烈建议使用分卷备份"<span style="color: #000000;">;
</span><span style="color: #800080;">$msgs</span>[]="只有选择备份到服务器，才能使用分卷备份功能"<span style="color: #000000;">;
show_msg(</span><span style="color: #800080;">$msgs</span><span style="color: #000000;">);
</span>?>
<form name="form1" method="post" action="backup.php">
    <table width="99%" border="1" cellpadding='0' cellspacing='1'>
      <tr align="center" <span style="color: #0000ff;">class</span>='header'><td colspan="2">数据备份</td></tr>
      <tr><td colspan="2">备份方式</td></tr>
      <tr><td><input type="radio" name="bfzl" value="quanbubiao">          备份全部数据</td><td>备份全部数据表中的数据到一个备份文件</td></tr>
      <tr><td><input type="radio" name="bfzl" value="danbiao"><span style="color: #000000;">备份单张表数据
          </span><select name="tablename"><option value="">请选择</option>
            <?
    <span style="color: #800080;">$d</span>->query("show table status from <span style="color: #800080;">$mysqldb</span>"<span style="color: #000000;">);
    </span><span style="color: #0000ff;">while</span>(<span style="color: #800080;">$d</span>-><span style="color: #000000;">nextrecord()){
    </span><span style="color: #0000ff;">echo</span> "<option value='".<span style="color: #800080;">$d</span>->f('Name')."'>".<span style="color: #800080;">$d</span>->f('Name')."</option>"<span style="color: #000000;">;}
    </span>?>
          </select></td><td>备份选中数据表中的数据到单独的备份文件</td></tr>
      <tr><td colspan="2">使用分卷备份</td></tr>
      <tr><td colspan="2"><input type="checkbox" name="fenjuan" value="yes"><span style="color: #000000;">
          分卷备份 </span><input name="filesize" type="text" size="10">K</td></tr>
      <tr><td colspan="2">选择目标位置</td></tr>
      <tr><td colspan="2"><input type="radio" name="weizhi" value="server" checked>备份到服务器</td></tr><tr <span style="color: #0000ff;">class</span>="cells"><td colspan='2'> <input type="radio" name="weizhi" value="localpc"><span style="color: #000000;">
          备份到本地</span></td></tr>
      <tr><td colspan="2" align='center'><input type="submit" name="act" value="备份"></td></tr>
    </table></form>
<?<span style="color: #008000;">/*</span><span style="color: #008000;">-------------界面结束-------------</span><span style="color: #008000;">*/</span>}<span style="color: #008000;">/*</span><span style="color: #008000;">---------------------------------</span><span style="color: #008000;">*/</span>
<span style="color: #008000;">/*</span><span style="color: #008000;">----</span><span style="color: #008000;">*/</span><span style="color: #0000ff;">else</span>{<span style="color: #008000;">/*</span><span style="color: #008000;">--------------主程序-----------------------------------------</span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">if</span>(<span style="color: #800080;">$_POST</span>['weizhi']=="localpc"&&<span style="color: #800080;">$_POST</span>['fenjuan']=='yes'<span style="color: #000000;">)
{</span><span style="color: #800080;">$msgs</span>[]="只有选择备份到服务器，才能使用分卷备份功能"<span style="color: #000000;">;
show_msg(</span><span style="color: #800080;">$msgs</span><span style="color: #000000;">); pageend();}
</span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$_POST</span>['fenjuan']=="yes"&&!<span style="color: #800080;">$_POST</span>['filesize'<span style="color: #000000;">])
{</span><span style="color: #800080;">$msgs</span>[]="您选择了分卷备份功能，但未填写分卷文件大小"<span style="color: #000000;">;
show_msg(</span><span style="color: #800080;">$msgs</span><span style="color: #000000;">); pageend();}
</span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$_POST</span>['weizhi']=="server"&&!writeable("./backup"<span style="color: #000000;">))
{</span><span style="color: #800080;">$msgs</span>[]="备份文件存放目录'./backup'不可写，请修改目录属性"<span style="color: #000000;">;
show_msg(</span><span style="color: #800080;">$msgs</span><span style="color: #000000;">); pageend();}

</span><span style="color: #008000;">/*</span><span style="color: #008000;">----------备份全部表-------------</span><span style="color: #008000;">*/</span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$_POST</span>['bfzl']=="quanbubiao"){<span style="color: #008000;">/*</span><span style="color: #008000;">----</span><span style="color: #008000;">*/</span>
<span style="color: #008000;">/*</span><span style="color: #008000;">----不分卷</span><span style="color: #008000;">*/</span><span style="color: #0000ff;">if</span>(!<span style="color: #800080;">$_POST</span>['fenjuan']){<span style="color: #008000;">/*</span><span style="color: #008000;">--------------------------------</span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">if</span>(!<span style="color: #800080;">$tables</span>=<span style="color: #800080;">$d</span>->query("show table status from <span style="color: #800080;">$mysqldb</span>"<span style="color: #000000;">))
{</span><span style="color: #800080;">$msgs</span>[]="读数据库结构错误"; show_msg(<span style="color: #800080;">$msgs</span><span style="color: #000000;">); pageend();}
</span><span style="color: #800080;">$sql</span>=""<span style="color: #000000;">;
</span><span style="color: #0000ff;">while</span>(<span style="color: #800080;">$d</span>->nextrecord(<span style="color: #800080;">$tables</span><span style="color: #000000;">))
{
</span><span style="color: #800080;">$table</span>=<span style="color: #800080;">$d</span>->f("Name"<span style="color: #000000;">);
</span><span style="color: #800080;">$sql</span>.=make_header(<span style="color: #800080;">$table</span><span style="color: #000000;">);
</span><span style="color: #800080;">$d</span>->query("select * from <span style="color: #800080;">$table</span>"<span style="color: #000000;">);
</span><span style="color: #800080;">$num_fields</span>=<span style="color: #800080;">$d</span>-><span style="color: #000000;">nf();
</span><span style="color: #0000ff;">while</span>(<span style="color: #800080;">$d</span>-><span style="color: #000000;">nextrecord())
{</span><span style="color: #800080;">$sql</span>.=make_record(<span style="color: #800080;">$table</span>,<span style="color: #800080;">$num_fields</span><span style="color: #000000;">);}
}
</span><span style="color: #800080;">$filename</span>=<span style="color: #008080;">date</span>("Ymd",<span style="color: #008080;">time</span>())."_all.sql"<span style="color: #000000;">;
</span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$_POST</span>['weizhi']=="localpc") down_file(<span style="color: #800080;">$sql</span>,<span style="color: #800080;">$filename</span><span style="color: #000000;">);
</span><span style="color: #0000ff;">elseif</span>(<span style="color: #800080;">$_POST</span>['weizhi']=="server"<span style="color: #000000;">)
{</span><span style="color: #0000ff;">if</span>(write_file(<span style="color: #800080;">$sql</span>,<span style="color: #800080;">$filename</span><span style="color: #000000;">))
</span><span style="color: #800080;">$msgs</span>[]="全部数据表数据备份完成,生成备份文件'./backup/<span style="color: #800080;">$filename</span>'"<span style="color: #000000;">;
</span><span style="color: #0000ff;">else</span> <span style="color: #800080;">$msgs</span>[]="备份全部数据表失败"<span style="color: #000000;">;
show_msg(</span><span style="color: #800080;">$msgs</span><span style="color: #000000;">);
pageend();
}
</span><span style="color: #008000;">/*</span><span style="color: #008000;">-----------------不要卷结束</span><span style="color: #008000;">*/</span>}<span style="color: #008000;">/*</span><span style="color: #008000;">-----------------------</span><span style="color: #008000;">*/</span>
<span style="color: #008000;">/*</span><span style="color: #008000;">-----------------分卷</span><span style="color: #008000;">*/</span><span style="color: #0000ff;">else</span>{<span style="color: #008000;">/*</span><span style="color: #008000;">-------------------------</span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">if</span>(!<span style="color: #800080;">$_POST</span>['filesize'<span style="color: #000000;">])
{</span><span style="color: #800080;">$msgs</span>[]="请填写备份文件分卷大小"; show_msg(<span style="color: #800080;">$msgs</span><span style="color: #000000;">);pageend();}
</span><span style="color: #0000ff;">if</span>(!<span style="color: #800080;">$tables</span>=<span style="color: #800080;">$d</span>->query("show table status from <span style="color: #800080;">$mysqldb</span>"<span style="color: #000000;">))
{</span><span style="color: #800080;">$msgs</span>[]="读数据库结构错误"; show_msg(<span style="color: #800080;">$msgs</span><span style="color: #000000;">); pageend();}
</span><span style="color: #800080;">$sql</span>=""; <span style="color: #800080;">$p</span>=1<span style="color: #000000;">;
</span><span style="color: #800080;">$filename</span>=<span style="color: #008080;">date</span>("Ymd",<span style="color: #008080;">time</span>())."_all"<span style="color: #000000;">;
</span><span style="color: #0000ff;">while</span>(<span style="color: #800080;">$d</span>->nextrecord(<span style="color: #800080;">$tables</span><span style="color: #000000;">))
{
</span><span style="color: #800080;">$table</span>=<span style="color: #800080;">$d</span>->f("Name"<span style="color: #000000;">);
</span><span style="color: #800080;">$sql</span>.=make_header(<span style="color: #800080;">$table</span><span style="color: #000000;">);
</span><span style="color: #800080;">$d</span>->query("select * from <span style="color: #800080;">$table</span>"<span style="color: #000000;">);
</span><span style="color: #800080;">$num_fields</span>=<span style="color: #800080;">$d</span>-><span style="color: #000000;">nf();
</span><span style="color: #0000ff;">while</span>(<span style="color: #800080;">$d</span>-><span style="color: #000000;">nextrecord())
{</span><span style="color: #800080;">$sql</span>.=make_record(<span style="color: #800080;">$table</span>,<span style="color: #800080;">$num_fields</span><span style="color: #000000;">);
</span><span style="color: #0000ff;">if</span>(<span style="color: #008080;">strlen</span>(<span style="color: #800080;">$sql</span>)>=<span style="color: #800080;">$_POST</span>['filesize']*1000<span style="color: #000000;">){
     </span><span style="color: #800080;">$filename</span>.=("_v".<span style="color: #800080;">$p</span>.".sql"<span style="color: #000000;">);
     </span><span style="color: #0000ff;">if</span>(write_file(<span style="color: #800080;">$sql</span>,<span style="color: #800080;">$filename</span><span style="color: #000000;">))
     </span><span style="color: #800080;">$msgs</span>[]="全部数据表-卷-".<span style="color: #800080;">$p</span>."-数据备份完成,生成备份文件'./backup/<span style="color: #800080;">$filename</span>'"<span style="color: #000000;">;
     </span><span style="color: #0000ff;">else</span> <span style="color: #800080;">$msgs</span>[]="备份表-".<span style="color: #800080;">$_POST</span>['tablename']."-失败"<span style="color: #000000;">;
     </span><span style="color: #800080;">$p</span>++<span style="color: #000000;">;
     </span><span style="color: #800080;">$filename</span>=<span style="color: #008080;">date</span>("Ymd",<span style="color: #008080;">time</span>())."_all"<span style="color: #000000;">;
     </span><span style="color: #800080;">$sql</span>=""<span style="color: #000000;">;}
}
}
</span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$sql</span>!=""){<span style="color: #800080;">$filename</span>.=("_v".<span style="color: #800080;">$p</span>.".sql"<span style="color: #000000;">); 
</span><span style="color: #0000ff;">if</span>(write_file(<span style="color: #800080;">$sql</span>,<span style="color: #800080;">$filename</span><span style="color: #000000;">))
</span><span style="color: #800080;">$msgs</span>[]="全部数据表-卷-".<span style="color: #800080;">$p</span>."-数据备份完成,生成备份文件'./backup/<span style="color: #800080;">$filename</span>'"<span style="color: #000000;">;}
show_msg(</span><span style="color: #800080;">$msgs</span><span style="color: #000000;">);
</span><span style="color: #008000;">/*</span><span style="color: #008000;">---------------------分卷结束</span><span style="color: #008000;">*/</span>}<span style="color: #008000;">/*</span><span style="color: #008000;">--------------------------------------</span><span style="color: #008000;">*/</span>
<span style="color: #008000;">/*</span><span style="color: #008000;">--------备份全部表结束</span><span style="color: #008000;">*/</span>}<span style="color: #008000;">/*</span><span style="color: #008000;">---------------------------------------------</span><span style="color: #008000;">*/</span>

<span style="color: #008000;">/*</span><span style="color: #008000;">--------备份单表------</span><span style="color: #008000;">*/</span><span style="color: #0000ff;">elseif</span>(<span style="color: #800080;">$_POST</span>['bfzl']=="danbiao"){<span style="color: #008000;">/*</span><span style="color: #008000;">------------</span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">if</span>(!<span style="color: #800080;">$_POST</span>['tablename'<span style="color: #000000;">])
{</span><span style="color: #800080;">$msgs</span>[]="请选择要备份的数据表"; show_msg(<span style="color: #800080;">$msgs</span><span style="color: #000000;">); pageend();}
</span><span style="color: #008000;">/*</span><span style="color: #008000;">--------不分卷</span><span style="color: #008000;">*/</span><span style="color: #0000ff;">if</span>(!<span style="color: #800080;">$_POST</span>['fenjuan']){<span style="color: #008000;">/*</span><span style="color: #008000;">-------------------------------</span><span style="color: #008000;">*/</span>
<span style="color: #800080;">$sql</span>=make_header(<span style="color: #800080;">$_POST</span>['tablename'<span style="color: #000000;">]);
</span><span style="color: #800080;">$d</span>->query("select * from ".<span style="color: #800080;">$_POST</span>['tablename'<span style="color: #000000;">]);
</span><span style="color: #800080;">$num_fields</span>=<span style="color: #800080;">$d</span>-><span style="color: #000000;">nf();
</span><span style="color: #0000ff;">while</span>(<span style="color: #800080;">$d</span>-><span style="color: #000000;">nextrecord())
{</span><span style="color: #800080;">$sql</span>.=make_record(<span style="color: #800080;">$_POST</span>['tablename'],<span style="color: #800080;">$num_fields</span><span style="color: #000000;">);}
</span><span style="color: #800080;">$filename</span>=<span style="color: #008080;">date</span>("Ymd",<span style="color: #008080;">time</span>())."_".<span style="color: #800080;">$_POST</span>['tablename'].".sql"<span style="color: #000000;">;
</span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$_POST</span>['weizhi']=="localpc") down_file(<span style="color: #800080;">$sql</span>,<span style="color: #800080;">$filename</span><span style="color: #000000;">);
</span><span style="color: #0000ff;">elseif</span>(<span style="color: #800080;">$_POST</span>['weizhi']=="server"<span style="color: #000000;">)
{</span><span style="color: #0000ff;">if</span>(write_file(<span style="color: #800080;">$sql</span>,<span style="color: #800080;">$filename</span><span style="color: #000000;">))
</span><span style="color: #800080;">$msgs</span>[]="表-".<span style="color: #800080;">$_POST</span>['tablename']."-数据备份完成,生成备份文件'./backup/<span style="color: #800080;">$filename</span>'"<span style="color: #000000;">;
</span><span style="color: #0000ff;">else</span> <span style="color: #800080;">$msgs</span>[]="备份表-".<span style="color: #800080;">$_POST</span>['tablename']."-失败"<span style="color: #000000;">;
show_msg(</span><span style="color: #800080;">$msgs</span><span style="color: #000000;">);
pageend();
}
</span><span style="color: #008000;">/*</span><span style="color: #008000;">----------------不要卷结束</span><span style="color: #008000;">*/</span>}<span style="color: #008000;">/*</span><span style="color: #008000;">------------------------------------</span><span style="color: #008000;">*/</span>
<span style="color: #008000;">/*</span><span style="color: #008000;">----------------分卷</span><span style="color: #008000;">*/</span><span style="color: #0000ff;">else</span>{<span style="color: #008000;">/*</span><span style="color: #008000;">--------------------------------------</span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">if</span>(!<span style="color: #800080;">$_POST</span>['filesize'<span style="color: #000000;">])
{</span><span style="color: #800080;">$msgs</span>[]="请填写备份文件分卷大小"; show_msg(<span style="color: #800080;">$msgs</span><span style="color: #000000;">);pageend();}
</span><span style="color: #800080;">$sql</span>=make_header(<span style="color: #800080;">$_POST</span>['tablename']); <span style="color: #800080;">$p</span>=1<span style="color: #000000;">;
</span><span style="color: #800080;">$filename</span>=<span style="color: #008080;">date</span>("Ymd",<span style="color: #008080;">time</span>())."_".<span style="color: #800080;">$_POST</span>['tablename'<span style="color: #000000;">];
</span><span style="color: #800080;">$d</span>->query("select * from ".<span style="color: #800080;">$_POST</span>['tablename'<span style="color: #000000;">]);
</span><span style="color: #800080;">$num_fields</span>=<span style="color: #800080;">$d</span>-><span style="color: #000000;">nf();
</span><span style="color: #0000ff;">while</span> (<span style="color: #800080;">$d</span>-><span style="color: #000000;">nextrecord())
{
    </span><span style="color: #800080;">$sql</span>.=make_record(<span style="color: #800080;">$_POST</span>['tablename'],<span style="color: #800080;">$num_fields</span><span style="color: #000000;">);
      </span><span style="color: #0000ff;">if</span>(<span style="color: #008080;">strlen</span>(<span style="color: #800080;">$sql</span>)>=<span style="color: #800080;">$_POST</span>['filesize']*1000<span style="color: #000000;">){
     </span><span style="color: #800080;">$filename</span>.=("_v".<span style="color: #800080;">$p</span>.".sql"<span style="color: #000000;">);
     </span><span style="color: #0000ff;">if</span>(write_file(<span style="color: #800080;">$sql</span>,<span style="color: #800080;">$filename</span><span style="color: #000000;">))
     </span><span style="color: #800080;">$msgs</span>[]="表-".<span style="color: #800080;">$_POST</span>['tablename']."-卷-".<span style="color: #800080;">$p</span>."-数据备份完成,生成备份文件'./backup/<span style="color: #800080;">$filename</span>'"<span style="color: #000000;">;
     </span><span style="color: #0000ff;">else</span> <span style="color: #800080;">$msgs</span>[]="备份表-".<span style="color: #800080;">$_POST</span>['tablename']."-失败"<span style="color: #000000;">;
     </span><span style="color: #800080;">$p</span>++<span style="color: #000000;">;
     </span><span style="color: #800080;">$filename</span>=<span style="color: #008080;">date</span>("Ymd",<span style="color: #008080;">time</span>())."_".<span style="color: #800080;">$_POST</span>['tablename'<span style="color: #000000;">];
     </span><span style="color: #800080;">$sql</span>=""<span style="color: #000000;">;}
}
</span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$sql</span>!=""){<span style="color: #800080;">$filename</span>.=("_v".<span style="color: #800080;">$p</span>.".sql"<span style="color: #000000;">); 
</span><span style="color: #0000ff;">if</span>(write_file(<span style="color: #800080;">$sql</span>,<span style="color: #800080;">$filename</span><span style="color: #000000;">))
</span><span style="color: #800080;">$msgs</span>[]="表-".<span style="color: #800080;">$_POST</span>['tablename']."-卷-".<span style="color: #800080;">$p</span>."-数据备份完成,生成备份文件'./backup/<span style="color: #800080;">$filename</span>'"<span style="color: #000000;">;}
show_msg(</span><span style="color: #800080;">$msgs</span><span style="color: #000000;">);
</span><span style="color: #008000;">/*</span><span style="color: #008000;">----------分卷结束</span><span style="color: #008000;">*/</span>}<span style="color: #008000;">/*</span><span style="color: #008000;">--------------------------------------------------</span><span style="color: #008000;">*/</span>
<span style="color: #008000;">/*</span><span style="color: #008000;">----------备份单表结束</span><span style="color: #008000;">*/</span>}<span style="color: #008000;">/*</span><span style="color: #008000;">----------------------------------------------</span><span style="color: #008000;">*/</span>

<span style="color: #008000;">/*</span><span style="color: #008000;">---</span><span style="color: #008000;">*/</span>}<span style="color: #008000;">/*</span><span style="color: #008000;">-------------主程序结束------------------------------------------</span><span style="color: #008000;">*/</span>

<span style="color: #0000ff;">function</span> write_file(<span style="color: #800080;">$sql</span>,<span style="color: #800080;">$filename</span><span style="color: #000000;">)
{
</span><span style="color: #800080;">$re</span>=<span style="color: #0000ff;">true</span><span style="color: #000000;">;
</span><span style="color: #0000ff;">if</span>(!@<span style="color: #800080;">$fp</span>=<span style="color: #008080;">fopen</span>("./backup/".<span style="color: #800080;">$filename</span>,"w+")) {<span style="color: #800080;">$re</span>=<span style="color: #0000ff;">false</span>; <span style="color: #0000ff;">echo</span> "failed to open target file"<span style="color: #000000;">;}
</span><span style="color: #0000ff;">if</span>(!@<span style="color: #008080;">fwrite</span>(<span style="color: #800080;">$fp</span>,<span style="color: #800080;">$sql</span>)) {<span style="color: #800080;">$re</span>=<span style="color: #0000ff;">false</span>; <span style="color: #0000ff;">echo</span> "failed to write file"<span style="color: #000000;">;}
</span><span style="color: #0000ff;">if</span>(!@<span style="color: #008080;">fclose</span>(<span style="color: #800080;">$fp</span>)) {<span style="color: #800080;">$re</span>=<span style="color: #0000ff;">false</span>; <span style="color: #0000ff;">echo</span> "failed to close target file"<span style="color: #000000;">;}
</span><span style="color: #0000ff;">return</span> <span style="color: #800080;">$re</span><span style="color: #000000;">;
}

</span><span style="color: #0000ff;">function</span> down_file(<span style="color: #800080;">$sql</span>,<span style="color: #800080;">$filename</span><span style="color: #000000;">)
{
</span><span style="color: #008080;">ob_end_clean</span><span style="color: #000000;">();
</span><span style="color: #008080;">header</span>("Content-Encoding: none"<span style="color: #000000;">);
</span><span style="color: #008080;">header</span>("Content-Type: ".(<span style="color: #008080;">strpos</span>(<span style="color: #800080;">$_SERVER</span>['HTTP_USER_AGENT'], 'MSIE') ? 'application/octetstream' : 'application/octet-stream'<span style="color: #000000;">));
  
</span><span style="color: #008080;">header</span>("Content-Disposition: ".(<span style="color: #008080;">strpos</span>(<span style="color: #800080;">$_SERVER</span>['HTTP_USER_AGENT'], 'MSIE') ? 'inline; ' : 'attachment; ')."filename=".<span style="color: #800080;">$filename</span><span style="color: #000000;">);
  
</span><span style="color: #008080;">header</span>("Content-Length: ".<span style="color: #008080;">strlen</span>(<span style="color: #800080;">$sql</span><span style="color: #000000;">));
</span><span style="color: #008080;">header</span>("Pragma: no-cache"<span style="color: #000000;">);
  
</span><span style="color: #008080;">header</span>("Expires: 0"<span style="color: #000000;">);
</span><span style="color: #0000ff;">echo</span> <span style="color: #800080;">$sql</span><span style="color: #000000;">;
</span><span style="color: #800080;">$e</span>=<span style="color: #008080;">ob_get_contents</span><span style="color: #000000;">();
</span><span style="color: #008080;">ob_end_clean</span><span style="color: #000000;">();
}

</span><span style="color: #0000ff;">function</span> writeable(<span style="color: #800080;">$dir</span><span style="color: #000000;">)
{

</span><span style="color: #0000ff;">if</span>(!<span style="color: #008080;">is_dir</span>(<span style="color: #800080;">$dir</span><span style="color: #000000;">)) {
@</span><span style="color: #008080;">mkdir</span>(<span style="color: #800080;">$dir</span>, 0777<span style="color: #000000;">);
}

</span><span style="color: #0000ff;">if</span>(<span style="color: #008080;">is_dir</span>(<span style="color: #800080;">$dir</span><span style="color: #000000;">))
{

</span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$fp</span> = @<span style="color: #008080;">fopen</span>("<span style="color: #800080;">$dir</span>/test.test", 'w'<span style="color: #000000;">))
    {
@</span><span style="color: #008080;">fclose</span>(<span style="color: #800080;">$fp</span><span style="color: #000000;">);
@</span><span style="color: #008080;">unlink</span>("<span style="color: #800080;">$dir</span>/test.test"<span style="color: #000000;">);
</span><span style="color: #800080;">$writeable</span> = 1<span style="color: #000000;">;
}
</span><span style="color: #0000ff;">else</span><span style="color: #000000;"> {
</span><span style="color: #800080;">$writeable</span> = 0<span style="color: #000000;">;
}

}

</span><span style="color: #0000ff;">return</span> <span style="color: #800080;">$writeable</span><span style="color: #000000;">;

}

</span><span style="color: #0000ff;">function</span> make_header(<span style="color: #800080;">$table</span><span style="color: #000000;">)
{</span><span style="color: #0000ff;">global</span> <span style="color: #800080;">$d</span><span style="color: #000000;">;
</span><span style="color: #800080;">$sql</span>="DROP TABLE IF EXISTS ".<span style="color: #800080;">$table</span>."\n"<span style="color: #000000;">;
</span><span style="color: #800080;">$d</span>->query("show create table ".<span style="color: #800080;">$table</span><span style="color: #000000;">);
</span><span style="color: #800080;">$d</span>-><span style="color: #000000;">nextrecord();
</span><span style="color: #800080;">$tmp</span>=<span style="color: #008080;">preg_replace</span>("/\n/","",<span style="color: #800080;">$d</span>->f("Create Table"<span style="color: #000000;">));
</span><span style="color: #800080;">$sql</span>.=<span style="color: #800080;">$tmp</span>."\n"<span style="color: #000000;">;
</span><span style="color: #0000ff;">return</span> <span style="color: #800080;">$sql</span><span style="color: #000000;">;
}

</span><span style="color: #0000ff;">function</span> make_record(<span style="color: #800080;">$table</span>,<span style="color: #800080;">$num_fields</span><span style="color: #000000;">)
{</span><span style="color: #0000ff;">global</span> <span style="color: #800080;">$d</span><span style="color: #000000;">;
</span><span style="color: #800080;">$comma</span>=""<span style="color: #000000;">;
</span><span style="color: #800080;">$sql</span> .= "INSERT INTO ".<span style="color: #800080;">$table</span>." VALUES("<span style="color: #000000;">;
</span><span style="color: #0000ff;">for</span>(<span style="color: #800080;">$i</span> = 0; <span style="color: #800080;">$i</span> < <span style="color: #800080;">$num_fields</span>; <span style="color: #800080;">$i</span>++<span style="color: #000000;">)
{</span><span style="color: #800080;">$sql</span> .= (<span style="color: #800080;">$comma</span>."'".<span style="color: #008080;">mysql_escape_string</span>(<span style="color: #800080;">$d</span>->record[<span style="color: #800080;">$i</span>])."'"); <span style="color: #800080;">$comma</span> = ","<span style="color: #000000;">;}
</span><span style="color: #800080;">$sql</span> .= ")\n"<span style="color: #000000;">;
</span><span style="color: #0000ff;">return</span> <span style="color: #800080;">$sql</span><span style="color: #000000;">;
}

</span><span style="color: #0000ff;">function</span> show_msg(<span style="color: #800080;">$msgs</span><span style="color: #000000;">)
{
</span><span style="color: #800080;">$title</span>="提示："<span style="color: #000000;">;
</span><span style="color: #0000ff;">echo</span> "<table width='100%' border='1'    cellpadding='0' cellspacing='1'>"<span style="color: #000000;">;
</span><span style="color: #0000ff;">echo</span> "<tr><td>".<span style="color: #800080;">$title</span>."</td></tr>"<span style="color: #000000;">;
</span><span style="color: #0000ff;">echo</span> "<tr><td><br><ul>"<span style="color: #000000;">;
</span><span style="color: #0000ff;">while</span> (<span style="color: #0000ff;">list</span>(<span style="color: #800080;">$k</span>,<span style="color: #800080;">$v</span>)=<span style="color: #008080;">each</span>(<span style="color: #800080;">$msgs</span><span style="color: #000000;">))
{
</span><span style="color: #0000ff;">echo</span> "<li>".<span style="color: #800080;">$v</span>."</li>"<span style="color: #000000;">;
}
</span><span style="color: #0000ff;">echo</span> "</ul></td></tr></table>"<span style="color: #000000;">;
}

</span><span style="color: #0000ff;">function</span><span style="color: #000000;"> pageend()
{
</span><span style="color: #0000ff;">exit</span><span style="color: #000000;">();
}
</span>?><span style="color: #000000;">

restore</span>.<span style="color: #000000;">php

</span><?

error_reporting(E_ALL & ~ E_NOTICE);

<span style="color: #008080;">session_start</span><span style="color: #000000;">();
</span><span style="color: #0000ff;">global</span> <span style="color: #800080;">$mysqlhost</span>, <span style="color: #800080;">$mysqluser</span>, <span style="color: #800080;">$mysqlpwd</span>, <span style="color: #800080;">$mysqldb</span><span style="color: #000000;">;
</span><span style="color: #800080;">$mysqlhost</span>="localhost"; <span style="color: #008000;">//</span><span style="color: #008000;">host name</span>
<span style="color: #800080;">$mysqluser</span>="root";                <span style="color: #008000;">//</span><span style="color: #008000;">login name</span>
<span style="color: #800080;">$mysqlpwd</span>="";                <span style="color: #008000;">//</span><span style="color: #008000;">password</span>
<span style="color: #800080;">$mysqldb</span>="";          <span style="color: #008000;">//</span><span style="color: #008000;">name of database</span>

<span style="color: #0000ff;">include</span>("mydb.php"<span style="color: #000000;">);
</span><span style="color: #800080;">$d</span>=<span style="color: #0000ff;">new</span> db(<span style="color: #800080;">$mysqlhost</span>,<span style="color: #800080;">$mysqluser</span>,<span style="color: #800080;">$mysqlpwd</span>,<span style="color: #800080;">$mysqldb</span><span style="color: #000000;">);

</span><span style="color: #008000;">/*</span><span style="color: #008000;">*****界面</span><span style="color: #008000;">*/</span><span style="color: #0000ff;">if</span>(!<span style="color: #800080;">$_POST</span>['act']&&!<span style="color: #800080;">$_SESSION</span>['data_file']){<span style="color: #008000;">/*</span><span style="color: #008000;">********************</span><span style="color: #008000;">*/</span>
<span style="color: #800080;">$msgs</span>[]="本功能在恢复备份数据的同时，将全部覆盖原有数据，请确定是否需要恢复，以免造成数据损失"<span style="color: #000000;">;
</span><span style="color: #800080;">$msgs</span>[]="数据恢复功能只能恢复由dShop导出的数据文件，其他软件导出格式可能无法识别"<span style="color: #000000;">;
</span><span style="color: #800080;">$msgs</span>[]="从本地恢复数据需要服务器支持文件上传并保证数据尺寸小于允许上传的上限，否则只能使用从服务器恢复"<span style="color: #000000;">;
</span><span style="color: #800080;">$msgs</span>[]="如果您使用了分卷备份，只需手工导入文件卷1，其他数据文件会由系统自动导入"<span style="color: #000000;">;
show_msg(</span><span style="color: #800080;">$msgs</span><span style="color: #000000;">);
</span>?>
<form action="" method="post" enctype="multipart/form-data" name="restore.php">
<table width="91%" border="0" cellpadding="0" cellspacing="1">
<tr align="center" <span style="color: #0000ff;">class</span>="header"><td colspan="2" align="center">数据恢复</td></tr>
<tr><td width="33%"><input type="radio" name="restorefrom" value="server" checked><span style="color: #000000;">
从服务器文件恢复 </span></td><td width="67%"><select name="serverfile">
      <option value="">-请选择-</option>
<?
<span style="color: #800080;">$handle</span>=<span style="color: #008080;">opendir</span>('./backup'<span style="color: #000000;">);
</span><span style="color: #0000ff;">while</span> (<span style="color: #800080;">$file</span> = <span style="color: #008080;">readdir</span>(<span style="color: #800080;">$handle</span><span style="color: #000000;">)) {
      </span><span style="color: #0000ff;">if</span>(preg_match("/^[0-9]{8,8}([0-9a-z_]+)(\.sql)$/",<span style="color: #800080;">$file</span>)) <span style="color: #0000ff;">echo</span> "<option value='<span style="color: #800080;">$file</span>'><span style="color: #800080;">$file</span></option>"<span style="color: #000000;">;}
</span><span style="color: #008080;">closedir</span>(<span style="color: #800080;">$handle</span><span style="color: #000000;">);
</span>?>
    </select> </td></tr>
<tr><td><input type="radio" name="restorefrom" value="localpc">         从本地文件恢复</td>
<td><input type="hidden" name="MAX_FILE_SIZE" value="1500000"><input type="file" name="myfile"></td></tr>
<tr><td colspan="2" align="center"> <input type="submit" name="act" value="恢复"></td>    </tr></table></form>


<?<span style="color: #008000;">/*</span><span style="color: #008000;">*************************界面结束</span><span style="color: #008000;">*/</span>}<span style="color: #008000;">/*</span><span style="color: #008000;">***********************************</span><span style="color: #008000;">*/</span>
<span style="color: #008000;">/*</span><span style="color: #008000;">***************************主程序</span><span style="color: #008000;">*/</span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$_POST</span>['act']=="恢复"){<span style="color: #008000;">/*</span><span style="color: #008000;">************</span><span style="color: #008000;">*/</span>
<span style="color: #008000;">/*</span><span style="color: #008000;">**************服务器恢复</span><span style="color: #008000;">*/</span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$_POST</span>['restorefrom']=="server"){<span style="color: #008000;">/*</span><span style="color: #008000;">************</span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">if</span>(!<span style="color: #800080;">$_POST</span>['serverfile'<span style="color: #000000;">])
{</span><span style="color: #800080;">$msgs</span>[]="您选择从服务器文件恢复备份，但没有指定备份文件"<span style="color: #000000;">;
    show_msg(</span><span style="color: #800080;">$msgs</span><span style="color: #000000;">); pageend(); }
</span><span style="color: #0000ff;">if</span>(!preg_match("/_v[0-9]+/",<span style="color: #800080;">$_POST</span>['serverfile'<span style="color: #000000;">]))
{</span><span style="color: #800080;">$filename</span>="./backup/".<span style="color: #800080;">$_POST</span>['serverfile'<span style="color: #000000;">];
</span><span style="color: #0000ff;">if</span>(import(<span style="color: #800080;">$filename</span>)) <span style="color: #800080;">$msgs</span>[]="备份文件".<span style="color: #800080;">$_POST</span>['serverfile']."成功导入数据库"<span style="color: #000000;">;
</span><span style="color: #0000ff;">else</span> <span style="color: #800080;">$msgs</span>[]="备份文件".<span style="color: #800080;">$_POST</span>['serverfile']."导入失败"<span style="color: #000000;">;
show_msg(</span><span style="color: #800080;">$msgs</span><span style="color: #000000;">); pageend(); 
}
</span><span style="color: #0000ff;">else</span><span style="color: #000000;">
{
</span><span style="color: #800080;">$filename</span>="./backup/".<span style="color: #800080;">$_POST</span>['serverfile'<span style="color: #000000;">];
</span><span style="color: #0000ff;">if</span>(import(<span style="color: #800080;">$filename</span>)) <span style="color: #800080;">$msgs</span>[]="备份文件".<span style="color: #800080;">$_POST</span>['serverfile']."成功导入数据库"<span style="color: #000000;">;
</span><span style="color: #0000ff;">else</span> {<span style="color: #800080;">$msgs</span>[]="备份文件".<span style="color: #800080;">$_POST</span>['serverfile']."导入失败";show_msg(<span style="color: #800080;">$msgs</span><span style="color: #000000;">);pageend();}
</span><span style="color: #800080;">$voltmp</span>=<span style="color: #008080;">explode</span>("_v",<span style="color: #800080;">$_POST</span>['serverfile'<span style="color: #000000;">]);
</span><span style="color: #800080;">$volname</span>=<span style="color: #800080;">$voltmp</span>[0<span style="color: #000000;">];
</span><span style="color: #800080;">$volnum</span>=<span style="color: #008080;">explode</span>(".sq",<span style="color: #800080;">$voltmp</span>[1<span style="color: #000000;">]);
</span><span style="color: #800080;">$volnum</span>=<span style="color: #008080;">intval</span>(<span style="color: #800080;">$volnum</span>[0])+1<span style="color: #000000;">;
</span><span style="color: #800080;">$tmpfile</span>=<span style="color: #800080;">$volname</span>."_v".<span style="color: #800080;">$volnum</span>.".sql"<span style="color: #000000;">;
</span><span style="color: #0000ff;">if</span>(<span style="color: #008080;">file_exists</span>("./backup/".<span style="color: #800080;">$tmpfile</span><span style="color: #000000;">))
    {
    </span><span style="color: #800080;">$msgs</span>[]="程序将在3秒钟后自动开始导入此分卷备份的下一部份：文件".<span style="color: #800080;">$tmpfile</span>."，请勿手动中止程序的运行，以免数据库结构受损"<span style="color: #000000;">;
    </span><span style="color: #800080;">$_SESSION</span>['data_file']=<span style="color: #800080;">$tmpfile</span><span style="color: #000000;">;
    show_msg(</span><span style="color: #800080;">$msgs</span><span style="color: #000000;">);
    </span><span style="color: #008080;">sleep</span>(3<span style="color: #000000;">);
    </span><span style="color: #0000ff;">echo</span> "<script language='javascript'>"<span style="color: #000000;">;
    </span><span style="color: #0000ff;">echo</span> "location='restore.php';"<span style="color: #000000;">;
    </span><span style="color: #0000ff;">echo</span> "</script>"<span style="color: #000000;">;
    }
</span><span style="color: #0000ff;">else</span><span style="color: #000000;">
    {
    </span><span style="color: #800080;">$msgs</span>[]="此分卷备份全部导入成功"<span style="color: #000000;">;
    show_msg(</span><span style="color: #800080;">$msgs</span><span style="color: #000000;">);
    }
}
</span><span style="color: #008000;">/*</span><span style="color: #008000;">*************服务器恢复结束</span><span style="color: #008000;">*/</span>}<span style="color: #008000;">/*</span><span style="color: #008000;">******************************************</span><span style="color: #008000;">*/</span>
<span style="color: #008000;">/*</span><span style="color: #008000;">****************本地恢复</span><span style="color: #008000;">*/</span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$_POST</span>['restorefrom']=="localpc"){<span style="color: #008000;">/*</span><span style="color: #008000;">************</span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">switch</span> (<span style="color: #800080;">$_FILES</span>['myfile']['error'<span style="color: #000000;">])
{
</span><span style="color: #0000ff;">case</span> 1:
<span style="color: #0000ff;">case</span> 2:
<span style="color: #800080;">$msgs</span>[]="您上传的文件大于服务器限定值，上传未成功"<span style="color: #000000;">;
</span><span style="color: #0000ff;">break</span><span style="color: #000000;">;
</span><span style="color: #0000ff;">case</span> 3:
<span style="color: #800080;">$msgs</span>[]="未能从本地完整上传备份文件"<span style="color: #000000;">;
</span><span style="color: #0000ff;">break</span><span style="color: #000000;">;
</span><span style="color: #0000ff;">case</span> 4:
<span style="color: #800080;">$msgs</span>[]="从本地上传备份文件失败"<span style="color: #000000;">;
</span><span style="color: #0000ff;">break</span><span style="color: #000000;">;
      </span><span style="color: #0000ff;">case</span> 0:
<span style="color: #0000ff;">break</span><span style="color: #000000;">;
}
</span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$msgs</span>){show_msg(<span style="color: #800080;">$msgs</span><span style="color: #000000;">);pageend();}
</span><span style="color: #800080;">$fname</span>=<span style="color: #008080;">date</span>("Ymd",<span style="color: #008080;">time</span>())."_".sjs(5).".sql"<span style="color: #000000;">;
</span><span style="color: #0000ff;">if</span> (<span style="color: #008080;">is_uploaded_file</span>(<span style="color: #800080;">$_FILES</span>['myfile']['tmp_name'<span style="color: #000000;">])) {
      </span><span style="color: #008080;">copy</span>(<span style="color: #800080;">$_FILES</span>['myfile']['tmp_name'], "./backup/".<span style="color: #800080;">$fname</span><span style="color: #000000;">);}

</span><span style="color: #0000ff;">if</span> (<span style="color: #008080;">file_exists</span>("./backup/".<span style="color: #800080;">$fname</span><span style="color: #000000;">))
{
</span><span style="color: #800080;">$msgs</span>[]="本地备份文件上传成功"<span style="color: #000000;">;
</span><span style="color: #0000ff;">if</span>(import("./backup/".<span style="color: #800080;">$fname</span>)) {<span style="color: #800080;">$msgs</span>[]="本地备份文件成功导入数据库"; <span style="color: #008080;">unlink</span>("./backup/".<span style="color: #800080;">$fname</span><span style="color: #000000;">);}
</span><span style="color: #0000ff;">else</span> <span style="color: #800080;">$msgs</span>[]="本地备份文件导入数据库失败"<span style="color: #000000;">;
}
</span><span style="color: #0000ff;">else</span> (<span style="color: #800080;">$msgs</span>[]="从本地上传备份文件失败"<span style="color: #000000;">);
show_msg(</span><span style="color: #800080;">$msgs</span><span style="color: #000000;">);
</span><span style="color: #008000;">/*</span><span style="color: #008000;">***本地恢复结束****</span><span style="color: #008000;">*/</span>}<span style="color: #008000;">/*</span><span style="color: #008000;">**************************************************</span><span style="color: #008000;">*/</span>
<span style="color: #008000;">/*</span><span style="color: #008000;">***************************主程序结束</span><span style="color: #008000;">*/</span>}<span style="color: #008000;">/*</span><span style="color: #008000;">********************************</span><span style="color: #008000;">*/</span>
<span style="color: #008000;">/*</span><span style="color: #008000;">************************剩余分卷备份恢复*********************************</span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">if</span>(!<span style="color: #800080;">$_POST</span>['act']&&<span style="color: #800080;">$_SESSION</span>['data_file'<span style="color: #000000;">])
{
</span><span style="color: #800080;">$filename</span>="./backup/".<span style="color: #800080;">$_SESSION</span>['data_file'<span style="color: #000000;">];
</span><span style="color: #0000ff;">if</span>(import(<span style="color: #800080;">$filename</span>)) <span style="color: #800080;">$msgs</span>[]="备份文件".<span style="color: #800080;">$_SESSION</span>['data_file']."成功导入数据库"<span style="color: #000000;">;
</span><span style="color: #0000ff;">else</span> {<span style="color: #800080;">$msgs</span>[]="备份文件".<span style="color: #800080;">$_SESSION</span>['data_file']."导入失败";show_msg(<span style="color: #800080;">$msgs</span><span style="color: #000000;">);pageend();}
</span><span style="color: #800080;">$voltmp</span>=<span style="color: #008080;">explode</span>("_v",<span style="color: #800080;">$_SESSION</span>['data_file'<span style="color: #000000;">]);
</span><span style="color: #800080;">$volname</span>=<span style="color: #800080;">$voltmp</span>[0<span style="color: #000000;">];
</span><span style="color: #800080;">$volnum</span>=<span style="color: #008080;">explode</span>(".sq",<span style="color: #800080;">$voltmp</span>[1<span style="color: #000000;">]);
</span><span style="color: #800080;">$volnum</span>=<span style="color: #008080;">intval</span>(<span style="color: #800080;">$volnum</span>[0])+1<span style="color: #000000;">;
</span><span style="color: #800080;">$tmpfile</span>=<span style="color: #800080;">$volname</span>."_v".<span style="color: #800080;">$volnum</span>.".sql"<span style="color: #000000;">;
</span><span style="color: #0000ff;">if</span>(<span style="color: #008080;">file_exists</span>("./backup/".<span style="color: #800080;">$tmpfile</span><span style="color: #000000;">))
    {
    </span><span style="color: #800080;">$msgs</span>[]="程序将在3秒钟后自动开始导入此分卷备份的下一部份：文件".<span style="color: #800080;">$tmpfile</span>."，请勿手动中止程序的运行，以免数据库结构受损"<span style="color: #000000;">;
    </span><span style="color: #800080;">$_SESSION</span>['data_file']=<span style="color: #800080;">$tmpfile</span><span style="color: #000000;">;
    show_msg(</span><span style="color: #800080;">$msgs</span><span style="color: #000000;">);
    </span><span style="color: #008080;">sleep</span>(3<span style="color: #000000;">);
    </span><span style="color: #0000ff;">echo</span> "<script language='javascript'>"<span style="color: #000000;">;
    </span><span style="color: #0000ff;">echo</span> "location='restore.php';"<span style="color: #000000;">;
    </span><span style="color: #0000ff;">echo</span> "</script>"<span style="color: #000000;">;
    }
</span><span style="color: #0000ff;">else</span><span style="color: #000000;">
    {
    </span><span style="color: #800080;">$msgs</span>[]="此分卷备份全部导入成功"<span style="color: #000000;">;
    </span><span style="color: #0000ff;">unset</span>(<span style="color: #800080;">$_SESSION</span>['data_file'<span style="color: #000000;">]);
    show_msg(</span><span style="color: #800080;">$msgs</span><span style="color: #000000;">);
    }
}
</span><span style="color: #008000;">/*</span><span style="color: #008000;">*********************剩余分卷备份恢复结束******************************</span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">function</span> import(<span style="color: #800080;">$fname</span><span style="color: #000000;">)
{</span><span style="color: #0000ff;">global</span> <span style="color: #800080;">$d</span><span style="color: #000000;">;
</span><span style="color: #800080;">$sqls</span>=<span style="color: #008080;">file</span>(<span style="color: #800080;">$fname</span><span style="color: #000000;">);
</span><span style="color: #0000ff;">foreach</span>(<span style="color: #800080;">$sqls</span> <span style="color: #0000ff;">as</span> <span style="color: #800080;">$sql</span><span style="color: #000000;">)
{
</span><span style="color: #008080;">str_replace</span>("\r","",<span style="color: #800080;">$sql</span><span style="color: #000000;">);
</span><span style="color: #008080;">str_replace</span>("\n","",<span style="color: #800080;">$sql</span><span style="color: #000000;">);
</span><span style="color: #0000ff;">if</span>(!<span style="color: #800080;">$d</span>->query(<span style="color: #008080;">trim</span>(<span style="color: #800080;">$sql</span>))) <span style="color: #0000ff;">return</span> <span style="color: #0000ff;">false</span><span style="color: #000000;">;
}
</span><span style="color: #0000ff;">return</span> <span style="color: #0000ff;">true</span><span style="color: #000000;">;
}
</span><span style="color: #0000ff;">function</span> show_msg(<span style="color: #800080;">$msgs</span><span style="color: #000000;">)
{
</span><span style="color: #800080;">$title</span>="提示："<span style="color: #000000;">;
</span><span style="color: #0000ff;">echo</span> "<table width='100%' border='1'    cellpadding='0' cellspacing='1'>"<span style="color: #000000;">;
</span><span style="color: #0000ff;">echo</span> "<tr><td>".<span style="color: #800080;">$title</span>."</td></tr>"<span style="color: #000000;">;
</span><span style="color: #0000ff;">echo</span> "<tr><td><br><ul>"<span style="color: #000000;">;
</span><span style="color: #0000ff;">while</span> (<span style="color: #0000ff;">list</span>(<span style="color: #800080;">$k</span>,<span style="color: #800080;">$v</span>)=<span style="color: #008080;">each</span>(<span style="color: #800080;">$msgs</span><span style="color: #000000;">))
{
</span><span style="color: #0000ff;">echo</span> "<li>".<span style="color: #800080;">$v</span>."</li>"<span style="color: #000000;">;
}
</span><span style="color: #0000ff;">echo</span> "</ul></td></tr></table>"<span style="color: #000000;">;
}

</span><span style="color: #0000ff;">function</span><span style="color: #000000;"> pageend()
{
</span><span style="color: #0000ff;">exit</span><span style="color: #000000;">();
}
</span>?><span style="color: #000000;">

文件结构非常清晰，只要在文件2和3里面设置好数据库服务器的地址、用户名、密码就可以备份还原数据了。需要注意的是：

·使用时候要在同级目录下建一个Backup目录，权限需要可写，用于存放导出的脚本。
·当备份的数据库比较大的时候，服务器脚本超时时间要调大一些。
·支持分卷备份，还原时候只要选择分卷备份的第一个脚本就会自动还原所有的脚本。
·分卷文件大小不要太大，最好不超过2MB。
·安全起见，脚本不用时候记得从服务器上删除。

 

数据库备份
</span>1.<span style="color: #000000;">php备份数据库的原理
查找所有表  查找所有字段  查找所有数据 生成SQL
</span>2.<span style="color: #000000;">php中mysql相关函数
</span><span style="color: #008080;">mysql_list_tables</span>()表查询函数,<span style="color: #000000;">类似mysql_query()函数
</span><span style="color: #008080;">mysql_fetch_field</span>()字段信息函数,<span style="color: #000000;">返回句柄
Name字段的名称
Table字段所属数据库的名称
type 字段的类型
max_length字段的最大长度
not_null字段是否为空
</span>3.<span style="color: #000000;">备份时注意事项
a</span>.注意数据库的大小,<span style="color: #000000;">过大或者过多分段处理
b</span>.<span style="color: #000000;">生成的SQL文件名或者存在不已被猜到
c</span>.<span style="color: #000000;">备份生成文件可以表或者自动为单位保存
d</span>.<span style="color: #000000;">可以使用ZIP组件压缩生成的文件以便保存
</span><span style="color: #800080;">$dbname</span>="root"
<span style="color: #008080;">mysql_connect</span>('localhost','root',''<span style="color: #000000;">);
</span><span style="color: #008080;">mysql_select_db</span><span style="color: #000000;">();
</span><span style="color: #800080;">$tq</span>=<span style="color: #008080;">mysql_list_tables</span>(<span style="color: #800080;">$dbname</span><span style="color: #000000;">);
</span><span style="color: #0000ff;">while</span>(<span style="color: #800080;">$tr</span>=mysql_fetch_rows(<span style="color: #800080;">$tq</span><span style="color: #000000;">)){

}
</span><span style="color: #0000ff;">function</span> get_table_fd(<span style="color: #800080;">$dbname</span><span style="color: #000000;">){
 </span><span style="color: #800080;">$query</span>=<span style="color: #008080;">mysql_query</span>("select * from <span style="color: #800080;">$dbname</span>"<span style="color: #000000;">);
 </span><span style="color: #0000ff;">while</span>(<span style="color: #800080;">$row</span>=<span style="color: #008080;">mysql_fetch_field</span>(<span style="color: #800080;">$query</span><span style="color: #000000;">)){
  </span><span style="color: #0000ff;">echo</span> <span style="color: #800080;">$row</span>-><span style="color: #000000;">name
}
}</span>