MongoDB – How to Rename All Databases When Doing a Mongorestore

mongodbmongodb-4.2mongodumpmongorestore

I have a datadump but I need to change the name of every database while restoring them,
if a database is named "customers" it needs to be "customer2", "products" to "products2"

I can rename an individual database but that will take a lot of time to rename each database separately

mongorestore --nsFrom='PetHotel.pets' --nsTo='PetHouse.pets' --nsInclude="PetHouse.*" dump/

how to I rename all database in a dump?

Best Answer

Should be this one:

mongorestore --nsInclude="PetHotel.*" --nsFrom='PetHotel.*' --nsTo='PetHouse.*' dump/

mongorestore --nsInclude='*.*' --nsFrom='$database$.*' --nsTo='$database$2.*' dump/

First test it with option --dryRun

See Change Collections' Namespaces during Restore

Related Solutions

MySQL and MongoDB – Using Both Together

What is the data like? Why does it need updating every second? Etc. (Your question is very vague; some of my Plans may not apply, but I can't tell without understanding the problem set.)

Plan A:

If you are SELECTing identical queries more often than you are changing the underlying table(s), the MySQL's "Query cache" may be an excellent solution.

query_cache_type = ON
query_cache_size = 100M  -- No more (unless using Aurora)

The rest is automagic.

Plan B:

Redis or Memcached make better caching tools than another database (eg, MongoDB).

Plan C:

Let's look at your queries and see if they can be sped up. Better indexes, rearrange the schema, better queries, etc.

Plan D:

Devise some scheme that "knows" whether the data has changed, and avoid re-performing the query.

Mongodb – How to update collections and restore while doing mongorestore

Sorry, not possible. If you could update dump, you must have possibility to update indexes too...

Best Answer

Related Solutions

MySQL and MongoDB – Using Both Together

Mongodb – How to update collections and restore while doing mongorestore

Related Question