Very basic question. I have had Directus installed under a Plesk/Ubuntu server but the panel shows no databases, so I was wondering where are the actual databases/tables generated by the collections. I was expecting some MySQL views, but I see nothing.
2 Answers
2It depends on how you’ve installed Directus. The system tables and collections you create in Directus are created in the database you have connected through Directus’ environment variables.
yes but apart from the database type, I was looking at ways to see the actual tables (on the server rather than on Directus backend). Not that I have to do anything, just to understand how they are created. It’s strange that Plesk shows no databases created.
I don't know if Plesk has a way to natively show the contents of a database, but you should be able to use something like TablePlus or DBeaver to connect using the same credentials you have configured Directus to use to explore the tables and rows directly in the database~
– rijkvanzanten
It depends on your Docker Compose. Did you choose MySQL, or, if left empty, it will default to SQLite.
– AbhinayMe