Database Access & Backups?

[ajtatum]

Hi,

I'm new to Cloudron and I haven't subscribed just yet as I'm still playing around with it.

One thing that I've been trying to figure out is if it's possible to connect to the databases Cloudron implements from my Windows machine using HeidiSQL or something similar. I think I read that it wasn't possible in another topic, but I just want to confirm.

Next up, I understand that backups happen periodically for Cloudrun, but would it be possible to have the databases for each application backups as a gzipped SQL file? For example, right now I'm using Baserow and if, for whatever reason, that went down or I accidentally deleted a table, I wouldn't have any clue how to restore the data.

I have that same concern with implementing n8n. Right now I have that hosted separately on another server, but it would be nice to have Cloudron manage it for me. However, there have been times where I've had to log into the database to look at the workflow history to get the workflow JSON.

Basically, my biggest concern is accessibility to my data if either the service, server, or myself screw up. That's pretty much the only thing hold me back from going crazy and installing all the apps I want. If you could address that and/or offer suggestions/solutions, that would be amazing. If it helps, I'm currently using Vultr but I'm not tied to them by any means.

Thank you,
AJ

[BrutalBirdie]

One thing that I've been trying to figure out is if it's possible to connect to the databases Cloudron implements from my Windows machine using HeidiSQL or something similar. I think I read that it wasn't possible in another topic, but I just want to confirm.

By default no Database is accessible from external sources.
Its also not advised to open up the connection to external sources!

Next up, I understand that backups happen periodically for Cloudrun, but would it be possible to have the databases for each application backups as a gzipped SQL file? For example, right now I'm using Baserow and if, for whatever reason, that went down or I accidentally deleted a table, I wouldn't have any clue how to restore the data.

Each app backup includes a full Database backup of the app.
If something breaks its as easy as a click to roll back to the latest app backup / snapshot.

I have that same concern with implementing n8n. Right now I have that hosted separately on another server, but it would be nice to have Cloudron manage it for me. However, there have been times where I've had to log into the database to look at the workflow history to get the workflow JSON.

By default you can always access each database of each app via the web terminal, but here is also a hack / workaround if you need a UI.

https://forum.cloudron.io/topic/6482/accessing-nextcloud-database?_=1647203298087

Basically, my biggest concern is accessibility to my data if either the service, server, or myself screw up. That's pretty much the only thing hold me back from going crazy and installing all the apps I want. If you could address that and/or offer suggestions/solutions, that would be amazing. If it helps, I'm currently using Vultr but I'm not tied to them by any means.

All app and system data belongs to you and are accessible to you.

The source code for almost everything is here: git.cloudron.io/

Regarding your fear of breaking something. Well. Backups Backups Backups.

Feel free to ask anything here That's what we are here for.

---

Here is one of my own latest screw ups with cloudron
https://forum.cloudron.io/topic/6529/shooting-a-cloudron-server-right-in-the-brain-i-deleted-appsdata-and-boxdata-by-accident

There was a minor issue there due to an code bug, but you can read up on that yourself if you wish to do that.

[girish]

To add to what @BrutalBirdie said, Cloudron is designed for hosting apps (and not databases as such). This means that you can't create databases separately and there is no UI to create/delete databases. It's designed for hosting your app which needs a database. The database is provisioned and updated as needed transparently as part of the app install/update/uninstall process. Very similar to heroku.

Just wanted to point that out, because Cloudron is not a classic style server management panel where one can manage "databases".

[girish]

@sarah-white are you a bot?

[girish]

@sarah-white Good, was just checking since your comment got flagged as spam by the forum.

[micmc]

@girish said in Database Access & Backups?:

@sarah-white Good, was just checking since your comment got flagged as spam by the forum.

Sounds much like replies produced by asking ChatGPT to me!