Error SQL 1049

So I have many tables, and when I click them, it shows an error.

I have tried to repair them, but nothing makes them disappear. What can I do to remove them?

Also, here is more info about my software:

That looks quite strange. Please post the results of SHOW DATABASES; (exclude sensitive details).

No problem

Thanks. Your server responds it has a database named "igest". But when you try to use it, it says "unknown database". You likely have a stale, incomplete, or manually created datadir directory, e.g.:

/var/lib/mysql/igest/

but it does not contain a valid set of database/table files — or it is otherwise unreadable/incompatible with the running server.

MariaDB implements schemas as directories, and SHOW DATABASES can include directories "that do not correspond to actual databases." By contrast, USE igest must successfully resolve and open the schema; error 1049 means it could not do so.

I have these folders:

But not the others with errors... they keep appearing on the UI for no reason.

How did you set up the databases? Hope you did not just copy from one server to another one, just by copying files, did you?

I set up the database with a Docker Compose file. When I add a new table in the UI, it stays that way.

even on Export they come as a table:

What did the Docker compose file do actually? If it fired some CREATE DATABASE command, then this should have been correct. But probably composer just created a directory for you?

Hi

Is the a way to sort the columns alphabeticaly?

Regards Chris