Shulou(Shulou.com)06/01 Report--

I. full database backup and recovery

# mongodump-d my_mongodb-o my_mongodb_dump

# mongorestore-d my_mongodb my_mongodb_dump/*

II. JSON Collection backup and recovery

$mongoexport-d test-c book-o book.json

Connected to: 10.77.20.xx

Exported 2 records

$mongoimport-d test-c book book.json

Connected to: 10.77.20.xx

Imported 2 objects

3. CSV Collection data export and import

# more students.txt

{"classid": 1, "age": 20, "name": "kobe"}

{"classid": 1, "age": 23, "name": "nash"}

{"classid": 2, "age": 18, "name": "james"}

{"classid": 2, "age": 19, "name": "wade"}

{"classid": 2, "age": 19, "name": "bosh"}

{"classid": 2, "age": 25, "name": "allen"}

{"classid": 1, "age": 19, "name": "howard"}

{"classid": 1, "age": 22, "name": "paul"}

{"classid": 2, "age": 24, "name": "shane"}

#

1. Import data

# mongoimport-d test-c students students.txt

Connected to: 127.0.0.1

Tue Apr 22 16:02:32 imported 9 objects

> db.students.find () db.students.find ()

{"_ id": ObjectId ("53562218bc98e02b24984175"), "classid": 1, "age": 20, "name": "kobe"}

{"_ id": ObjectId ("53562218bc98e02b24984176"), "classid": 1, "age": 23, "name": "nash"}

{"_ id": ObjectId ("53562218bc98e02b24984177"), "classid": 2, "age": 18, "name": "james"}

{"_ id": ObjectId ("53562218bc98e02b24984178"), "classid": 2, "age": 19, "name": "wade"}

{"_ id": ObjectId ("53562218bc98e02b24984179"), "classid": 2, "age": 19, "name": "bosh"}

{"_ id": ObjectId ("53562218bc98e02b2498417a"), "classid": 2, "age": 25, "name": "allen"}

{"_ id": ObjectId ("53562218bc98e02b2498417b"), "classid": 1, "age": 19, "name": "howard"}

{"_ id": ObjectId ("53562218bc98e02b2498417c"), "classid": 1, "age": 22, "name": "paul"}

{"_ id": ObjectId ("53562218bc98e02b2498417d"), "classid": 2, "age": 24, "name": "shane"}

>

two。 Export CSV

# mongoexport-d test-c students-- csv-f classid,name,age-o students_csv.dat

Connected to: 127.0.0.1

Exported 9 records

#

Export only data, excluding _ id

Parameter description:

-h: indicates the IP of the database host

-u: indicates the user name of the database

-p: indicates the password of the database

-d: indicates the name of the database

-c: specify the name of collection

-f: indicates which columns to import

[root@jsmartserv hbk] # more students_csv.dat

Classid,name,age

1, "kobe", 20

1, "nash", 23

2, "james", 18

2, "wade", 19

2, "bosh", 19

2, "allen", 25

1, "howard", 19

1, "paul", 22

2, "shane", 24

[root@jsmartserv hbk] #

3. Delete data

Db.students.remove ()

4. Import CSV

# mongoimport-d test-c students-type csv-headerline-file students_csv.dat

Connected to: 127.0.0.1

Tue Apr 22 16:07:57 imported 9 objects

Parameter description:

-type: indicates the file format to import

-headerline: indicates that the first row is a column name and does not need to be imported

-file: indicates the file to import

5. Verification

Db.students.find () db.students.find ()

{"_ id": ObjectId ("5356235dbc98e02b2498417e"), "classid": 1, "name": "kobe", "age": 20}

{"_ id": ObjectId ("5356235dbc98e02b2498417f"), "classid": 1, "name": "nash", "age": 23}

{"_ id": ObjectId ("5356235dbc98e02b24984180"), "classid": 2, "name": "james", "age": 18}

{"_ id": ObjectId ("5356235dbc98e02b24984181"), "classid": 2, "name": "wade", "age": 19}

{"_ id": ObjectId ("5356235dbc98e02b24984182"), "classid": 2, "name": "bosh", "age": 19}

{"_ id": ObjectId ("5356235dbc98e02b24984183"), "classid": 2, "name": "allen", "age": 25}

{"_ id": ObjectId ("5356235dbc98e02b24984184"), "classid": 1, "name": "howard", "age": 19}

{"_ id": ObjectId ("5356235dbc98e02b24984185"), "classid": 1, "name": "paul", "age": 22}

{"_ id": ObjectId ("5356235dbc98e02b24984186"), "classid": 2, "name": "shane", "age": 24}

>

Query the students collection to verify that the import was successful:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.