How do you rename a MongoDB database

Question

There s a typo in my MongoDB database name and I m looking to rename the database   I can copy and delete like so     db copyDatabase  old name    new name    use old name db dropDatabase      Is there a command to rename a database

User · Answer

In the case you put all your data in the admin database  you shouldn t   you ll notice db copyDatabase   won t work because your user requires a lot of privileges you probably don t want to give it  Here is a script to copy the database manually   use old db db getCollectionNames   forEach function collName        db collName  find   forEach function d           db getSiblingDB  new db   collName  insert d

User · Answer

There is no mechanism to re-name databases   The currently accepted answer at time of writing is factually correct and offers some interesting background detail as to the excuse upstream  but offers no suggestions for replicating the behavior   Other answers point at copyDatabase  which is no longer an option as the functionality has been removed in 4 0   I ve updated SERVER-701 with my notes and incredulity    Equivalent behavior involves mongodump and mongorestore in a bit of a dance    Export your data  making note of the  namespaces  in use   For example  on one of my datasets  I have a collection with the namespace byzmcbehoomrfjcs9vlj Analytics     that prefix  actually the database name  will be needed in the next step  Import your data  supplying --nsFrom and --nsTo arguments    Documentation    Continuing with my above hypothetical  and extremely unreadable  example  to restore to a more sensical name  I invoke    mongorestore --archive backup agz --gzip --drop       --nsFrom  byzmcbehoomrfjcs9vlj    --nsTo  rita      Some may also point at the --db argument to mongorestore  however this  too  is deprecated and triggers a warning against use on non-BSON folder backups with a completely erroneous suggestion to  use --nsInclude instead    The above namespace translation is equivalent to use of the --db option  and is the correct namespace manipulation setup to use as we are not attempting to filter what is being restored

User · Answer

I tried doing   db copyDatabase  DB toBeRenamed   Db newName   host      and came to know that it has been Deprecated by the mongo community although it created the backup or renamed DB   WARNING  db copyDatabase is deprecated  See http   dochub mongodb org core copydb-clone-deprecation            note     Support for the copydb command has been deprecated  See          http   dochub mongodb org core copydb-clone-deprecation            ok    1     So not convinced with the above approach I had to take Dump of local using below command  mongodump --host --db DB TobeRenamed --out E   FileName    connected to Db    use DB TobeRenamed   then   db dropDatabase     then restored the DB with command   mongorestore -host hostName -d Db NewName E   FileName

User · Answer

Alternative solution  you can dump your db and restore that in different name  As I ve experienced it s much quicker than db copyDatabase      mongodump -d old db name -o mongodump    mongorestore -d new db name mongodump old db name  http   docs mongodb org manual tutorial backup-with-mongodump   This is the current official recommended approach for database renames  given that copyDatabase was removed in MongoDB 4 2   The  quot copydb quot  command is deprecated  please use these two commands instead   mongodump  to back up data  mongorestore  to recover data from mongodump into a new namespace

User · Answer

No there isn t  See https   jira mongodb org browse SERVER-701     Unfortunately  this is not an simple feature for us to implement due to the way that database metadata is stored in the original  default  storage engine  In MMAPv1 files  the namespace  e g   dbName collection  that describes every single collection and index includes the database name  so to rename a set of database files  every single namespace string would have to be rewritten  This impacts          the  ns file   every single numbered file for the collection   the namespace for every index   internal unique names of each collection and index   contents of system namespaces and system indexes  or their equivalents in the future    other locations I may be missing         This is just to accomplish a rename of a single database in a standalone mongod instance  For replica sets the above would need to be done on every replica node  plus on each node every single oplog entry that refers this database would have to be somehow invalidated or rewritten  and then if it s a sharded cluster  one also needs to add these changes to every shard if the DB is sharded  plus the config servers have all the shard metadata in terms of namespaces with their full names       There would be absolutely no way to do this on a live system       To do it offline  it would require re-writing every single database file to accommodate the new name  and at that point it would be as slow as the current  copydb  command

User · Answer

Although Mongodb does not provide the rename Database command  it provides the rename Collection command  which not only modifies the collection name  but also modifies the database name    renameCollection   quot  lt source namespace gt  quot   to   quot  lt target namespace gt  quot   dropTarget   lt true false gt   writeConcern   lt document gt     db adminCommand  renameCollection   quot db1 test1 quot   to   quot db2 test2 quot     This command only modifies the metadata  the cost is very small  we only need to traverse all the collections under db1  renamed to db2 to achieve rename Database name  you can do it  in this Js script var source    quot source quot   var dest    quot dest quot   var colls   db getSiblingDB source  getCollectionNames    for  var i   0  i  lt  colls length  i      var from   source    quot   quot    colls i   var to   dest    quot   quot    colls i   db adminCommand  renameCollection  from  to  to       Be careful  when you  use this command  renameCollection has different performance implications depending on the target namespace  If the target database is the same as the source database  renameCollection simply changes the namespace  This is a quick operation  If the target database differs from the source database  renameCollection copies all documents from the source collection to the target collection  Depending on the size of the collection  this may take longer to complete

User · Answer

You could do this   db copyDatabase  db to rename   db renamed   localhost   use db to rename db dropDatabase      Editorial Note  this is the same approach used in the question itself but has proven useful to others regardless

User · Answer

From version 4 2  the copyDatabase is deprecated  From now on we should use  mongodump and mongorestore  Let s say we have a database named  old name and we want to rename it to new name  First we have to dump the database  mongodump --archive  quot old name dump db quot  --db old name  If you have to authenticate as a user then use  mongodump -u username --authenticationDatabase admin             --archive  quot old name dump db quot  --db old name  Now we have our db dumped as a file named  old name dump db  To restore with a new name  mongorestore --archive  quot old name dump db quot  --nsFrom  quot old name   quot  --nsTo  quot new name   quot   Again  if you need to be authenticated add this parameters to the command  -u username --authenticationDatabase admin   Reference  https   docs mongodb com manual release-notes 4 2-compatibility  remove-support-for-the-copydb-and-clone-commands

User · Answer

NOTE  Hopefully this changed in the latest version       You cannot copy data between a MongoDB 4 0 mongod instance  regardless   of the FCV value  and a MongoDB 3 4 and earlier mongod instance    https   docs mongodb com v4 0 reference method db copyDatabase    ALERT  Hey folks just be careful while copying the database  if you don t want to mess up the different collections under single database   The following shows you how to rename   gt  show dbs  testing games movies   To rename you use the following syntax  db copyDatabase  old db name   new db name     Example   db copyDatabase  testing   newTesting     Now you can safely delete the old db by the following way  use testing   db dropDatabase      Here the db   testing   is deleted successfully   Now just think what happens if you try renaming the new database name with existing database name  Example   db copyDatabase  testing   movies       So in this context all the collections  tables  of testing will be copied to movies database

User · Answer

The above process is slow you can use below method but you need to move collection by collection to another db   use admin db runCommand  renameCollection    db old name   collection name    to    db new name   collection name

[mongodb] How do you rename a MongoDB database?

Examples related to mongodb

Examples related to database