Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Support
  3. Database Access & Backups?

Database Access & Backups?

Scheduled Pinned Locked Moved Solved Support
databasebackupsdata migrationapps
6 Posts 5 Posters 1.4k Views 5 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • ajtatumA Offline
      ajtatumA Offline
      ajtatum
      wrote on last edited by girish
      #1

      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

      BrutalBirdieB 1 Reply Last reply
      0
      • ajtatumA 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

        BrutalBirdieB Offline
        BrutalBirdieB Offline
        BrutalBirdie
        Partner
        wrote on last edited by BrutalBirdie
        #2

        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.

        Like my work? Consider donating a drink. Cheers!

        1 Reply Last reply
        2
        • girishG Do not disturb
          girishG Do not disturb
          girish
          Staff
          wrote on last edited by
          #3

          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".

          1 Reply Last reply
          0
          • girishG Do not disturb
            girishG Do not disturb
            girish
            Staff
            wrote on last edited by
            #4

            @sarah-white are you a bot?

            1 Reply Last reply
            0
            • girishG Do not disturb
              girishG Do not disturb
              girish
              Staff
              wrote on last edited by
              #5

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

              micmcM 1 Reply Last reply
              0
              • girishG girish

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

                micmcM Offline
                micmcM Offline
                micmc
                wrote on last edited by
                #6

                @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!

                Ignorance is not an excuse anymore!
                https://AutomateKit.com

                1 Reply Last reply
                3
                Reply
                • Reply as topic
                Log in to reply
                • Oldest to Newest
                • Newest to Oldest
                • Most Votes


                  • Login

                  • Don't have an account? Register

                  • Login or register to search.
                  • First post
                    Last post
                  0
                  • Categories
                  • Recent
                  • Tags
                  • Popular
                  • Bookmarks
                  • Search