{"id":461,"date":"2013-11-10T23:57:20","date_gmt":"2013-11-10T23:57:20","guid":{"rendered":"http:\/\/www.theSQLReport.com\/?p=461"},"modified":"2016-02-20T12:57:13","modified_gmt":"2016-02-20T12:57:13","slug":"renaming-a-gridfs-object-in-mongodb","status":"publish","type":"post","link":"http:\/\/www.theSQLReport.com\/?p=461","title":{"rendered":"Renaming a GridFS object in mongoDB"},"content":{"rendered":"

Recently I was asked to rename 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 & rename command. Below in my example, I am going to rename the my_videos GridFS object (below is a view of the GridFS object in the MongoVUE<\/a> application).<\/p>\n

\"As<\/a><\/p>\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><\/p>\n

To rename the GridFS object, both the \u201c.files\u201d collection & \u201c.chunks\u201d collection need to be renamed.\u00a0 Use the renameCollection <\/a>command to rename both collections in the mongo shell.\u00a0 Both collections need to be renamed, but the order in which they are renamed is not important.\u00a0 Watch the case when using this command, the C needs to be a capital letter in the “renameCollection” or a TypeError will occur.\u00a0 In my example, I am changing my_videos to training_videos.\u00a0 Below I have used the syntax to change the names:<\/p>\n

db.< collection name >.renameCollection(” < new name > “)<\/p>\n

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

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

Now in my MongoVUE<\/a> application, I can see my changed GridFS object to training_videos.\u00a0 I can also access them now.<\/p>\n

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

 <\/p>\n

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

Recently I was asked to rename 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 & rename … Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":466,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-461","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\/461"}],"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=461"}],"version-history":[{"count":5,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/461\/revisions"}],"predecessor-version":[{"id":476,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/461\/revisions\/476"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/466"}],"wp:attachment":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=461"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}