MongoDB修复数据使过用的一些方法

- 日理万妓 2021-09-22 13:18 359阅读 0赞

# 一.导出数据库数据 #

(\[bin\]$ ./mongoexport执行恢复操作的文件目录)  
sudo ./mongoexport -h 121.49.99.14:27017 -u mongo -p mima -d crawler\_statues -c twitter\_apis -o /home/fgl/yj/mongodb/backups/crawler\_statues/twitter\_apis.json --type json --authenticationDatabase admin  
  
  
mongoexport -h 121.49.99.14 --port 30011 -u kb314 -p mima  -d Account -c LinkedInBJ -o /home/fgl/yj/mongodb/backups/Account/LinkedInBJ.json --type json --authenticationDatabase admin  
  
  
mongoexport -h 121.49.99.14 --port 30011 -u kb314 -p mima -d LinkedIn -c linkedin\_account --sort '\{"userState":1\}' --type csv --fields Real\_name,email,account,password,userState,IP,registered\_by,usedState,emailPassword,address,foreign,lastUsedTimeStr,isNeedCheckEmail -o /home/fgl/yj/mongodb/backups/Account/linkedin\_account.csv --authenticationDatabase admin  
  
  
  
  
/share/MongoData

# 二.导入数据 #

导入数据（测试有效，2017/9/8， 此命令实在mongodb的bin下执行的）  
mongoimport -h 121.49.99.14 --port 30011 -u kb314 -p mima  -d twitter\_user\_tweet -c user --upsert --file /home/fgl/yj/mongodb/backups/twitter\_user\_tweet/user.json --authenticationDatabase admin  
  
  
mongoimport -h 121.49.99.14 --port 30011 -u kb314 -p mima -d LinkedIn -c linkedin\_account\_new --type csv --headerline --upsert --file /home/fgl/yj/mongodb/backups/Account/linkedin\_account\_new.csv --authenticationDatabase admin

# 三.修复数据（开始用的办法） #

2.1:  
./wt -v -h /home/leier/mongodb/tmp/tmp-db -C "extensions=\[/home/leier/mongodb/tmp/recovery-dir/wiredtiger-2.9.2/ext/compressors/snappy/.libs/libwiredtiger\_snappy.so\]" -R salvage collection-原文件.wt  
  
2.2.1：  
  ./wt -v -h /home/leier/mongodb/tmp/tmp-db -C "extensions=\[/home/leier/mongodb/tmp/recovery-dir/wiredtiger-2.9.2/ext/compressors/snappy/.libs/libwiredtiger\_snappy.so\]" -R dump -f ../collection.dump collection-原文件（无.wt）  
  
2.2.2：   
/home/leier/mongodb/bin/mongod --dbpath /home/leier/mongodb/tmp/test-db --storageEngine wiredTiger --nojournal   
  
2.2.3:  
 ./wt -v -h /home/leier/mongodb/tmp/test-db -C "extensions=\[/home/leier/mongodb/tmp/recovery-dir/wiredtiger-2.9.2/ext/compressors/snappy/.libs/libwiredtiger\_snappy.so\]" -R load -f ../collection.dump -r collection-\[test新生成的集合名\](无.wt)  
  
  
collection-0--1427472329047232485.wt  
/home/leier/mongodb/tmp/recovery-dir/wiredtiger-2.9.2  
  
sudo rm /tmp/mongodb-27017.sock  
/home/leier/mongodb/bin/mongod --dbpath /home/leier/mongodb/data  --repair  
/home/leier/mongodb/bin/mongod --dbpath /home/leier/mongodb/data  
./recovery-dir/collection.dump  
用netstat -anp | more 可以看到客户端还在使用服务器的端口