mongodb資料庫操作--備份 還原 匯出 匯入

標籤：

• 首先Database Backup： mongodump -h IP --port 連接埠 -u 使用者名稱 -p 密碼 -d 資料庫 -o 檔案存在路徑 

mongodump -h 127.0.0.1 -u admin -p xxx  -d blog -o ‘/home/timeless/案頭/mongodump‘ --authenticationDatabase admin

注意  --authenticationDatabase  參數制定認證資料庫   否則會提示錯誤：

Failed: error connecting to db server: server returned error on SASL authentication step: Authentication failed.   //提示認證失敗

也可以指定匯出的集合  -collection 

• 還原資料庫執行個體

$ mongorestore -h XXX -u admin -p XXX -d blog  /home/timeless/案頭/mongodump/blog --authenticationDatabase admin   2016-09-25T15:09:40.481+0800    building a list of collections to restore from /home/timeless/案頭/mongodump/blog dir2016-09-25T15:09:40.491+0800    reading metadata for blog.post from /home/timeless/案頭/mongodump/blog/post.metadata.json2016-09-25T15:09:40.499+0800    reading metadata for blog.user from /home/timeless/案頭/mongodump/blog/user.metadata.json2016-09-25T15:09:40.510+0800    reading metadata for blog.meta from /home/timeless/案頭/mongodump/blog/meta.metadata.json2016-09-25T15:09:40.555+0800    restoring blog.meta from /home/timeless/案頭/mongodump/blog/meta.bson2016-09-25T15:09:40.568+0800    restoring indexes for collection blog.meta from metadata2016-09-25T15:09:40.602+0800    restoring blog.post from /home/timeless/案頭/mongodump/blog/post.bson2016-09-25T15:09:40.635+0800    restoring blog.user from /home/timeless/案頭/mongodump/blog/user.bson2016-09-25T15:09:40.637+0800    finished restoring blog.meta (3 documents)2016-09-25T15:09:40.637+0800    restoring indexes for collection blog.post from metadata2016-09-25T15:09:40.645+0800    reading metadata for blog.page from /home/timeless/案頭/mongodump/blog/page.metadata.json2016-09-25T15:09:40.646+0800    reading metadata for blog.content from /home/timeless/案頭/mongodump/blog/content.metadata.json2016-09-25T15:09:40.646+0800    finished restoring blog.post (1 document)2016-09-25T15:09:40.646+0800    reading metadata for blog.option from /home/timeless/案頭/mongodump/blog/option.metadata.json2016-09-25T15:09:40.646+0800    restoring indexes for collection blog.user from metadata2016-09-25T15:09:40.679+0800    finished restoring blog.user (2 documents)2016-09-25T15:09:40.680+0800    reading metadata for blog.counters from /home/timeless/案頭/mongodump/blog/counters.metadata.json2016-09-25T15:09:40.680+0800    restoring blog.page from /home/timeless/案頭/mongodump/blog/page.bson2016-09-25T15:09:40.707+0800    restoring blog.option from /home/timeless/案頭/mongodump/blog/option.bson2016-09-25T15:09:40.741+0800    restoring blog.content from /home/timeless/案頭/mongodump/blog/content.bson2016-09-25T15:09:40.785+0800    restoring blog.counters from /home/timeless/案頭/mongodump/blog/counters.bson2016-09-25T15:09:40.836+0800    restoring indexes for collection blog.option from metadata2016-09-25T15:09:40.837+0800    restoring indexes for collection blog.page from metadata2016-09-25T15:09:40.838+0800    restoring indexes for collection blog.content from metadata2016-09-25T15:09:40.847+0800    finished restoring blog.page (1 document)2016-09-25T15:09:40.847+0800    reading metadata for blog.system.users from /home/timeless/案頭/mongodump/blog/system.users.metadata.json2016-09-25T15:09:40.847+0800    finished restoring blog.content (1 document)2016-09-25T15:09:40.848+0800    reading metadata for blog.webinfo from /home/timeless/案頭/mongodump/blog/webinfo.metadata.json2016-09-25T15:09:40.848+0800    restoring indexes for collection blog.counters from metadata2016-09-25T15:09:40.848+0800    finished restoring blog.option (1 document)2016-09-25T15:09:40.884+0800    restoring blog.webinfo from /home/timeless/案頭/mongodump/blog/webinfo.bson2016-09-25T15:09:40.884+0800    restoring indexes for collection blog.webinfo from metadata2016-09-25T15:09:40.916+0800    finished restoring blog.counters (4 documents)2016-09-25T15:09:40.916+0800    restoring blog.system.users from /home/timeless/案頭/mongodump/blog/system.users.bson2016-09-25T15:09:40.916+0800    finished restoring blog.webinfo (0 documents)2016-09-25T15:09:40.917+0800    restoring indexes for collection blog.system.users from metadata2016-09-25T15:09:40.928+0800    finished restoring blog.system.users (0 documents)2016-09-25T15:09:40.928+0800    done

該也可以指定要恢複的集合  -collection

 

注意的地方 

• mongoimport 執行匯入前，新資料庫中沒有 XX 表一樣可以匯入成功；
• mongoexport 和 mongoimport 所需的各個參數輸入的先後順序不嚴格；
• 對於複本集，mongoexport 的資料匯出可以是複本集中的 primary 節點，也可以是 secondary 節點；
• 對於複本集，mongoimport 的資料匯入必須是 primary 節點；
• 對於大資料量的匯出，用 mongoexport 操作完全不會有生產問題；
• 對於大資料量的匯入(超過 500 MB)，用 mongoimport 操作的話會很容易將 primary 節點拖垮，因為這會導致全量同步導致主節點崩潰，所以要避免生產環境中大資料量的匯入。正確的做法是先建立單點，匯入，之後再建立複本集。

 

mongodb資料庫操作--備份 還原 匯出 匯入