{"id":446,"date":"2013-11-11T00:21:20","date_gmt":"2013-11-11T00:21:20","guid":{"rendered":"http:\/\/www.theSQLReport.com\/?p=446"},"modified":"2016-02-20T12:58:55","modified_gmt":"2016-02-20T12:58:55","slug":"delete-or-drop-a-gridfs-object-in-mongodb","status":"publish","type":"post","link":"http:\/\/www.theSQLReport.com\/?p=446","title":{"rendered":"Delete or Drop a GridFS object in mongoDB"},"content":{"rendered":"

Recently I was asked to remove a GridFS object from one of our mongoDB databases.\u00a0 As of version 2.4.6 of mongoDB, this is not straight forward right click & delete command. Below in my example, I am going to remove the my_videos GridFS object (below is a view of the GridFS object in the MongoVUE<\/a> application).<\/p>\n

\"As<\/a>

As viewed in MongoVUE<\/a><\/p><\/div>\n

The GridFS object<\/a> is a set of two collections.\u00a0 One of the collections has an extension “.files”, which stores the metadata for the files being stores.\u00a0 The other collection has an extension “.chunks”, which stores the files.\u00a0\u00a0 Pictured below is a screen shot of the mongo shell.\u00a0 I have connected to my_database, and ran the “show collections” command.\u00a0 In the example below, the GridFS object is the combination of the my_videos.chunks & my_videos.files collections. \u00a0 The “_id”\u00a0 field in the document of the “.files” collection is linked to the “field_id” field of the document that stores the file of the “.chunks” collection with the save value.<\/p>\n

\"Show<\/a>To remove the GridFS object, both the “.files” collection & “.chunks” collection need to be removed.\u00a0 Use the drop command to remove both collections in the mongo shell.\u00a0 Both collections need to be drop, but the order in which they are removed is not important.\u00a0 The files in the GridFS object do NOT need to be removed to drop the “.chunks” collection.\u00a0 Once the\u00a0“.chunks” collection has been dropped, the decrease size of the database will be reflected.\u00a0 Below I have used the syntax to drop the collection:<\/p>\n

db.< collection name >.drop( )<\/p>\n

\"Drop<\/a><\/p>\n

Below is the just a screen shot of all the command in the mongo shell to remove the my_videos GridFS object.\u00a0 The last “show collections” command shows that the my_videos GridFS object has been removed from the mongoDB database.<\/p>\n

\"Mongo<\/a><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Recently I was asked to remove a GridFS object from one of our mongoDB databases.\u00a0 As of version 2.4.6 of mongoDB, this is not straight forward right click & delete … Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":448,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-446","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux"],"_links":{"self":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/446"}],"collection":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=446"}],"version-history":[{"count":16,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/446\/revisions"}],"predecessor-version":[{"id":475,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/446\/revisions\/475"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/448"}],"wp:attachment":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=446"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=446"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}