You can download the backup from the sprinter portal. You can manage your backups from the backups page.
and from here you can define which environment you want, and create a snapshot from the current database. Then select the snapshot and click download
You will get three options. Number 2 and 3 are self explanatory, and number 1 are Files and Database combined. If you download the full backup. it will be in a compressed format. You can use 7zip to extract the files twice, until you get access to the db and file folders. In the db folder, you will have the .db file which you can use in the blog post below.
Here is a blog post to help you
If you want to include files when you run locally, copy all the contents in the file folder, and navigate to your mendix projects deployment directory
and replace the contents in our deployment directories file folder, with the contenets from the cloud backup.
You can also use the Java API if you need direct database access: https://apidocs.mendix.com/7/runtime/com/mendix/datastorage/DataStorage.html
Some examples can be found here: https://github.com/ako/QueryApiBlogPost
I'm new to Mendix: just started today my learning path.
Very inspiring, indeed. Then a question came to mind: what about the DB ? Is it accessible ? How ?
I haven't found an ultimate answer.
Snapshots are ok. OData export even more.
But in the real world I'd like to have full access to data, like running a query on the fly on a table with millions of records.
Or even mass update a set of records.
Being cut away from my data makes me feel very uncomfortable.
Is there any other solution other than snapshots and export ?
If you run in the Mendix Cloud, you cannot access your data by connecting directly to your database. In this case you can alter your data via
If you want to have totally access to your database you could deploy your database on-premise.