I have a web application using MongoDB (Version 2.6.12), hosted in a (Ubuntu 16.04) server of DigitalOcean.
I like to use Robo 3T to connect to the remote database and do simple queries.
Sometimes I backup the database with
mongodump, and mostly rely on the weekly auto server snapshot provided by DigitalOcean.
Now, I need to undertake queries containing like
$lookup, they told me that MongoDB Version 2.16.12 does not support that. So I need to seriously backup my database and use a more recent MongoDB. I still want to keep using Robo3T to do queries to production database (by preference) or backup database (if it is updated very often, e.g., every day).
I have several questions:
1) I would prefer to have a more regular auto-backup (e.g., every day) of the database. Which way is recommended? (Additionally, it seems that Atlas does NOT support Cloud Provider Snapshots for clusters served on DigitalOcean?)
2) If I buy a new server hosted on Azure and install MongoDB 4.2, and copy the whole database by
mongodump to the new server, will it work?