R
Railway•13mo ago
Teph Gab

Urgent! all my_sql data are gone! please help!

i just made a push then all mysql data are now empty!
86 Replies
Percy
Percy•13mo ago
Project ID: N/A
Brody
Brody•13mo ago
where do you see the missing data?
Teph Gab
Teph Gab•13mo ago
all my table are empty
Brody
Brody•13mo ago
what software are you using to view the database data?
Teph Gab
Teph Gab•13mo ago
the railway platform are mysql workbench somtimes please help those data are important
Brody
Brody•13mo ago
check with mysql workbench, do not use the railway dashboard to view your data
Teph Gab
Teph Gab•13mo ago
also empty now when i use mysl workbench all table a cleared
Brody
Brody•13mo ago
try restarting the database
Teph Gab
Teph Gab•13mo ago
what about the datas i just loosed?
Brody
Brody•13mo ago
try restarting the database please
Teph Gab
Teph Gab•13mo ago
let me try how todo that?
Brody
Brody•13mo ago
from the settings tab in the plugin
Teph Gab
Teph Gab•13mo ago
otion is not clickable this option is not clickable
Brody
Brody•13mo ago
show me?
Teph Gab
Teph Gab•13mo ago
okay
Teph Gab
Teph Gab•13mo ago
No description
Teph Gab
Teph Gab•13mo ago
i cant't loose thos data please help are you there?
Brody
Brody•13mo ago
@thomas something doesn't seem right here
Teph Gab
Teph Gab•13mo ago
??
Brody
Brody•13mo ago
I don't work for railway, Thomas does, he's a support engineer
thomas
thomas•13mo ago
I need more details, project ID please
Teph Gab
Teph Gab•13mo ago
@thomas okay a moment
thomas
thomas•13mo ago
Yeah don't do that, you will be banned, Brody can you can't Can you link the rules Brody
Teph Gab
Teph Gab•13mo ago
6631d42b-d095-4ee8-ae80-f7815322a9c0
Brody
Brody•13mo ago
please no pings #🛂|readme #5
Teph Gab
Teph Gab•13mo ago
i did not know
Brody
Brody•13mo ago
we understand this is a stressful situation, but please be patient while this gets sorted out
Teph Gab
Teph Gab•13mo ago
Okay thank you. so what do i do know
Brody
Brody•13mo ago
please be patient while this gets sorted out
+ be available if thomas needs any more information from you
Teph Gab
Teph Gab•13mo ago
Okay i will be waiting
thomas
thomas•13mo ago
No description
thomas
thomas•13mo ago
are you sure you can't click restart database? it's kinda greyed out by default
Teph Gab
Teph Gab•13mo ago
yes cursor show a red circle when hover it i just try again and i still can click do that will help getting the datas back?
thomas
thomas•13mo ago
can or can't?
Teph Gab
Teph Gab•13mo ago
can't
thomas
thomas•13mo ago
Possibly, it depends what happened to it it won't hurt can I restart it for you?
Teph Gab
Teph Gab•13mo ago
please or can you do a rollback from your side or something like that?
thomas
thomas•13mo ago
restarting and not tonight I can't did you drop the table or something?
Teph Gab
Teph Gab•13mo ago
no!
thomas
thomas•13mo ago
I am going offline soon, I jumped on this. Please give me as much detail as possible what happened it should have restarted please check your data NOT on railway
Teph Gab
Teph Gab•13mo ago
everything was working fine a just made a push then all my datas was cleared
thomas
thomas•13mo ago
all tables? I see tables
Teph Gab
Teph Gab•13mo ago
all important tables
thomas
thomas•13mo ago
please check again
Teph Gab
Teph Gab•13mo ago
still empty
Brody
Brody•13mo ago
use mysql workbench for this check please
Teph Gab
Teph Gab•13mo ago
jusct checked
thomas
thomas•13mo ago
with mysql workbench?
Teph Gab
Teph Gab•13mo ago
i just used it still empty this is the first time i have such a big issue on the platform are you still there?
thomas
thomas•13mo ago
yes, but not for much longer this is past the end of my day
Teph Gab
Teph Gab•13mo ago
so what do i do? can someone else help me?
thomas
thomas•13mo ago
Ok, I can't help you futher tonight. Please do the follow: Review the change made during the push. Make sure your code didn't cause this. We don't just drop tables. List the tables that are important and when they were in the state that was last known good. Be polite to our conductors I will bring this up with the team tomorrow. and see what we can do
Teph Gab
Teph Gab•13mo ago
i make a push every 2 o 3 days this never happen
thomas
thomas•13mo ago
Good night, please be polite. I understand that. Please document as much as possible for me tomorrow
Duchess
Duchess•13mo ago
Thread has been flagged to Railway team by @thomas.
Ayush
Ayush•13mo ago
@Teph Gab how are you interfacing with mysql from your main app?
Teph Gab
Teph Gab•13mo ago
you mean mean i do i access mysql? i usualy just use mysql on railway dashboard or mysql workbench but most of the time i just use mysql on railway dashboard
Ayush
Ayush•13mo ago
No i mean how does your apps talk to your mysql db? via an ORM or executing raw sql (persay)?
Teph Gab
Teph Gab•13mo ago
i don't think i got the question clearly, but it that can help this is a laravel app i have made a backup yesterday i just resused it now the biggest problem is the taday data because i have'nt made any backup yet today can you find my lost data from your side, i mean do you have any backup of existing databases on your server?
Brody
Brody•13mo ago
they don't work for railway either for reference, the only people who work for railway are the users with the railway icon badge besides their name
Teph Gab
Teph Gab•13mo ago
Noted. thank you well this is a realy stressfull situation
Brody
Brody•13mo ago
and although I don't work for railway, I am fairly certain railway would not have an easily accessible backup that's newer than your backup are you on the pro plan?
Teph Gab
Teph Gab•13mo ago
no.
Brody
Brody•13mo ago
I'm not really sure how much they can do for you here unfortunately
Teph Gab
Teph Gab•13mo ago
oh God i hope they can find a way
Brody
Brody•13mo ago
I would not hope if i where you, just trying to be realistic here
Teph Gab
Teph Gab•13mo ago
Do railway are still doing upgrade or something like that that would provoke that kind of issue?
Brody
Brody•13mo ago
I'll be completely honest with you, and I am not trying to throw around blame, but as it stands this looks like it's something you have done
Ayush
Ayush•13mo ago
@Teph Gab share your push commit Railway states that they do not reccomend DB for anything mission critical. You should be weary of that and have your own backups in place
Brody
Brody•13mo ago
the root cause can extend beyond their commit, something they did in the dashboard, or something they did in mysql workbench
Teph Gab
Teph Gab•13mo ago
push commit you said?
Ayush
Ayush•13mo ago
share your latest commit that 'broke' the DB and we can have a look code wise
Brody
Brody•13mo ago
teph, you have already restored a backup that you took, railway wouldn't have a backup that's significantly newer than yours, the best course of action here would just to be more careful in the future and take database backups yourself at a much higher frequency
Ayush
Ayush•13mo ago
@Teph Gab what does your backup strategy look like? How are you performing backups
Teph Gab
Teph Gab•13mo ago
i use mysql workbench to perform backup. i always perform backups at midnight or later
Adam
Adam•13mo ago
Hopping in here to say that Railway does not restore database backups unless they are at fault. It seems as though they are not at fault in this case. You pushed code that wiped your db. Your latest backup will be your best option
Teph Gab
Teph Gab•13mo ago
i'm sure i did not wipe it here is the code i use when i want to wipe my database on railway NIXPACKS_BUILD_CMD=php artisan optimize && php artisan config:cache && php artisan view:cache && php artisan migrate:fresh --seed --force i i'm sur i had removed the :fresh --seed part as i always do. and i have double checked
Brody
Brody•13mo ago
well yeah there's your cause of the dropped tables
Ayush
Ayush•13mo ago
lol
Brody
Brody•13mo ago
I'm going to reiterate on what Adam said, railway does not restore databases if they aren't at fault, this or a similar command was the reason for the missing tables, railway was not at fault here
Teph Gab
Teph Gab•13mo ago
migrate:fresh => clean tables, migrate => just migrate new table
Brody
Brody•13mo ago
I'm going to mark this as solved now, I'm sorry this has happened to you but this is out of railways hands, please be more diligent in the future
Teph Gab
Teph Gab•13mo ago
i'm using the plaform since 3 or four month now
Brody
Brody•13mo ago
!resolve
Duchess
Duchess•13mo ago
@Brody has marked this thread as resolved.
Brody
Brody•13mo ago
and a thank you to ayush for asking the question that lead us to this discovery
Want results from more Discord servers?
Add your server