Docs Menu

Docs Home → Launch & Manage MongoDB → MongoDB Atlas

Import Archive from S3

On this page

  • Prerequisites
  • Procedure

Note

This feature is not available for M0 free clusters, M2, and M5 clusters. To learn more about which features are unavailable, see Atlas M0 (Free Cluster), M2, and M5 Limits.

You can restore data archived to S3 buckets using mongoimport and mongorestore. This page has a sample procedure to import archived data and rebuild indexes using the AWS CLI and the MongoDB Database Tools.

Prerequisites

Before you begin, you must:

Procedure

1

Copy the data in the S3 bucket to a folder using the AWS CLI and extract the data.

aws s3 cp s3://<bucketName>/<prefix> <downloadFolder> --recursive
gunzip -r <downloadFolder>

where:

<bucketName>
Name of the AWS S3 bucket.
<prefix>

Path to archived data in the bucket. The path has the following format:

/exported_snapshots/<orgId>/<projectId>/<clusterName>/<initiationDateOfSnapshot>/<timestamp>/
<downloadFolder>
Path to the local folder where you want to copy the archived data.

For example, run a command similar to the following:

Example

aws s3 cp
s3://export-test-bucket/exported_snapshots/1ab2cdef3a5e5a6c3bd12de4/12ab3456c7d89d786feba4e7/myCluster/2021-04-24T0013/1619224539
mybucket --recursive
gunzip -r mybucket
2

Copy and store the following script in a file named massimport.sh.

#!/bin/bash
regex='/(.+)/(.+)/.+'
dir=${1%/}
connstr=$2
# iterate through the subdirectories of the downloaded and
# extracted snapshot export and restore the docs with mongoimport
find $dir -type f -not -path '*/\.*' -not -path '*metadata\.json' | while read line ; do
  [[ $line =~ $regex ]]
  db_name=${BASH_REMATCH[1]}
  col_name=${BASH_REMATCH[2]}
  mongoimport --uri "$connstr" --mode=upsert -d $db_name -c $col_name --file $line --type json
done
# create the required directory structure and copy/rename files
# as needed for mongorestore to rebuild indexes on the collections
# from exported snapshot metadata files and feed them to mongorestore
find $dir -type f -name '*metadata\.json' | while read line ; do
  [[ $line =~ $regex ]]
  db_name=${BASH_REMATCH[1]}
  col_name=${BASH_REMATCH[2]}
  mkdir -p ${dir}/metadata/${db_name}/
  cp $line ${dir}/metadata/${db_name}/${col_name}.metadata.json
done

Here:

  • --mode=upsert enables mongoimport to handle duplicate documents from an archive.

  • --uri specifies the connection string for the Atlas cluster.

3

Run the massimport.sh utility to import the archived data into the Atlas cluster.

sh massimport.sh <downloadFolder> "mongodb+srv://<connectionString>"

where:

<downloadFolder>
Path to the local folder where you copied the archived data.
<connectionString>
Connection string for the Atlas cluster.

For example, run a command similar to the following:

Example

sh massimport.sh mybucket "mongodb+srv://<myConnString>"
← Restore a Cloud Manager Snapshot to Atlas
Archive Data →

On this page