<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">
<channel>
<title><![CDATA[BIWEB开源PHP WMS系统创始人ArthurXF肖飞的blog]]></title> 
<link>http://www.bizeway.net/index.php</link> 
<description><![CDATA[网务通 - 网务公司发展之路]]></description> 
<language>zh-cn</language> 
<copyright><![CDATA[BIWEB开源PHP WMS系统创始人ArthurXF肖飞的blog]]></copyright>
<item>
<link>http://www.bizeway.net/read.php?</link>
<title><![CDATA[mongodb 数据备份及恢复 mongodump mongorestore  ]]></title> 
<author>ArthurXF &lt;arthurxf@gmail.com&gt;</author>
<category><![CDATA[Mongodb]]></category>
<pubDate>Fri, 26 Oct 2012 03:17:20 +0000</pubDate> 
<guid>http://www.bizeway.net/read.php?</guid> 
<description>
<![CDATA[ 
	<strong><span style="font-size: small">一：数据备份mongodump</span></strong> <div><span style="font-size: small"><span style="line-height: 25px"><strong><br /></strong></span></span> <div> <div>可以用mongodump 来做MongoDB 的库或表级别的备份，下面举例说明:</div> <div>备份my_mongodb 数据库</div> <div><pre class="prettyprint"><p><span class="pun">[</span><span class="pln">root@localhost bin</span><span class="pun">]</span><span class="com"># ./mongodump -d my_mongodb</span><br /><span class="pln">connected to</span><span class="pun">:</span><span class="pln"> </span><span class="lit">127.0</span><span class="pun">.</span><span class="lit">0.1</span><br /><span class="pln">DATABASE</span><span class="pun">:</span><span class="pln"> my_mongodb to </span><span class="kwd">dump</span><span class="pun">/</span><span class="pln">my_mongodb</span><br /><span class="pln">my_mongodb</span><span class="pun">.</span><span class="pln">system</span><span class="pun">.</span><span class="pln">indexes to </span><span class="kwd">dump</span><span class="pun">/</span><span class="pln">my_mongodb</span><span class="pun">/</span><span class="pln">system</span><span class="pun">.</span><span class="pln">indexes</span><span class="pun">.</span><span class="pln">bson</span><br /><span class="lit">1</span><span class="pln"> objects</span><br /><span class="pln">my_mongodb</span><span class="pun">.</span><span class="pln">user to </span><span class="kwd">dump</span><span class="pun">/</span><span class="pln">my_mongodb</span><span class="pun">/</span><span class="pln">user</span><span class="pun">.</span><span class="pln">bson</span><br /><span class="lit">2</span><span class="pln"> objects</span><br /><span class="pun">[</span><span class="pln">root@localhost bin</span><span class="pun">]</span><span class="com"># ll</span><br /><span class="pun">总计</span><span class="pln"> </span><span class="lit">67648</span><br /><span class="pun">-</span><span class="pln">rwxr</span><span class="pun">-</span><span class="pln">xr</span><span class="pun">-</span><span class="pln">x </span><span class="lit">1</span><span class="pln"> root root </span><span class="lit">7508756</span><span class="pln"> </span><span class="lit">2011</span><span class="pun">-</span><span class="lit">04</span><span class="pun">-</span><span class="lit">06</span><span class="pln"> bsondump</span><br /><span class="pln">drwxr</span><span class="pun">-</span><span class="pln">xr</span><span class="pun">-</span><span class="pln">x </span><span class="lit">3</span><span class="pln"> root root </span><span class="lit">4096</span><span class="pln"> </span><span class="lit">04</span><span class="pun">-</span><span class="lit">10</span><span class="pln"> </span><span class="lit">23</span><span class="pun">:</span><span class="lit">54</span><span class="pln"> </span><span class="kwd">dump</span><br /><span class="pun">-</span><span class="pln">rwxr</span><span class="pun">-</span><span class="pln">xr</span><span class="pun">-</span><span class="pln">x </span><span class="lit">1</span><span class="pln"> root root </span><span class="lit">2978016</span><span class="pln"> </span><span class="lit">2011</span><span class="pun">-</span><span class="lit">04</span><span class="pun">-</span><span class="lit">06</span><span class="pln"> mongo</span></p></pre> <div>此时会在当前目录下创建一个dump 目录，用于存放备份出来的文件</div> <div>也可以指定备份存放的目录，</div></div> <div><pre class="prettyprint"><p><span class="pun">[</span><span class="pln">root@localhost bin</span><span class="pun">]</span><span class="com"># ./mongodump -d my_mongodb -o my_mongodb_dump</span><br /><span class="pln">connected to</span><span class="pun">:</span><span class="pln"> </span><span class="lit">127.0</span><span class="pun">.</span><span class="lit">0.1</span><br /><span class="pln">DATABASE</span><span class="pun">:</span><span class="pln"> my_mongodb to my_mongodb_dump</span><span class="pun">/</span><span class="pln">my_mongodb</span><br /><span class="pln">my_mongodb</span><span class="pun">.</span><span class="pln">system</span><span class="pun">.</span><span class="pln">indexes to</span><br /><span class="pln">my_mongodb_dump</span><span class="pun">/</span><span class="pln">my_mongodb</span><span class="pun">/</span><span class="pln">system</span><span class="pun">.</span><span class="pln">indexes</span><span class="pun">.</span><span class="pln">bson</span><br /><span class="lit">1</span><span class="pln"> objects</span><br /><span class="pln">my_mongodb</span><span class="pun">.</span><span class="pln">user to my_mongodb_dump</span><span class="pun">/</span><span class="pln">my_mongodb</span><span class="pun">/</span><span class="pln">user</span><span class="pun">.</span><span class="pln">bson</span><br /><span class="lit">2</span><span class="pln"> objects</span><br /><span class="pun">[</span><span class="pln">root@localhost bin</span><span class="pun">]</span><span class="com">#</span></p></pre><span style="font-size: small"><strong> <div><span style="font-size: small"><strong><br /></strong></span></div>二：数据恢复mongorestore</strong></span></div> <div><span style="font-size: small"><strong><br /></strong></span></div> <div>由于刚刚已经做了备份，所以我们先将库my_mongodb 删除掉</div> <div><pre class="prettyprint"><p><span class="pun">&gt;</span><span class="pln"> </span><span class="kwd">use</span><span class="pln"> my_mongodb</span><br /><span class="pln">switched to db my_mongodb</span><br /><span class="pun">&gt;</span><span class="pln"> db</span><span class="pun">.</span><span class="pln">dropDatabase</span><span class="pun">()</span><br /><span class="pun">{</span><span class="pln"> </span><span class="str">&quot;dropped&quot;</span><span class="pln"> </span><span class="pun">:</span><span class="pln"> </span><span class="str">&quot;my_mongodb&quot;</span><span class="pun">,</span><span class="pln"> </span><span class="str">&quot;ok&quot;</span><span class="pln"> </span><span class="pun">:</span><span class="pln"> </span><span class="lit">1</span><span class="pln"> </span><span class="pun">}</span><br /><span class="pun">&gt;</span><span class="pln"> show dbs</span><br /><span class="pln">admin </span><span class="pun">(</span><span class="pln">empty</span><span class="pun">)</span><br /><span class="kwd">local</span><span class="pln"> </span><span class="pun">(</span><span class="pln">empty</span><span class="pun">)</span><br /><span class="pln">test </span><span class="pun">(</span><span class="pln">empty</span><span class="pun">)</span><br /><span class="pun">&gt;</span></p></pre>接下来我们进行数据库恢复</div> <div><pre class="prettyprint"><p><span class="pun">[</span><span class="pln">root@localhost bin</span><span class="pun">]</span><span class="com"># ./mongorestore -d my_mongodb my_mongodb_dump/*</span><br /><span class="pln">connected to</span><span class="pun">:</span><span class="pln"> </span><span class="lit">127.0</span><span class="pun">.</span><span class="lit">0.1</span><br /><span class="typ">Wed</span><span class="pln"> </span><span class="typ">Apr</span><span class="pln"> </span><span class="lit">11</span><span class="pln"> </span><span class="lit">00</span><span class="pun">:</span><span class="lit">03</span><span class="pun">:</span><span class="lit">03</span><span class="pln"> my_mongodb_dump</span><span class="pun">/</span><span class="pln">my_mongodb</span><span class="pun">/</span><span class="pln">user</span><span class="pun">.</span><span class="pln">bson</span><br /><span class="typ">Wed</span><span class="pln"> </span><span class="typ">Apr</span><span class="pln"> </span><span class="lit">11</span><span class="pln"> </span><span class="lit">00</span><span class="pun">:</span><span class="lit">03</span><span class="pun">:</span><span class="lit">03</span><span class="pln"> going </span><span class="kwd">into</span><span class="pln"> </span><span class="kwd">namespace</span><span class="pln"> </span><span class="pun">[</span><span class="pln">my_mongodb</span><span class="pun">.</span><span class="pln">user</span><span class="pun">]</span><br /><span class="typ">Wed</span><span class="pln"> </span><span class="typ">Apr</span><span class="pln"> </span><span class="lit">11</span><span class="pln"> </span><span class="lit">00</span><span class="pun">:</span><span class="lit">03</span><span class="pun">:</span><span class="lit">03</span><span class="pln"> </span><span class="lit">2</span><span class="pln"> objects found</span><br /><span class="typ">Wed</span><span class="pln"> </span><span class="typ">Apr</span><span class="pln"> </span><span class="lit">11</span><span class="pln"> </span><span class="lit">00</span><span class="pun">:</span><span class="lit">03</span><span class="pun">:</span><span class="lit">03</span><span class="pln"> my_mongodb_dump</span><span class="pun">/</span><span class="pln">my_mongodb</span><span class="pun">/</span><span class="pln">system</span><span class="pun">.</span><span class="pln">indexes</span><span class="pun">.</span><span class="pln">bson</span><br /><span class="typ">Wed</span><span class="pln"> </span><span class="typ">Apr</span><span class="pln"> </span><span class="lit">11</span><span class="pln"> </span><span class="lit">00</span><span class="pun">:</span><span class="lit">03</span><span class="pun">:</span><span class="lit">03</span><span class="pln"> going </span><span class="kwd">into</span><span class="pln"> </span><span class="kwd">namespace</span><span class="pln"> </span><span class="pun">[</span><span class="pln">my_mongodb</span><span class="pun">.</span><span class="pln">system</span><span class="pun">.</span><span class="pln">indexes</span><span class="pun">]</span><br /><span class="typ">Wed</span><span class="pln"> </span><span class="typ">Apr</span><span class="pln"> </span><span class="lit">11</span><span class="pln"> </span><span class="lit">00</span><span class="pun">:</span><span class="lit">03</span><span class="pun">:</span><span class="lit">03</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> name</span><span class="pun">:</span><span class="pln"> </span><span class="str">&quot;_id_&quot;</span><span class="pun">,</span><span class="pln"> ns</span><span class="pun">:</span><span class="pln"> </span><span class="str">&quot;my_mongodb.user&quot;</span><span class="pun">,</span><span class="pln"> key</span><span class="pun">:</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> _id</span><span class="pun">:</span><span class="pln"> </span><span class="lit">1</span><span class="pln"> </span><span class="pun">},</span><span class="pln"> v</span><span class="pun">:</span><span class="pln"> </span><span class="lit">0</span><span class="pln"> </span><span class="pun">}</span><br /><span class="typ">Wed</span><span class="pln"> </span><span class="typ">Apr</span><span class="pln"> </span><span class="lit">11</span><span class="pln"> </span><span class="lit">00</span><span class="pun">:</span><span class="lit">03</span><span class="pun">:</span><span class="lit">03</span><span class="pln"> </span><span class="lit">1</span><span class="pln"> objects found</span><br /><span class="pun">[</span><span class="pln">root@localhost bin</span><span class="pun">]</span><span class="com">#</span></p></pre> <div>经验证数据库又回来了，其实要是想恢复库，也大可不必先删除my_mongodb 库，只要指</div> <div>明 &ndash;drop 参数，就可以在恢复的时候先删除表然后再向表中插入数据的</div></div></div></div><br/>Tags - <a href="tag.php?tag=mango" rel="tag">mango</a>
]]>
</description>
</item><item>
<link>http://www.bizeway.net/read.php?&amp;guid=0#topreply</link>
<title><![CDATA[[评论] mongodb 数据备份及恢复 mongodump mongorestore  ]]></title> 
<author> &lt;user@domain.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Thu, 01 Jan 1970 00:00:00 +0000</pubDate> 
<guid>http://www.bizeway.net/read.php?&amp;guid=0#topreply</guid> 
<description>
<![CDATA[ 
	
]]>
</description>
</item>
</channel>
</rss>