Created
June 30, 2012 21:58
-
-
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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
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!