How to install Directus with MYSQL support (on Cloudron)
-
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?
-
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?
@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 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.
@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
-
@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
@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 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
@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.
-
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.
