R
Railwayβ€’9mo ago
vipavee

MYSQL

Hello, I need help to get started to create mySQL database What is an alternative way, to create my database instead of doing in Railway website directly I remember last time, I did it but there was a option to do it through "query" Plus when I tried to create table on Railway one by one, I received error that refer in the picture and not sure how to solve it FYI, I'm using windows Would appreciated your help πŸ™‚
No description
7 Replies
Brody
Brodyβ€’9mo ago
dbgate is a good option to manage the data in your mysql database
vipavee
vipaveeβ€’9mo ago
Thank you. I will check it out. However, the error that I got? Do you know what is it supposed to mean?
Brody
Brodyβ€’9mo ago
in my opinion you should not worry about that, that feature even if it didnt throw an error, has a tendency to insert incorrect data types and cause a lot of headaches, definitely just stick to proper database software like dbgate or mysql workbench
vipavee
vipaveeβ€’9mo ago
I have mysql workbench that has database data inside that I wanted to deploy it on Railway but I dont know how can I start, since I dont think the doc on Railway help me that much
Brody
Brodyβ€’9mo ago
im sure mysql workbench has some sort of clone feature that allows you to connect to both databases so you can clone the data to the railway database railway doesnt have docs on this type of thing, since its not really railway specific
vipavee
vipaveeβ€’9mo ago
Thank you. I made it work now
Brody
Brodyβ€’9mo ago
awesome!