Restoring the Apostrophe database from backup

[programarivm]

Hi there,

I've created my first Apostrophe site. As a newbie, I'd expect the docs to describe how to dump and load a MongoDB 4.4 database in a one-liner command.

Example:

• Restoring Your Database From Backup

Thank you,

[BoDonkey]

Hey @programarivm,
Congrats!
You can take a look at the large amount of documentation for MongoDB.
https://www.mongodb.com/basics/backup-and-restore
We will try and put together a small tutorial soon.
Cheers,
Bob

[programarivm]

Thanks for the swift response @BoDonkey. I think it should be a one-liner command for MongoDB 4.4. One reason to stay away from MongoDB 5 is it requires CPU support for AVX instructions. See turnkeylinux/tracker#1724

[BoDonkey]

I guess it all depends on your hosting model. Many of our clients use Atlas, so their host server for the Apostrophe instance(s) doesn't matter as much.
With regards to the "one-liner" -> Don't mongorestore and mongodump fulfill that?

[programarivm]

This is what I'd do to dump the database after Setting up Apostrophe.

mongodump -h localhost:27017 -d "apos-app" -u "my-user" -p password
2023-03-15T11:18:03.696+0100	Failed: can't create session: could not connect to server: connection() error occurred during connection handshake: auth error: sasl conversation error: unable to authenticate using mechanism "SCRAM-SHA-1": (AuthenticationFailed) Authentication failed.

Not too sure if it is correct.

[programarivm]

This one did the trick.

mongodump --db "apos-app"
2023-03-15T11:29:27.027+0100	writing apos-app.aposDocs to dump/apos-app/aposDocs.bson
2023-03-15T11:29:27.029+0100	writing apos-app.aposMigrations to dump/apos-app/aposMigrations.bson
2023-03-15T11:29:27.029+0100	writing apos-app.sessions to dump/apos-app/sessions.bson
2023-03-15T11:29:27.035+0100	done dumping apos-app.aposMigrations (21 documents)
2023-03-15T11:29:27.035+0100	done dumping apos-app.aposDocs (7 documents)
2023-03-15T11:29:27.036+0100	done dumping apos-app.sessions (0 documents)
2023-03-15T11:29:27.036+0100	writing apos-app.aposAttachments to dump/apos-app/aposAttachments.bson
2023-03-15T11:29:27.036+0100	writing apos-app.aposBearerTokens to dump/apos-app/aposBearerTokens.bson
2023-03-15T11:29:27.036+0100	writing apos-app.aposCache to dump/apos-app/aposCache.bson
2023-03-15T11:29:27.037+0100	done dumping apos-app.aposAttachments (0 documents)
2023-03-15T11:29:27.037+0100	writing apos-app.aposLocks to dump/apos-app/aposLocks.bson
2023-03-15T11:29:27.038+0100	done dumping apos-app.aposCache (0 documents)
2023-03-15T11:29:27.038+0100	done dumping apos-app.aposLocks (0 documents)
2023-03-15T11:29:27.038+0100	done dumping apos-app.aposBearerTokens (0 documents)
2023-03-15T11:29:27.039+0100	writing apos-app.aposNotifications to dump/apos-app/aposNotifications.bson
2023-03-15T11:29:27.039+0100	done dumping apos-app.aposNotifications (0 documents)
2023-03-15T11:29:27.043+0100	writing apos-app.aposUsersSafe to dump/apos-app/aposUsersSafe.bson
2023-03-15T11:29:27.044+0100	done dumping apos-app.aposUsersSafe (1 document)

For further information:

• How do I create a MongoDB dump of my database?

[programarivm]

Now I'm having trouble to restore my database. It seems as if something may be wrong with using hyphens in a MongoDB database name:

• Cannot select MongoDB database with dash in name
• Unable to use db with hypens in name from shell
• DO NOT use hyphens in MongoDB collection names

Dev teams may be tempted to use hyphens in their database names like "apos-app" or "a3-boilerplate" causing unexpected issues.

[programarivm]

Finally this is how I am restoring the database.

mongorestore --db myapp dump/myapp 

Remember, it is more convenient to not use hyphens in the database name.

I hope this helps.

[boutell]

We use database names without hyphens on a regular basis btw, with all supported MongoDB versions.

I recommend the --archive option of mongodump and mongorestore, and passing a URI to those tools rather than individual parameters, but it works the other way too.

[programarivm]

BTW @BoDonkey, I was wondering if these two commands could be run in the root folder of the Apostrophe site:

Dump:

mongodump --db myapp

Restore:

mongorestore --db myapp dump/myapp

If so, does it make sense to mkdir a dump folder? What about adding the following lines to the .gitignore file?

...
# Restore the database from backup
/dump/*
!/dump/.gitkeep

[boutell]

I recommend: mongodump --uri="mongodb://localhost:27017/my-database-name" --archive --gzip > mydatabasedump.tar.gz mongorestore mongodb://localhost:27017/ --nsInclude="my-database-name.*" --archive --gzip --drop < mydatabasedump.tar.gz No need for a folder, and it is possible to connect these commands in a Unix pipeline. Yes, listing the database name in the URL in the first command but not the second feels odd, but you'll get warnings if you use "--db" or a fully qualified URL with a database name with mongorestore these days.

…

On Wed, Mar 15, 2023 at 12:39 PM Jordi Bassaganas ***@***.***> wrote: BTW, I was wondering if these two commands could be run in the main folder of the Apostrophe site: Dump: mongodump --db myapp Restore: mongorestore --db myapp dump/myapp If so, does it make sense to mkdir a dump folder? What about adding the following lines to the .gitignore file? ... # Restore the database from backup /dump/* !/dump/.gitkeep — Reply to this email directly, view it on GitHub <#4092 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAAH27L4W5EJH2FYV7UQJ5DW4HWCTANCNFSM6AAAAAAV3Q5HCE> . You are receiving this because you commented.Message ID: ***@***.***>

-- THOMAS BOUTELL | CHIEF TECHNOLOGY OFFICER APOSTROPHECMS | apostrophecms.com | he/him/his