How to rename a mongodb database using pymongo?

Question

I need to rename a database I created using pymongo. I'd like to use pymongo to do it. I found this other stackoverflow question that is very similar, and the code snippets look pythonesque, except the use keyword which makes it... I don't know what (Update: Perl probably?).

I did a

client.copy_database('old_name', 'new_name)

And found that I then had new_name in `client.database_names()'. But it appears to have no collections in it? What else do I need to do, to deeply copy the database, using pymongo commands?

copy_database is the right way to do it. Are you sure that command was successful and you copied right database? — zero323
– zero323, Commented Sep 5, 2013 at 22:01

user2804197 · Accepted Answer · 2015-12-15 23:35:06Z

5

From PyMongo 3.0 onwards, you have to use admin.command since copy_database was removed in 3.0:

client.admin.command('copydb',
                     fromdb='source_db_name',
                     todb='target_db_name')

answered Dec 15, 2015 at 23:35

user2804197

4126 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

zero323 · Accepted Answer · 2013-09-05 22:16:39Z

2

import pymongo
client = pymongo.MongoClient()

client.copy_database('foo', 'bar')

assert set(client['foo'].collection_names()) == set(client['bar'].collection_names())

for collection in client['foo'].collection_names():
    assert client['foo'][collection].count() == client['bar'][collection].count()

client.drop_database('foo')

edited Sep 5, 2013 at 22:16

answered Sep 5, 2013 at 22:07

zero323

331k108 gold badges981 silver badges958 bronze badges

2 Comments

Travis Griggs Over a year ago

I tried this. It even answered True. But when I do for e in client.old_name.twigs.find(): print(e), I see a bunch of things. But when I do for e in client.new_name.twigs.find(): print(e), it prints nothing. Which makes me think it didn't really deep copy?

Travis Griggs Over a year ago

I can't spell my own database names. Sigh. Dang. Sorry. (Interpret, it did work)

Salomon Bizimana · Accepted Answer · 2023-01-10 21:43:47Z

0

I tried all above ways but none worked for me, The script below has worked for me and thought it would work for you as well.(Note: con is my database connection )

def rename_database(old_name,new_name):
        #copying collections and documents from old to new database
        for i in con[old_name].list_collection_names():
            con[new_name][i]
            for j in con[old_name][i].find():
                a=con[new_name][i].insert_one(j)
        #dropping old database
        con.drop_database(old_name)

#testing purpose
rename_database("test","newDbName")

edited Jan 10, 2023 at 21:43

answered Jan 10, 2023 at 21:25

Salomon Bizimana

11 bronze badge

Collectives™ on Stack Overflow

How to rename a mongodb database using pymongo?

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related