Skip to content

Instantly share code, notes, and snippets.

@jmoiron
Created June 30, 2012 21:58
Show Gist options
  • Save jmoiron/3025688 to your computer and use it in GitHub Desktop.
Save jmoiron/3025688 to your computer and use it in GitHub Desktop.
export and import all collections from a mongodb database into/outof a single tarball
#!/bin/bash
LOADING=false
usage()
{
cat << EOF
usage: $0 [options] dbname
OPTIONS:
-h Show this help.
-l Load instead of export
-u Mongo username
-p Mongo password
-H Mongo host string (ex. localhost:27017)
EOF
}
while getopts "hlu:p:H:" opt; do
MAXOPTIND=$OPTIND
case $opt in
h)
usage
exit
;;
l)
LOADING=true
;;
u)
USERNAME="$opt"
;;
p)
PASSWORD="$opt"
;;
H)
HOST="$opt"
;;
\?)
echo "Invalid option $opt"
exit 1
;;
esac
done
shift $(($MAXOPTIND-1))
if [ -z "$1" ]; then
echo "Usage: export-mongo [opts] <dbname>"
exit 1
fi
DB="$1"
if [ -z "$HOST" ]; then
CONN="localhost:27017/$DB"
else
CONN="$HOST/$DB"
fi
ARGS=""
if [ -n "$USERNAME" ]; then
ARGS="-u \"$USERNAME\""
fi
if [ -n "$PASSWORD" ]; then
ARGS="$ARGS -p \"$PASSWORD\""
fi
if $LOADING ; then
echo "Loading into $CONN"
tar -xzf $DB.tar.gz
pushd $DB >/dev/null
for path in *.json; do
collection=${path%.json}
echo "Loading into $DB/$collection from $path"
mongoimport $ARGS -d $DB -c $collection $path
done
popd >/dev/null
rm -rf $DB
else
echo "Exporting from $CONN"
COLLECTIONS=$(mongo $CONN $ARGS --quiet --eval "db.getCollectionNames()" | sed 's/,/ /g')
mkdir /tmp/$DB
pushd /tmp/$DB 2>/dev/null
for collection in $COLLECTIONS; do
echo "Exporting $DB/$collection ..."
mongoexport $ARGS -d $DB -c $collection -o $collection.json
done
pushd /tmp 2>/dev/null
tar -czf "$DB.tar.gz" $DB
popd 2>/dev/null
popd 2>/dev/null
mv /tmp/$DB.tar.gz ./
rm -rf /tmp/$DB
fi
@smashew
Copy link

smashew commented Jul 31, 2013

FYI... this doesn't work. (At least for me on my mac)

This one works!
https://gist.github.com/smashew/6125915

Thank you soo much for posting this, it really helped me!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment