PHP数据库备份与恢复，PHP数据库备份恢复

PHP+MYSQL的数据库怎备份与还原？

php对mysql数据库的备份及还原：

집

백엔드 개발

PHP 튜토리얼

PHP数据库备份与恢复，PHP数据库备份恢复_PHP教程

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jul 13, 2016 am 10:21 AM

mysql

PHP数据库备份与恢复，PHP数据库备份恢复

先说下关于数据库备份与恢复的原理：

1、查找所有表->2、查找所有字段->3、查找所有数据->4、生成SQL

备份注意点：

2=>需要列出所有字段名，字段类型等相关信息

3=>读取数据出来注意特殊符号的转换addslashes()

4=>把数据格式化生成对应的SQL

mysql_list_tables() 表查询函数，类似mysql_query() 函数 mysql_fetch_field() 字段信息函数，返回句柄 恢复注意点： 1、注意数据库的大小，过大或者过多的表分段处理
2、生成的SQL文件名或者存放不易被猜到
3、备份生成文件可以表或者字段为单位保存
4、可以使用ZIP组件压缩生成的文件以便保持迷你版代码：

<?<span>php
</span><span>$mysql_dbname</span> = "php100"<span>;
</span><span>mysql_connect</span>("localhost", "root", ""<span>);
</span><span>mysql_select_db</span>(<span>$mysql_dbname</span><span>);

</span><span>$sql_list</span> = <span>mysql_list_tables</span>(<span>$mysql_dbname</span><span>);
</span><span>while</span> (<span>$row_data</span> = <span>mysql_fetch_row</span>(<span>$sql_list</span><span>)) {
</span><span>echo</span> <span>$row_data</span>[0] . "<br>"<span>;
get_table_fd(</span><span>$row_data</span>[0], "sql"<span>);

</span><span>//</span><span>  $fp=fopen("sql/$tablename.sql","w+");
//  fwrite($fp,$field);
//  fclose($fp);</span>
<span>}

</span><span>function</span> get_table_fd(<span>$tablename</span><span>) {
</span><span>$field</span> = "CREATE TABLE `<span>$tablename</span>`(\n"<span>;
</span><span>$result</span> = <span>mysql_query</span>("select * from <span>$tablename</span>"<span>);
</span><span>while</span> (<span>$meta</span> = <span>mysql_fetch_field</span>(<span>$result</span><span>)) {
</span><span>if</span> (<span>$meta</span>-><span>not_null)
</span><span>$not_null</span> = "not_null"<span>;
</span><span>$field</span> .= "`<span>$meta</span>->name` <span>$meta</span>->type(<span>$meta</span>->max_length) <span>$not_null</span>; \n"<span>;
}
</span><span>$field</span> .= ")\n"<span>;
</span><span>return</span> <span>$field</span><span>;
}


</span>?>

로그인 후 복사

在网上找到个不错的类库，可直接拿来用，记录一下

1、db.php 数据库类

2、backup.php 备份

3、restore.php 恢复

下载附件

db.php

<span> 1</span> <?
<span> 2</span> <span>class</span><span> db{
</span><span> 3</span> 
<span> 4</span> <span>var</span> <span>$linkid</span><span>;
</span><span> 5</span> <span>var</span> <span>$sqlid</span><span>;
</span><span> 6</span> <span>var</span> <span>$record</span><span>;
</span><span> 7</span> 
<span> 8</span> <span>function</span> db(<span>$host</span>="",<span>$username</span>="",<span>$password</span>="",<span>$database</span>=""<span>)
</span><span> 9</span> <span>    {
</span><span>10</span>     <span>if</span>(!<span>$this</span>->linkid)  @<span>$this</span>->linkid = <span>mysql_connect</span>(<span>$host</span>, <span>$username</span>, <span>$password</span>) or <span>die</span>("连接服务器失败."<span>);
</span><span>11</span>     @<span>mysql_select_db</span>(<span>$database</span>,<span>$this</span>->linkid) or <span>die</span>("无法打开数据库"<span>);
</span><span>12</span>     <span>mysql_query</span>('set names gbk'<span>);
</span><span>13</span>     <span>return</span> <span>$this</span>-><span>linkid;}
</span><span>14</span> 
<span>15</span> <span>function</span> query(<span>$sql</span><span>)
</span><span>16</span>     {<span>if</span>(<span>$this</span>->sqlid=<span>mysql_query</span>(<span>$sql</span>,<span>$this</span>->linkid)) <span>return</span> <span>$this</span>-><span>sqlid;
</span><span>17</span>     <span>else</span><span> {
</span><span>18</span>         <span>$this</span>->err_report(<span>$sql</span>,<span>mysql_error</span><span>);
</span><span>19</span>     <span>return</span> <span>false</span><span>;}
</span><span>20</span> <span>    }
</span><span>21</span> 
<span>22</span> <span>function</span> nr(<span>$sql_id</span>=""<span>)
</span><span>23</span>     {<span>if</span>(!<span>$sql_id</span>) <span>$sql_id</span>=<span>$this</span>-><span>sqlid;
</span><span>24</span>     <span>return</span> <span>mysql_num_rows</span>(<span>$sql_id</span><span>);}
</span><span>25</span> 
<span>26</span> <span>function</span> nf(<span>$sql_id</span>=""<span>)
</span><span>27</span>     {<span>if</span>(!<span>$sql_id</span>) <span>$sql_id</span>=<span>$this</span>-><span>sqlid;
</span><span>28</span>     <span>return</span> <span>mysql_num_fields</span>(<span>$sql_id</span><span>);}
</span><span>29</span> 
<span>30</span> <span>function</span> nextrecord(<span>$sql_id</span>=""<span>)
</span><span>31</span>     {<span>if</span>(!<span>$sql_id</span>) <span>$sql_id</span>=<span>$this</span>-><span>sqlid;
</span><span>32</span>     <span>if</span>(<span>$this</span>->record=<span>mysql_fetch_array</span>(<span>$sql_id</span>))  <span>return</span> <span>$this</span>-><span>record;
</span><span>33</span>     <span>else</span> <span>return</span> <span>false</span><span>;
</span><span>34</span> <span>    }
</span><span>35</span> 
<span>36</span> <span>function</span> f(<span>$name</span><span>)
</span><span>37</span> <span>    {
</span><span>38</span>     <span>if</span>(<span>$this</span>->record[<span>$name</span>]) <span>return</span> <span>$this</span>->record[<span>$name</span><span>];
</span><span>39</span>     <span>else</span> <span>return</span> <span>false</span><span>;
</span><span>40</span> <span>    }
</span><span>41</span> 
<span>42</span> <span>function</span> close() {<span>mysql_close</span>(<span>$this</span>-><span>linkid);}
</span><span>43</span> 
<span>44</span> <span>function</span> lock(<span>$tblname</span>,<span>$op</span>="WRITE"<span>)
</span><span>45</span>     {<span>if</span>(<span>mysql_query</span>("lock tables ".<span>$tblname</span>." ".<span>$op</span>)) <span>return</span> <span>true</span>; <span>else</span> <span>return</span> <span>false</span><span>;}
</span><span>46</span> 
<span>47</span> <span>function</span><span> unlock()
</span><span>48</span>     {<span>if</span>(<span>mysql_query</span>("unlock tables")) <span>return</span> <span>true</span>; <span>else</span> <span>return</span> <span>false</span><span>;}
</span><span>49</span> 
<span>50</span> <span>function</span><span> ar() {
</span><span>51</span>     <span>return</span> @<span>mysql_affected_rows</span>(<span>$this</span>-><span>linkid);
</span><span>52</span> <span>  }
</span><span>53</span> 
<span>54</span> <span>function</span><span> i_id() {
</span><span>55</span>         <span>return</span> <span>mysql_insert_id</span><span>();
</span><span>56</span> <span>    }
</span><span>57</span> 
<span>58</span> <span>function</span> err_report(<span>$sql</span>,<span>$err</span><span>)
</span><span>59</span> <span>    {
</span><span>60</span> <span>echo</span> "Mysql查询错误<br>"<span>;
</span><span>61</span> <span>echo</span> "查询语句：".<span>$sql</span>."<br>"<span>;
</span><span>62</span> <span>echo</span> "错误信息：".<span>$err</span><span>;
</span><span>63</span> <span>    }
</span><span>64</span> }?>

로그인 후 복사

backup.php

<span>  1</span> <?
<span>  2</span> <span>global</span> <span>$mysqlhost</span>, <span>$mysqluser</span>, <span>$mysqlpwd</span>, <span>$mysqldb</span><span>;
</span><span>  3</span> <span>$mysqlhost</span>=""; <span>//</span><span>host name</span>
<span>  4</span> <span>$mysqluser</span>="";              <span>//</span><span>login name</span>
<span>  5</span> <span>$mysqlpwd</span>="";              <span>//</span><span>password</span>
<span>  6</span> <span>$mysqldb</span>="";        <span>//</span><span>name of database</span>
<span>  7</span> 
<span>  8</span> <span>include</span>("mydb.php"<span>);
</span><span>  9</span> <span>$d</span>=<span>new</span> db(<span>$mysqlhost</span>,<span>$mysqluser</span>,<span>$mysqlpwd</span>,<span>$mysqldb</span><span>);
</span><span> 10</span> <span>/*</span><span>--------------界面--------------</span><span>*/</span><span>if</span>(!<span>$_POST</span>['act']){<span>/*</span><span>----------------------</span><span>*/</span>
<span> 11</span> <span>$msgs</span>[]="服务器备份目录为backup"<span>;
</span><span> 12</span> <span>$msgs</span>[]="对于较大的数据表，强烈建议使用分卷备份"<span>;
</span><span> 13</span> <span>$msgs</span>[]="只有选择备份到服务器，才能使用分卷备份功能"<span>;
</span><span> 14</span> show_msg(<span>$msgs</span><span>);
</span><span> 15</span> ?>
<span> 16</span> <form name="form1" method="post" action="backup.php">
<span> 17</span>   <table width="99%" border="1" cellpadding='0' cellspacing='1'>
<span> 18</span>     <tr align="center" <span>class</span>='header'><td colspan="2">数据备份</td></tr>
<span> 19</span>     <tr><td colspan="2">备份方式</td></tr>
<span> 20</span>     <tr><td><input type="radio" name="bfzl" value="quanbubiao">        备份全部数据</td><td>备份全部数据表中的数据到一个备份文件</td></tr>
<span> 21</span>     <tr><td><input type="radio" name="bfzl" value="danbiao"><span>备份单张表数据 
</span><span> 22</span>         <select name="tablename"><option value="">请选择</option>
<span> 23</span>           <?
<span> 24</span>         <span>$d</span>->query("show table status from <span>$mysqldb</span>"<span>);
</span><span> 25</span>         <span>while</span>(<span>$d</span>-><span>nextrecord()){
</span><span> 26</span>         <span>echo</span> "<option value='".<span>$d</span>->f('Name')."'>".<span>$d</span>->f('Name')."</option>"<span>;}
</span><span> 27</span>         ?>
<span> 28</span>         </select></td><td>备份选中数据表中的数据到单独的备份文件</td></tr>
<span> 29</span>     <tr><td colspan="2">使用分卷备份</td></tr>
<span> 30</span>     <tr><td colspan="2"><input type="checkbox" name="fenjuan" value="yes">
<span> 31</span>         分卷备份 <input name="filesize" type="text" size="10">K</td></tr>
<span> 32</span>     <tr><td colspan="2">选择目标位置</td></tr>
<span> 33</span>     <tr><td colspan="2"><input type="radio" name="weizhi" value="server" checked>备份到服务器</td></tr><tr <span>class</span>="cells"><td colspan='2'> <input type="radio" name="weizhi" value="localpc">
<span> 34</span>         备份到本地</td></tr>
<span> 35</span>     <tr><td colspan="2" align='center'><input type="submit" name="act" value="备份"></td></tr>
<span> 36</span>   </table></form>
<span> 37</span> <?<span>/*</span><span>-------------界面结束-------------</span><span>*/</span>}<span>/*</span><span>---------------------------------</span><span>*/</span>
<span> 38</span> <span>/*</span><span>----</span><span>*/</span><span>else</span>{<span>/*</span><span>--------------主程序-----------------------------------------</span><span>*/</span>
<span> 39</span> <span>if</span>(<span>$_POST</span>['weizhi']=="localpc"&&<span>$_POST</span>['fenjuan']=='yes'<span>)
</span><span> 40</span>     {<span>$msgs</span>[]="只有选择备份到服务器，才能使用分卷备份功能"<span>;
</span><span> 41</span> show_msg(<span>$msgs</span><span>); pageend();}
</span><span> 42</span> <span>if</span>(<span>$_POST</span>['fenjuan']=="yes"&&!<span>$_POST</span>['filesize'<span>])
</span><span> 43</span>     {<span>$msgs</span>[]="您选择了分卷备份功能，但未填写分卷文件大小"<span>;
</span><span> 44</span> show_msg(<span>$msgs</span><span>); pageend();}
</span><span> 45</span> <span>if</span>(<span>$_POST</span>['weizhi']=="server"&&!writeable("./backup"<span>))
</span><span> 46</span>     {<span>$msgs</span>[]="备份文件存放目录'./backup'不可写，请修改目录属性"<span>;
</span><span> 47</span> show_msg(<span>$msgs</span><span>); pageend();}
</span><span> 48</span> 
<span> 49</span> <span>/*</span><span>----------备份全部表-------------</span><span>*/</span><span>if</span>(<span>$_POST</span>['bfzl']=="quanbubiao"){<span>/*</span><span>----</span><span>*/</span>
<span> 50</span> <span>/*</span><span>----不分卷</span><span>*/</span><span>if</span>(!<span>$_POST</span>['fenjuan']){<span>/*</span><span>--------------------------------</span><span>*/</span>
<span> 51</span> <span>if</span>(!<span>$tables</span>=<span>$d</span>->query("show table status from <span>$mysqldb</span>"<span>))
</span><span> 52</span>     {<span>$msgs</span>[]="读数据库结构错误"; show_msg(<span>$msgs</span><span>); pageend();}
</span><span> 53</span> <span>$sql</span>=""<span>;
</span><span> 54</span> <span>while</span>(<span>$d</span>->nextrecord(<span>$tables</span><span>))
</span><span> 55</span> <span>    {
</span><span> 56</span>     <span>$table</span>=<span>$d</span>->f("Name"<span>);
</span><span> 57</span>     <span>$sql</span>.=make_header(<span>$table</span><span>);
</span><span> 58</span>     <span>$d</span>->query("select * from <span>$table</span>"<span>);
</span><span> 59</span>     <span>$num_fields</span>=<span>$d</span>-><span>nf();
</span><span> 60</span>     <span>while</span>(<span>$d</span>-><span>nextrecord())
</span><span> 61</span>     {<span>$sql</span>.=make_record(<span>$table</span>,<span>$num_fields</span><span>);}
</span><span> 62</span> <span>    }
</span><span> 63</span> <span>$filename</span>=<span>date</span>("Ymd",<span>time</span>())."_all.sql"<span>;
</span><span> 64</span> <span>if</span>(<span>$_POST</span>['weizhi']=="localpc") down_file(<span>$sql</span>,<span>$filename</span><span>);
</span><span> 65</span> <span>elseif</span>(<span>$_POST</span>['weizhi']=="server"<span>)
</span><span> 66</span>     {<span>if</span>(write_file(<span>$sql</span>,<span>$filename</span><span>))
</span><span> 67</span> <span>$msgs</span>[]="全部数据表数据备份完成,生成备份文件'./backup/<span>$filename</span>'"<span>;
</span><span> 68</span>     <span>else</span> <span>$msgs</span>[]="备份全部数据表失败"<span>;
</span><span> 69</span>     show_msg(<span>$msgs</span><span>);
</span><span> 70</span> <span>    pageend();
</span><span> 71</span> <span>    }
</span><span> 72</span> <span>/*</span><span>-----------------不要卷结束</span><span>*/</span>}<span>/*</span><span>-----------------------</span><span>*/</span>
<span> 73</span> <span>/*</span><span>-----------------分卷</span><span>*/</span><span>else</span>{<span>/*</span><span>-------------------------</span><span>*/</span>
<span> 74</span> <span>if</span>(!<span>$_POST</span>['filesize'<span>])
</span><span> 75</span>     {<span>$msgs</span>[]="请填写备份文件分卷大小"; show_msg(<span>$msgs</span><span>);pageend();}
</span><span> 76</span> <span>if</span>(!<span>$tables</span>=<span>$d</span>->query("show table status from <span>$mysqldb</span>"<span>))
</span><span> 77</span>     {<span>$msgs</span>[]="读数据库结构错误"; show_msg(<span>$msgs</span><span>); pageend();}
</span><span> 78</span> <span>$sql</span>=""; <span>$p</span>=1<span>;
</span><span> 79</span> <span>$filename</span>=<span>date</span>("Ymd",<span>time</span>())."_all"<span>;
</span><span> 80</span> <span>while</span>(<span>$d</span>->nextrecord(<span>$tables</span><span>))
</span><span> 81</span> <span>{
</span><span> 82</span>     <span>$table</span>=<span>$d</span>->f("Name"<span>);
</span><span> 83</span>     <span>$sql</span>.=make_header(<span>$table</span><span>);
</span><span> 84</span>     <span>$d</span>->query("select * from <span>$table</span>"<span>);
</span><span> 85</span>     <span>$num_fields</span>=<span>$d</span>-><span>nf();
</span><span> 86</span>     <span>while</span>(<span>$d</span>-><span>nextrecord())
</span><span> 87</span>     {<span>$sql</span>.=make_record(<span>$table</span>,<span>$num_fields</span><span>);
</span><span> 88</span>     <span>if</span>(<span>strlen</span>(<span>$sql</span>)>=<span>$_POST</span>['filesize']*1000<span>){
</span><span> 89</span>             <span>$filename</span>.=("_v".<span>$p</span>.".sql"<span>);
</span><span> 90</span>             <span>if</span>(write_file(<span>$sql</span>,<span>$filename</span><span>))
</span><span> 91</span>             <span>$msgs</span>[]="全部数据表-卷-".<span>$p</span>."-数据备份完成,生成备份文件'./backup/<span>$filename</span>'"<span>;
</span><span> 92</span>             <span>else</span> <span>$msgs</span>[]="备份表-".<span>$_POST</span>['tablename']."-失败"<span>;
</span><span> 93</span>             <span>$p</span>++<span>;
</span><span> 94</span>             <span>$filename</span>=<span>date</span>("Ymd",<span>time</span>())."_all"<span>;
</span><span> 95</span>             <span>$sql</span>=""<span>;}
</span><span> 96</span> <span>    }
</span><span> 97</span> <span>}
</span><span> 98</span> <span>if</span>(<span>$sql</span>!=""){<span>$filename</span>.=("_v".<span>$p</span>.".sql"<span>);        
</span><span> 99</span> <span>if</span>(write_file(<span>$sql</span>,<span>$filename</span><span>))
</span><span>100</span> <span>$msgs</span>[]="全部数据表-卷-".<span>$p</span>."-数据备份完成,生成备份文件'./backup/<span>$filename</span>'"<span>;}
</span><span>101</span> show_msg(<span>$msgs</span><span>);
</span><span>102</span> <span>/*</span><span>---------------------分卷结束</span><span>*/</span>}<span>/*</span><span>--------------------------------------</span><span>*/</span>
<span>103</span> <span>/*</span><span>--------备份全部表结束</span><span>*/</span>}<span>/*</span><span>---------------------------------------------</span><span>*/</span>
<span>104</span> 
<span>105</span> <span>/*</span><span>--------备份单表------</span><span>*/</span><span>elseif</span>(<span>$_POST</span>['bfzl']=="danbiao"){<span>/*</span><span>------------</span><span>*/</span>
<span>106</span> <span>if</span>(!<span>$_POST</span>['tablename'<span>])
</span><span>107</span>     {<span>$msgs</span>[]="请选择要备份的数据表"; show_msg(<span>$msgs</span><span>); pageend();}
</span><span>108</span> <span>/*</span><span>--------不分卷</span><span>*/</span><span>if</span>(!<span>$_POST</span>['fenjuan']){<span>/*</span><span>-------------------------------</span><span>*/</span>
<span>109</span> <span>$sql</span>=make_header(<span>$_POST</span>['tablename'<span>]);
</span><span>110</span> <span>$d</span>->query("select * from ".<span>$_POST</span>['tablename'<span>]);
</span><span>111</span> <span>$num_fields</span>=<span>$d</span>-><span>nf();
</span><span>112</span> <span>while</span>(<span>$d</span>-><span>nextrecord())
</span><span>113</span>     {<span>$sql</span>.=make_record(<span>$_POST</span>['tablename'],<span>$num_fields</span><span>);}
</span><span>114</span> <span>$filename</span>=<span>date</span>("Ymd",<span>time</span>())."_".<span>$_POST</span>['tablename'].".sql"<span>;
</span><span>115</span> <span>if</span>(<span>$_POST</span>['weizhi']=="localpc") down_file(<span>$sql</span>,<span>$filename</span><span>);
</span><span>116</span> <span>elseif</span>(<span>$_POST</span>['weizhi']=="server"<span>)
</span><span>117</span>     {<span>if</span>(write_file(<span>$sql</span>,<span>$filename</span><span>))
</span><span>118</span> <span>$msgs</span>[]="表-".<span>$_POST</span>['tablename']."-数据备份完成,生成备份文件'./backup/<span>$filename</span>'"<span>;
</span><span>119</span>     <span>else</span> <span>$msgs</span>[]="备份表-".<span>$_POST</span>['tablename']."-失败"<span>;
</span><span>120</span>     show_msg(<span>$msgs</span><span>);
</span><span>121</span> <span>    pageend();
</span><span>122</span> <span>    }
</span><span>123</span> <span>/*</span><span>----------------不要卷结束</span><span>*/</span>}<span>/*</span><span>------------------------------------</span><span>*/</span>
<span>124</span> <span>/*</span><span>----------------分卷</span><span>*/</span><span>else</span>{<span>/*</span><span>--------------------------------------</span><span>*/</span>
<span>125</span> <span>if</span>(!<span>$_POST</span>['filesize'<span>])
</span><span>126</span>     {<span>$msgs</span>[]="请填写备份文件分卷大小"; show_msg(<span>$msgs</span><span>);pageend();}
</span><span>127</span> <span>$sql</span>=make_header(<span>$_POST</span>['tablename']); <span>$p</span>=1<span>; 
</span><span>128</span>     <span>$filename</span>=<span>date</span>("Ymd",<span>time</span>())."_".<span>$_POST</span>['tablename'<span>];
</span><span>129</span>     <span>$d</span>->query("select * from ".<span>$_POST</span>['tablename'<span>]);
</span><span>130</span>     <span>$num_fields</span>=<span>$d</span>-><span>nf();
</span><span>131</span>     <span>while</span> (<span>$d</span>-><span>nextrecord()) 
</span><span>132</span> <span>    {    
</span><span>133</span>         <span>$sql</span>.=make_record(<span>$_POST</span>['tablename'],<span>$num_fields</span><span>);
</span><span>134</span>        <span>if</span>(<span>strlen</span>(<span>$sql</span>)>=<span>$_POST</span>['filesize']*1000<span>){
</span><span>135</span>             <span>$filename</span>.=("_v".<span>$p</span>.".sql"<span>);
</span><span>136</span>             <span>if</span>(write_file(<span>$sql</span>,<span>$filename</span><span>))
</span><span>137</span>             <span>$msgs</span>[]="表-".<span>$_POST</span>['tablename']."-卷-".<span>$p</span>."-数据备份完成,生成备份文件'./backup/<span>$filename</span>'"<span>;
</span><span>138</span>             <span>else</span> <span>$msgs</span>[]="备份表-".<span>$_POST</span>['tablename']."-失败"<span>;
</span><span>139</span>             <span>$p</span>++<span>;
</span><span>140</span>             <span>$filename</span>=<span>date</span>("Ymd",<span>time</span>())."_".<span>$_POST</span>['tablename'<span>];
</span><span>141</span>             <span>$sql</span>=""<span>;}
</span><span>142</span> <span>    }
</span><span>143</span> <span>if</span>(<span>$sql</span>!=""){<span>$filename</span>.=("_v".<span>$p</span>.".sql"<span>);        
</span><span>144</span> <span>if</span>(write_file(<span>$sql</span>,<span>$filename</span><span>))
</span><span>145</span> <span>$msgs</span>[]="表-".<span>$_POST</span>['tablename']."-卷-".<span>$p</span>."-数据备份完成,生成备份文件'./backup/<span>$filename</span>'"<span>;}
</span><span>146</span> show_msg(<span>$msgs</span><span>);
</span><span>147</span> <span>/*</span><span>----------分卷结束</span><span>*/</span>}<span>/*</span><span>--------------------------------------------------</span><span>*/</span>
<span>148</span> <span>/*</span><span>----------备份单表结束</span><span>*/</span>}<span>/*</span><span>----------------------------------------------</span><span>*/</span>
<span>149</span> 
<span>150</span> <span>/*</span><span>---</span><span>*/</span>}<span>/*</span><span>-------------主程序结束------------------------------------------</span><span>*/</span>
<span>151</span> 
<span>152</span> <span>function</span> write_file(<span>$sql</span>,<span>$filename</span><span>)
</span><span>153</span> <span>{
</span><span>154</span> <span>$re</span>=<span>true</span><span>;
</span><span>155</span> <span>if</span>(!@<span>$fp</span>=<span>fopen</span>("./backup/".<span>$filename</span>,"w+")) {<span>$re</span>=<span>false</span>; <span>echo</span> "failed to open target file"<span>;}
</span><span>156</span> <span>if</span>(!@<span>fwrite</span>(<span>$fp</span>,<span>$sql</span>)) {<span>$re</span>=<span>false</span>; <span>echo</span> "failed to write file"<span>;}
</span><span>157</span> <span>if</span>(!@<span>fclose</span>(<span>$fp</span>)) {<span>$re</span>=<span>false</span>; <span>echo</span> "failed to close target file"<span>;}
</span><span>158</span> <span>return</span> <span>$re</span><span>;
</span><span>159</span> <span>}
</span><span>160</span> 
<span>161</span> <span>function</span> down_file(<span>$sql</span>,<span>$filename</span><span>)
</span><span>162</span> <span>{
</span><span>163</span>     <span>ob_end_clean</span><span>();
</span><span>164</span>     <span>header</span>("Content-Encoding: none"<span>);
</span><span>165</span>     <span>header</span>("Content-Type: ".(<span>strpos</span>(<span>$_SERVER</span>['HTTP_USER_AGENT'], 'MSIE') ? 'application/octetstream' : 'application/octet-stream'<span>));
</span><span>166</span>             
<span>167</span>     <span>header</span>("Content-Disposition: ".(<span>strpos</span>(<span>$_SERVER</span>['HTTP_USER_AGENT'], 'MSIE') ? 'inline; ' : 'attachment; ')."filename=".<span>$filename</span><span>);
</span><span>168</span>             
<span>169</span>     <span>header</span>("Content-Length: ".<span>strlen</span>(<span>$sql</span><span>));
</span><span>170</span>     <span>header</span>("Pragma: no-cache"<span>);
</span><span>171</span>             
<span>172</span>     <span>header</span>("Expires: 0"<span>);
</span><span>173</span>     <span>echo</span> <span>$sql</span><span>;
</span><span>174</span>     <span>$e</span>=<span>ob_get_contents</span><span>();
</span><span>175</span>     <span>ob_end_clean</span><span>();
</span><span>176</span> <span>}
</span><span>177</span> 
<span>178</span> <span>function</span> writeable(<span>$dir</span><span>)
</span><span>179</span> <span>{
</span><span>180</span>     
<span>181</span>     <span>if</span>(!<span>is_dir</span>(<span>$dir</span><span>)) {
</span><span>182</span>     @<span>mkdir</span>(<span>$dir</span>, 0777<span>);
</span><span>183</span> <span>    }
</span><span>184</span>     
<span>185</span>     <span>if</span>(<span>is_dir</span>(<span>$dir</span><span>)) 
</span><span>186</span> <span>    {
</span><span>187</span>     
<span>188</span>     <span>if</span>(<span>$fp</span> = @<span>fopen</span>("<span>$dir</span>/test.test", 'w'<span>))
</span><span>189</span> <span>        {
</span><span>190</span> @<span>fclose</span>(<span>$fp</span><span>);
</span><span>191</span>     @<span>unlink</span>("<span>$dir</span>/test.test"<span>);
</span><span>192</span>     <span>$writeable</span> = 1<span>;
</span><span>193</span> <span>} 
</span><span>194</span>     <span>else</span><span> {
</span><span>195</span> <span>$writeable</span> = 0<span>;
</span><span>196</span> <span>    }
</span><span>197</span>     
<span>198</span> <span>}
</span><span>199</span>     
<span>200</span>     <span>return</span> <span>$writeable</span><span>;
</span><span>201</span> 
<span>202</span> <span>}
</span><span>203</span> 
<span>204</span> <span>function</span> make_header(<span>$table</span><span>)
</span><span>205</span> {<span>global</span> <span>$d</span><span>;
</span><span>206</span> <span>$sql</span>="DROP TABLE IF EXISTS ".<span>$table</span>."\n"<span>;
</span><span>207</span> <span>$d</span>->query("show create table ".<span>$table</span><span>);
</span><span>208</span> <span>$d</span>-><span>nextrecord();
</span><span>209</span> <span>$tmp</span>=<span>preg_replace</span>("/\n/","",<span>$d</span>->f("Create Table"<span>));
</span><span>210</span> <span>$sql</span>.=<span>$tmp</span>."\n"<span>;
</span><span>211</span> <span>return</span> <span>$sql</span><span>;
</span><span>212</span> <span>}
</span><span>213</span> 
<span>214</span> <span>function</span> make_record(<span>$table</span>,<span>$num_fields</span><span>)
</span><span>215</span> {<span>global</span> <span>$d</span><span>;
</span><span>216</span> <span>$comma</span>=""<span>;
</span><span>217</span> <span>$sql</span> .= "INSERT INTO ".<span>$table</span>." VALUES("<span>;
</span><span>218</span> <span>for</span>(<span>$i</span> = 0; <span>$i</span> < <span>$num_fields</span>; <span>$i</span>++<span>) 
</span><span>219</span> {<span>$sql</span> .= (<span>$comma</span>."'".<span>mysql_escape_string</span>(<span>$d</span>->record[<span>$i</span>])."'"); <span>$comma</span> = ","<span>;}
</span><span>220</span> <span>$sql</span> .= ")\n"<span>;
</span><span>221</span> <span>return</span> <span>$sql</span><span>;
</span><span>222</span> <span>}
</span><span>223</span> 
<span>224</span> <span>function</span> show_msg(<span>$msgs</span><span>)
</span><span>225</span> <span>{
</span><span>226</span> <span>$title</span>="提示："<span>;
</span><span>227</span> <span>echo</span> "<table width='100%' border='1'  cellpadding='0' cellspacing='1'>"<span>;
</span><span>228</span> <span>echo</span> "<tr><td>".<span>$title</span>."</td></tr>"<span>;
</span><span>229</span> <span>echo</span> "<tr><td><br><ul>"<span>;
</span><span>230</span> <span>while</span> (<span>list</span>(<span>$k</span>,<span>$v</span>)=<span>each</span>(<span>$msgs</span><span>))
</span><span>231</span> <span>    {
</span><span>232</span>     <span>echo</span> "<li>".<span>$v</span>."</li>"<span>;
</span><span>233</span> <span>    }
</span><span>234</span> <span>echo</span> "</ul></td></tr></table>"<span>;
</span><span>235</span> <span>}
</span><span>236</span> 
<span>237</span> <span>function</span><span> pageend()
</span><span>238</span> <span>{
</span><span>239</span> <span>exit</span><span>();
</span><span>240</span> <span>}
</span><span>241</span> ?>

로그인 후 복사

restore.php

<?
<span>session_start</span><span>();
</span><span>global</span> <span>$mysqlhost</span>, <span>$mysqluser</span>, <span>$mysqlpwd</span>, <span>$mysqldb</span><span>;
</span><span>$mysqlhost</span>="";          <span>//</span><span>host name</span>
<span>$mysqluser</span>="";              <span>//</span><span>login name</span>
<span>$mysqlpwd</span>="";              <span>//</span><span>password</span>
<span>$mysqldb</span>="";        <span>//</span><span>name of database</span>

<span>include</span>("mydb.php"<span>);
</span><span>$d</span>=<span>new</span> db(<span>$mysqlhost</span>,<span>$mysqluser</span>,<span>$mysqlpwd</span>,<span>$mysqldb</span><span>);

</span><span>/*</span><span>*****界面</span><span>*/</span><span>if</span>(!<span>$_POST</span>['act']&&!<span>$_SESSION</span>['data_file']){<span>/*</span><span>********************</span><span>*/</span>
<span>$msgs</span>[]="本功能在恢复备份数据的同时，将全部覆盖原有数据，请确定是否需要恢复，以免造成数据损失"<span>;
</span><span>$msgs</span>[]="数据恢复功能只能恢复由dShop导出的数据文件，其他软件导出格式可能无法识别"<span>;
</span><span>$msgs</span>[]="从本地恢复数据需要服务器支持文件上传并保证数据尺寸小于允许上传的上限，否则只能使用从服务器恢复"<span>;
</span><span>$msgs</span>[]="如果您使用了分卷备份，只需手工导入文件卷1，其他数据文件会由系统自动导入"<span>;
show_msg(</span><span>$msgs</span><span>);
</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>class</span>="header"><td colspan="2" align="center">数据恢复</td></tr>
<tr><td width="33%"><input type="radio" name="restorefrom" value="server" checked><span>
从服务器文件恢复 </span></td><td width="67%"><select name="serverfile">
    <option value="">-请选择-</option>
<?
<span>$handle</span>=<span>opendir</span>('./backup'<span>);
</span><span>while</span> (<span>$file</span> = <span>readdir</span>(<span>$handle</span><span>)) {
    </span><span>if</span>(<span>eregi</span>("^[0-9]{8,8}([0-9a-z_]+)(\.sql)$",<span>$file</span>)) <span>echo</span> "<option value='<span>$file</span>'><span>$file</span></option>"<span>;}
</span><span>closedir</span>(<span>$handle</span><span>); 
</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>/*</span><span>*************************界面结束</span><span>*/</span>}<span>/*</span><span>***********************************</span><span>*/</span>
<span>/*</span><span>***************************主程序</span><span>*/</span><span>if</span>(<span>$_POST</span>['act']=="恢复"){<span>/*</span><span>************</span><span>*/</span>
<span>/*</span><span>**************服务器恢复</span><span>*/</span><span>if</span>(<span>$_POST</span>['restorefrom']=="server"){<span>/*</span><span>************</span><span>*/</span>
<span>if</span>(!<span>$_POST</span>['serverfile'<span>])
    {</span><span>$msgs</span>[]="您选择从服务器文件恢复备份，但没有指定备份文件"<span>;
     show_msg(</span><span>$msgs</span><span>); pageend();    }
</span><span>if</span>(!<span>eregi</span>("_v[0-9]+",<span>$_POST</span>['serverfile'<span>]))
    {</span><span>$filename</span>="./backup/".<span>$_POST</span>['serverfile'<span>];
    </span><span>if</span>(import(<span>$filename</span>)) <span>$msgs</span>[]="备份文件".<span>$_POST</span>['serverfile']."成功导入数据库"<span>;
    </span><span>else</span> <span>$msgs</span>[]="备份文件".<span>$_POST</span>['serverfile']."导入失败"<span>;
    show_msg(</span><span>$msgs</span><span>); pageend();        
    }
</span><span>else</span><span>
    {
    </span><span>$filename</span>="./backup/".<span>$_POST</span>['serverfile'<span>];
    </span><span>if</span>(import(<span>$filename</span>)) <span>$msgs</span>[]="备份文件".<span>$_POST</span>['serverfile']."成功导入数据库"<span>;
    </span><span>else</span> {<span>$msgs</span>[]="备份文件".<span>$_POST</span>['serverfile']."导入失败";show_msg(<span>$msgs</span><span>);pageend();}
    </span><span>$voltmp</span>=<span>explode</span>("_v",<span>$_POST</span>['serverfile'<span>]);
    </span><span>$volname</span>=<span>$voltmp</span>[0<span>];
    </span><span>$volnum</span>=<span>explode</span>(".sq",<span>$voltmp</span>[1<span>]);
    </span><span>$volnum</span>=<span>intval</span>(<span>$volnum</span>[0])+1<span>;
    </span><span>$tmpfile</span>=<span>$volname</span>."_v".<span>$volnum</span>.".sql"<span>;
    </span><span>if</span>(<span>file_exists</span>("./backup/".<span>$tmpfile</span><span>))
        {
        </span><span>$msgs</span>[]="程序将在3秒钟后自动开始导入此分卷备份的下一部份：文件".<span>$tmpfile</span>."，请勿手动中止程序的运行，以免数据库结构受损"<span>;
        </span><span>$_SESSION</span>['data_file']=<span>$tmpfile</span><span>;
        show_msg(</span><span>$msgs</span><span>);
        </span><span>sleep</span>(3<span>);
        </span><span>echo</span> "<script language='javascript'>"<span>; 
        </span><span>echo</span> "location='restore.php';"<span>; 
        </span><span>echo</span> "</script>"<span>; 
        }
    </span><span>else</span><span>
        {
        </span><span>$msgs</span>[]="此分卷备份全部导入成功"<span>;
        show_msg(</span><span>$msgs</span><span>);
        }
    }
</span><span>/*</span><span>*************服务器恢复结束</span><span>*/</span>}<span>/*</span><span>******************************************</span><span>*/</span>
<span>/*</span><span>****************本地恢复</span><span>*/</span><span>if</span>(<span>$_POST</span>['restorefrom']=="localpc"){<span>/*</span><span>************</span><span>*/</span>
    <span>switch</span> (<span>$_FILES</span>['myfile']['error'<span>])
    {
    </span><span>case</span> 1:
    <span>case</span> 2:
    <span>$msgs</span>[]="您上传的文件大于服务器限定值，上传未成功"<span>;
    </span><span>break</span><span>;
    </span><span>case</span> 3:
    <span>$msgs</span>[]="未能从本地完整上传备份文件"<span>;
    </span><span>break</span><span>;
    </span><span>case</span> 4:
    <span>$msgs</span>[]="从本地上传备份文件失败"<span>;
    </span><span>break</span><span>;
    </span><span>case</span> 0:
    <span>break</span><span>;
    }
    </span><span>if</span>(<span>$msgs</span>){show_msg(<span>$msgs</span><span>);pageend();}
</span><span>$fname</span>=<span>date</span>("Ymd",<span>time</span>())."_".sjs(5).".sql"<span>;
</span><span>if</span> (<span>is_uploaded_file</span>(<span>$_FILES</span>['myfile']['tmp_name'<span>])) {
    </span><span>copy</span>(<span>$_FILES</span>['myfile']['tmp_name'], "./backup/".<span>$fname</span><span>);}

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

</span><span>function</span><span> pageend()
{
</span><span>exit</span><span>();
}
</span>?>

로그인 후 복사

PHP+MYSQL的数据库怎备份与还原？

有很多软件可以使用，比如phpmyadmin，sqlyog等等
下载一个phpmyadmin并且配置好（网上有如何配置），其中就有备份还原数据库的图标，很简单
补充：----------------------
对啊，点导出，然后执行就可以了啊

php对mysql数据库的备份及还原：

能生成文件但是内容为空，说明：php执行没问题，mysqldump也运行，初步判断问题出在mysqldump没正常运行。建议你到服务器上运行 "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqldump -uroot -hlocalhost -p123 --opt -B rsgl > ../bak/xxx.sql"
看能否正常生成sql文件

본 웹사이트의 성명

본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.

핫 AI 도구

Video Face Swap

완전히 무료인 AI 얼굴 교환 도구를 사용하여 모든 비디오의 얼굴을 쉽게 바꾸세요!

뜨거운 도구

뜨거운 주제

자바 튜토리얼

1657

Cakephp 튜토리얼

1415

라라벨 튜토리얼

1309

PHP 튜토리얼

1257

C# 튜토리얼

1230

Related knowledge

MySQL의 역할 : 웹 응용 프로그램의 데이터베이스 Apr 17, 2025 am 12:23 AM

웹 응용 프로그램에서 MySQL의 주요 역할은 데이터를 저장하고 관리하는 것입니다. 1. MySQL은 사용자 정보, 제품 카탈로그, 트랜잭션 레코드 및 기타 데이터를 효율적으로 처리합니다. 2. SQL 쿼리를 통해 개발자는 데이터베이스에서 정보를 추출하여 동적 컨텐츠를 생성 할 수 있습니다. 3.mysql은 클라이언트-서버 모델을 기반으로 작동하여 허용 가능한 쿼리 속도를 보장합니다.

Docker의 MySQL을 시작하는 방법 Apr 15, 2025 pm 12:09 PM

Docker에서 MySQL을 시작하는 프로세스는 다음 단계로 구성됩니다. MySQL 이미지를 가져와 컨테이너를 작성하고 시작하고 루트 사용자 암호를 설정하고 포트 확인 연결을 매핑하고 데이터베이스를 작성하고 사용자는 데이터베이스에 모든 권한을 부여합니다.

LARAVEL 소개 예 Apr 18, 2025 pm 12:45 PM

Laravel은 웹 응용 프로그램을 쉽게 구축하기위한 PHP 프레임 워크입니다. 설치 : Composer를 사용하여 전 세계적으로 Laravel CLI를 설치하고 프로젝트 디렉토리에서 응용 프로그램을 작성하는 등 다양한 기능을 제공합니다. 라우팅 : Routes/Web.php에서 URL과 핸들러 간의 관계를 정의하십시오. 보기 : 리소스/뷰에서보기를 작성하여 응용 프로그램의 인터페이스를 렌더링합니다. 데이터베이스 통합 : MySQL과 같은 데이터베이스와 상자 외 통합을 제공하고 마이그레이션을 사용하여 테이블을 작성하고 수정합니다. 모델 및 컨트롤러 : 모델은 데이터베이스 엔티티를 나타내고 컨트롤러는 HTTP 요청을 처리합니다.

데이터베이스 연결 문제 해결 : Minii/DB 라이브러리 사용 실질적인 사례 Apr 18, 2025 am 07:09 AM

작은 응용 프로그램을 개발할 때 까다로운 문제가 발생했습니다. 가벼운 데이터베이스 운영 라이브러리를 신속하게 통합해야합니다. 여러 라이브러리를 시도한 후에는 기능이 너무 많거나 호환되지 않는다는 것을 알았습니다. 결국, 나는 내 문제를 완벽하게 해결하는 YII2를 기반으로 단순화 된 버전 인 Minii/DB를 발견했습니다.

Laravel 프레임 워크 설치 방법 Apr 18, 2025 pm 12:54 PM

기사 요약 :이 기사는 Laravel 프레임 워크를 쉽게 설치하는 방법에 대한 독자들을 안내하기위한 자세한 단계별 지침을 제공합니다. Laravel은 웹 애플리케이션의 개발 프로세스를 가속화하는 강력한 PHP 프레임 워크입니다. 이 자습서는 시스템 요구 사항에서 데이터베이스 구성 및 라우팅 설정에 이르기까지 설치 프로세스를 다룹니다. 이러한 단계를 수행함으로써 독자들은 라벨 프로젝트를위한 탄탄한 토대를 빠르고 효율적으로 놓을 수 있습니다.

MySQL 및 Phpmyadmin : 핵심 기능 및 기능 Apr 22, 2025 am 12:12 AM

MySQL 및 Phpmyadmin은 강력한 데이터베이스 관리 도구입니다. 1) MySQL은 데이터베이스 및 테이블을 작성하고 DML 및 SQL 쿼리를 실행하는 데 사용됩니다. 2) PHPMYADMIN은 데이터베이스 관리, 테이블 구조 관리, 데이터 운영 및 사용자 권한 관리에 직관적 인 인터페이스를 제공합니다.

MySQL 대 기타 프로그래밍 언어 : 비교 Apr 19, 2025 am 12:22 AM

다른 프로그래밍 언어와 비교할 때 MySQL은 주로 데이터를 저장하고 관리하는 데 사용되는 반면 Python, Java 및 C와 같은 다른 언어는 논리적 처리 및 응용 프로그램 개발에 사용됩니다. MySQL은 데이터 관리 요구에 적합한 고성능, 확장 성 및 크로스 플랫폼 지원으로 유명하며 다른 언어는 데이터 분석, 엔터프라이즈 애플리케이션 및 시스템 프로그래밍과 같은 해당 분야에서 이점이 있습니다.

MySQL 대 기타 데이터베이스 : 옵션 비교 Apr 15, 2025 am 12:08 AM

MySQL은 웹 응용 프로그램 및 컨텐츠 관리 시스템에 적합하며 오픈 소스, 고성능 및 사용 편의성에 인기가 있습니다. 1) PostgreSQL과 비교하여 MySQL은 간단한 쿼리 및 높은 동시 읽기 작업에서 더 잘 수행합니다. 2) Oracle과 비교할 때 MySQL은 오픈 소스와 저렴한 비용으로 인해 중소 기업에서 더 인기가 있습니다. 3) Microsoft SQL Server와 비교하여 MySQL은 크로스 플랫폼 응용 프로그램에 더 적합합니다. 4) MongoDB와 달리 MySQL은 구조화 된 데이터 및 트랜잭션 처리에 더 적합합니다.

See all articles

PHP数据库备份与恢复，PHP数据库备份恢复_PHP教程

PHP数据库备份与恢复，PHP数据库备份恢复

PHP+MYSQL的数据库怎备份与还原？

php对mysql数据库的备份及还原：

핫 AI 도구

Undresser.AI Undress

AI Clothes Remover

Undress AI Tool

Clothoff.io

Video Face Swap

인기 기사

뜨거운 도구

메모장++7.3.1

SublimeText3 중국어 버전

스튜디오 13.0.1 보내기

드림위버 CS6

SublimeText3 Mac 버전

뜨거운 주제