How to install Directus with MYSQL support (on Cloudron)

[systemaddict]

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]

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

[systemaddict]

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

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

[girish]

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

[girish]

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.