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.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login