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


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    How to install Directus with MYSQL support (on Cloudron)

    Directus
    3
    6
    240
    Loading More Posts
    • 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.
    • S
      systemaddict last edited by girish

      Hi

      I've installed Directus and that will setup a PostGres installation. Is it possible to change that to a MySQL? If not, how do you change a running installation to MySQL?

      girish 1 Reply Last reply Reply Quote 0
      • girish
        girish Staff @systemaddict last edited by

        @systemaddict Can you tell us a bit more about your use case? Why do you want to use MySQL and not PostgreSQL ? Generally, the package specifies which database to use. To use another database, we have to modify the package. I can tell you how to do this, but want to be sure what the use case is fast before sending you down that rabbit hole.

        S 1 Reply Last reply Reply Quote 0
        • S
          systemaddict @girish last edited by

          @girish I guess I'm just used to MySQL and already have tables that I would like to transfer to Directus. But this might be a good time to change 🙂

          MooCloud_Matt girish 2 Replies Last reply Reply Quote 0
          • MooCloud_Matt
            MooCloud_Matt @systemaddict last edited by

            @systemaddict
            Directus is a good software especially because it handles SQL migration automatically, and in this pSQL is a lot faster, and is, in general, a better SQL database than MySQL, with support for more features than MySQL; Directus will emulate for you those features so that you will not feel the difference (obviously you will use resources for this)

            At the end, is not a big thing to clone the app from GitLab, change the manifest and the start.sh file to use MySQL.

            https://git.cloudron.io/cloudron/directus-app
            https://docs.cloudron.io/packaging/tutorial/

            Matteo. R.
            Founder and Tech-Support Manager.
            MooCloud MSP
            Swiss Managed Service Provider

            1 Reply Last reply Reply Quote 2
            • girish
              girish Staff @systemaddict last edited by

              @systemaddict yeah, if possible, it's easier to convert your existing mysqldump to postgresql and then you can import that into cloudron's directus using instructions at https://docs.cloudron.io/guides/import-postgresql/ . Otherwise, you have to modify the Cloudron package to use MySQL as @MooCloud_Matt mentioned.

              1 Reply Last reply Reply Quote 2
              • girish
                girish Staff last edited by

                It seems https://github.com/directus/directus/discussions/2832 suggests that database import/export is the way to go. I was hoping they have some sort of import/export data but they don't have it.

                1 Reply Last reply Reply Quote 0
                • First post
                  Last post
                Powered by NodeBB