Undo convertToCapped to a collection

2019-02-17 08:54发布

In MongoDB you can convert a collection into a capped collection with the command convertToCapped, but is there a way to revert this change so a capped collection goes back to normal?

标签: mongodb nosql
3条回答
一纸荒年 Trace。
2楼-- · 2019-02-17 09:20

I think there is a way! I'm not sure if this is bullet-proof, but I tried:

db.num_coll.convertToCapped(new_size)

and since then it is working.

查看更多
Lonely孤独者°
3楼-- · 2019-02-17 09:29

same as above without using script.

    db.collection.copyTo("collection_temp")
    db.collection.drop()
    db.collection_temp.renameCollection("collection")
查看更多
戒情不戒烟
4楼-- · 2019-02-17 09:34

It's seems there is only one way to convert from capped collection to normal - just simple copy objects to normal collection and remove original capped collection.


db.createCollection("norm_coll");
var cur = db.cap_col.find()
while (cur.hasNext()) {obj = cur.next(); db.norm_coll.insert(obj);}

查看更多
登录 后发表回答