Database connection
I am still a newbie, I need help with this, I did a deploy with this default startup command ( docker-entrypoint.sh mysqld --innodb-use-native-aio=0) and I don't know how to fix this.
67 Replies
Project ID:
b7cca97f-dccc-4373-b85f-101a7dcf303db7cca97f-dccc-4373-b85f-101a7dcf303d
can you connect to the database locally?
is there anything bad in the logs?
as locally? It was working fine until I did that deploy by accident, it had that command by default.
there's nothing wrong with that start command, that's the default start command, have you changed it?
no, I just did the deploy
Is there a way to reverse changes?
did you deploy code into your database service?
only that command I used when deploying in start command, but if I uploaded code to the database? only before entering the command.
I'm sorry but I'm not understanding what has happened, I see that you have a database that the dashboard can't connect to, but I don't know what you have done to break the database, please explain in more detail
the only problem is that it doesn't connect, I haven't done anything but deploy with that startup command, and before that it was working fine.
I have done nothing else
before what
before making that deploy
to me thats the same as saying "before deploying a database, the database worked" I'm sorry but it makes no sense to me
all the mysql databases come with that start command, so I'm really not sure how that start command is relevant?
I'm sorry, it may be because I am using a translator. I entered that command and I got the problem. 😦
why would you enter that command though? that is the default start command mysql already comes with
that's what he said
can you try re-deploying it
I did it, but it still says database connection
Where do I enter this code?
or this command
locally, but you would need to have mysql installed
show me a screenshot of the service itself please
how, in railway? this?
a screenshot with the deployments tab open please
ok
all are with the same command
I'm really not too sure of the relevance of the start command here, unless you changed something about it?
no, nothing
either way, the database says it's active, so please try connecting to it locally with software like dbgate
ok, wait
now this appears, there is no table
please ignore anything the data tab says, use dbgate from your computer to connect to the data
ok
I have already connected to the database with dbgate.
okay then that means it's working
and now?
can you connect to the database with dbgate?
yes, but where are the boards that I had in railway
sorry for my inexperience
what do you mean by boards? tables?
from your screenshot, it looks like you have 38 tables
yes tables sorry. but before in railway the tables that I created in railway appeared to me, those that are there are not the ones that I use, I suppose that they are of the system.
going forward, it would be best if you pretended the data tab didnt exist, it is riddled with bugs so i wouldnt trust anything it shows/doesnt show
do your tables show in dbgate?
no
out of those 38 tables, none are yours? (bottom left)
none
in the upper left corner, click the railway database
its empty
i would trust that information from dbgate, seems as though you did something to wipe and shutdown your database
nothing really, but it is not of much importance, it is just a few tables and test information.
this is what I had
did the migration fail?
i dont know, a colleague migrated him
screenshot of the project please
but as far as I can see they never occupied the new database. Because mysql legacy and mysql are functional or not?
this?
- delete the new mysql database with a volume
- rename
Postgres Legacy to just Postgres
- run the migrationok
ready
ready? did the migration complete?
yes
using dbgate, is the data in the new database?
I can't find them
screenshot please
no now yes, it was empty but not anymore.
awsome
last question
yes?
i delete this?
yes you can
does it affect anything?
thank you very much, really. and sorry for the inconvenience.
no problem!