[mongoDB] DB 복사하기

1. Local에서 

a. json 파일 저장

$ mongodump --db [db_name] --out [dump_folder_path]

2019-06-17T14:31:07.785+0900    writing [db name].[collection1] to
2019-06-17T14:31:07.785+0900    writing [db name].[collection2] to
2019-06-17T14:31:07.785+0900    writing [db name].[collection3] to
2019-06-17T14:31:07.786+0900    writing [db name].[collection4] to
2019-06-17T14:31:07.791+0900    done dumping [db name].[collection1] (3 documents)
2019-06-17T14:31:07.791+0900    writing [db name].[collection5] to
2019-06-17T14:31:07.795+0900    done dumping o[db name].[collection2] (114 documents)
2019-06-17T14:31:07.795+0900    writing [db name].[collection6] to
2019-06-17T14:31:07.798+0900    done dumping [db name].[collection3] (3 documents)
2019-06-17T14:31:07.798+0900    writing [db name].[collection7] to
2019-06-17T14:31:07.799+0900    done dumping [db name].[collection4] (2 documents)
.......

 

$ cd [directory]

ls 명령어 때려보면 .json 파일로 dump file이 생긴것을 확인할 수 있다.

b. import 하기

$ mongorestore -d [db_name] [dump_folder_path]

---

2. Remote server에서 

 

You can specify host, port, username and password for remote databases connections backups like below.

$ mongodump --host [ip] --port 27017 --username [username] --password [password] --db [db_name] --out [dump_folder_path]

2019-06-17T15:02:08.962+0900    reading metadata for [db name].[collection1] from /root/collection1.json
2019-06-17T15:02:08.962+0900    reading metadata for [db name].[collection2] from /root/collection2.json
2019-06-17T15:02:08.963+0900    reading metadata for [db name].[collection3] from /root/collection3.json
2019-06-17T15:02:09.044+0900    finished restoring [db name].[collection4] (3 documents)
2019-06-17T15:02:09.044+0900    reading metadata for [db name].[collection5] from /root/collection5.json
2019-06-17T15:02:09.044+0900    no indexes to restore
2019-06-17T15:02:09.044+0900    finished restoring [db name].[collection6] (1 document)
2019-06-17T15:02:09.044+0900    no indexes to restore
2019-06-17T15:02:09.044+0900    finished restoring [db name].[collection7] (114 documents)
2019-06-17T15:02:09.044+0900    reading metadata for [db name].[collection8] from /root/collection8.json
....

 

---

아래 접은글 무시

$ mongo [ip:port] -u admin -p --authenticationDatabase admin

 

DB list보기

show dbs 

 

1. Local에서 복사 

db.copyDatabase("DB명","복사된DB명")    //    ""안에 쓰기

2. 원격지로 데이터 복사

db.copyDatabase("DB명","복사될DB명","[ip]:27017")

$ mongo [ip:port] -u admin -p --authenticationDatabase admin

 

DB list보기

show dbs 

 

1. Local에서 복사 

db.copyDatabase("DB명","복사된DB명")    //    ""안에 쓰기

2. 원격지로 데이터 복사

db.copyDatabase("DB명","복사될DB명","[ip]:27017")