How to copy password protected database from remote server in mongodb?

Question

I am running mongodb 2.4.8 and need to copy a database from remote server. Server has auth enabled in combination with a user having privileges the database. I have tried copydb but it didn't work. I guess it failed because of remote server using auth in combination with role based user(mentioned under authentication section of documentation).

 host = "myhost.com"
 mynonce = db.runCommand( { copydbgetnonce : 1, fromhost: host } ).nonce
 username = "myuser"
 password = "mypassword"
 password_hash = hex_md5(mynonce + username + hex_md5(username + ":mongo:" + password))
 db.runCommand({ 
   copydb: 1, 
   fromdb: "test", 
   todb: "test", 
   fromhost: host, 
   username: username, 
   key: password_hash 
 })
 # output: { "ok" : 0, "errmsg" : "" }
 # but nothing really gets copied

What other options do I have? I would prefer a solution which can work from within the mongo shell as I do not have ssh access to server.

hasib32 · Accepted Answer · 2014-07-16 20:13:59Z

2

try db.copyDatabase(fromdb, todb, fromhost, username, password). as manual said: http://docs.mongodb.org/manual/reference/method/db.copyDatabase/

answered Jul 16, 2014 at 20:13

hasib32

8351 gold badge14 silver badges32 bronze badges

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

3 Comments

rubish Over a year ago

I tried it first, I received an error stating: not authorized for query on alma_connect.system.users, on adding role userAdmin to the user, I was successfully able to copy the database. Thanks for your help.

rubish Over a year ago

FYI, copyDatabse seems to be a shell wrapper around copydb command.

Ben Slade Over a year ago

For future readers, db.copyDatabase is "Deprecated since version 4.0"

Collectives™ on Stack Overflow

How to copy password protected database from remote server in mongodb?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related