R
Railway•10mo ago
_jygnacio

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.
No description
67 Replies
Percy
Percy•10mo ago
Project ID: b7cca97f-dccc-4373-b85f-101a7dcf303d
_jygnacio
_jygnacio•10mo ago
b7cca97f-dccc-4373-b85f-101a7dcf303d
Brody
Brody•10mo ago
can you connect to the database locally? is there anything bad in the logs?
_jygnacio
_jygnacio•10mo ago
as locally? It was working fine until I did that deploy by accident, it had that command by default.
Brody
Brody•10mo ago
there's nothing wrong with that start command, that's the default start command, have you changed it?
_jygnacio
_jygnacio•10mo ago
no, I just did the deploy Is there a way to reverse changes?
Brody
Brody•10mo ago
did you deploy code into your database service?
_jygnacio
_jygnacio•10mo ago
only that command I used when deploying in start command, but if I uploaded code to the database? only before entering the command.
Brody
Brody•10mo ago
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
_jygnacio
_jygnacio•10mo ago
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
Brody
Brody•10mo ago
before what
_jygnacio
_jygnacio•10mo ago
before making that deploy
Brody
Brody•10mo ago
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?
_jygnacio
_jygnacio•10mo ago
I'm sorry, it may be because I am using a translator. I entered that command and I got the problem. 😦
Brody
Brody•10mo ago
why would you enter that command though? that is the default start command mysql already comes with
_jygnacio
_jygnacio•10mo ago
that's what he said
No description
Brody
Brody•10mo ago
can you try re-deploying it
_jygnacio
_jygnacio•10mo ago
I did it, but it still says database connection
_jygnacio
_jygnacio•10mo ago
Where do I enter this code?
No description
_jygnacio
_jygnacio•10mo ago
or this command
Brody
Brody•10mo ago
locally, but you would need to have mysql installed show me a screenshot of the service itself please
_jygnacio
_jygnacio•10mo ago
how, in railway? this?
No description
Brody
Brody•10mo ago
a screenshot with the deployments tab open please
_jygnacio
_jygnacio•10mo ago
ok
_jygnacio
_jygnacio•10mo ago
all are with the same command
No description
Brody
Brody•10mo ago
I'm really not too sure of the relevance of the start command here, unless you changed something about it?
_jygnacio
_jygnacio•10mo ago
no, nothing
Brody
Brody•10mo ago
either way, the database says it's active, so please try connecting to it locally with software like dbgate
_jygnacio
_jygnacio•10mo ago
ok, wait
_jygnacio
_jygnacio•10mo ago
now this appears, there is no table
No description
Brody
Brody•10mo ago
please ignore anything the data tab says, use dbgate from your computer to connect to the data
_jygnacio
_jygnacio•10mo ago
ok I have already connected to the database with dbgate.
Brody
Brody•10mo ago
okay then that means it's working
_jygnacio
_jygnacio•10mo ago
and now?
Brody
Brody•10mo ago
can you connect to the database with dbgate?
_jygnacio
_jygnacio•10mo ago
yes, but where are the boards that I had in railway
No description
_jygnacio
_jygnacio•10mo ago
sorry for my inexperience
Brody
Brody•10mo ago
what do you mean by boards? tables? from your screenshot, it looks like you have 38 tables
_jygnacio
_jygnacio•10mo ago
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.
Brody
Brody•10mo ago
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?
_jygnacio
_jygnacio•10mo ago
no
Brody
Brody•10mo ago
out of those 38 tables, none are yours? (bottom left)
_jygnacio
_jygnacio•10mo ago
none
Brody
Brody•10mo ago
in the upper left corner, click the railway database
_jygnacio
_jygnacio•10mo ago
its empty
Brody
Brody•10mo ago
i would trust that information from dbgate, seems as though you did something to wipe and shutdown your database
_jygnacio
_jygnacio•10mo ago
nothing really, but it is not of much importance, it is just a few tables and test information.
_jygnacio
_jygnacio•10mo ago
this is what I had
No description
Brody
Brody•10mo ago
did the migration fail?
_jygnacio
_jygnacio•10mo ago
i dont know, a colleague migrated him
Brody
Brody•10mo ago
screenshot of the project please
_jygnacio
_jygnacio•10mo ago
but as far as I can see they never occupied the new database. Because mysql legacy and mysql are functional or not? this?
Brody
Brody•10mo ago
- delete the new mysql database with a volume - rename Postgres Legacy to just Postgres - run the migration
_jygnacio
_jygnacio•10mo ago
ok ready
Brody
Brody•10mo ago
ready? did the migration complete?
_jygnacio
_jygnacio•10mo ago
yes
Brody
Brody•10mo ago
using dbgate, is the data in the new database?
_jygnacio
_jygnacio•10mo ago
I can't find them
Brody
Brody•10mo ago
screenshot please
_jygnacio
_jygnacio•10mo ago
no now yes, it was empty but not anymore.
Brody
Brody•10mo ago
awsome
_jygnacio
_jygnacio•10mo ago
last question
Brody
Brody•10mo ago
yes?
_jygnacio
_jygnacio•10mo ago
i delete this?
No description
Brody
Brody•10mo ago
yes you can
_jygnacio
_jygnacio•10mo ago
does it affect anything? thank you very much, really. and sorry for the inconvenience.
Brody
Brody•10mo ago
no problem!
Want results from more Discord servers?
Add your server