[mongoDB] DB 복사하기

Database

[mongoDB] DB 복사하기

코린이예요 2019. 6. 17. 15:09

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")