Database Backup Import

When you are working with docker, you might need to import data from a backup file. Here is a single command to import data in MySQL and MongoDB from backup.

MySQL

docker cp /path/to/your/backup.sql.gz MYSQL_CONTAINER:/tmp/backup.sql.gz && \
docker exec -it MYSQL_CONTAINER bash -c "\
zcat /tmp/backup.sql.gz > /tmp/backup.sql && \
mysql -u root -p DATABASE_NAME < /tmp/backup.sql && \
rm /tmp/backup.sql.gz && \
rm /tmp/backup.sql"

MongoDB

docker cp /path/to/your/backup.tar.gz MONGO_CONTAINER:/tmp/backup.tar.gz && \
docker exec -it MONGO_CONTAINER bash -c "\
mongorestore --gzip --archive=/tmp/backup.tar.gz --nsInclude='DATABASE_NAME.*' && \
rm /tmp/backup.tar.gz"

Note: If you want to import to a specific collection, replace DATABASE_NAME.* with DATABASE_NAME.COLLECTION_NAME.

If you want to import to a remote database, you can use the following command:

mongorestore \
  --uri="mongodb+srv://<username>:<password>@<cluster-url>/" \
  --gzip --archive=/path/to/your/backup.tar.gz \
  --nsInclude='DATABASE_NAME.*'

Note: Remember to replace <username>, <password>, and <cluster-url> with your actual username, password, and cluster URL.