Urgent! all my_sql data are gone! please help!
i just made a push then all mysql data are now empty!
86 Replies
Project ID:
N/A
where do you see the missing data?
all my table are empty
what software are you using to view the database data?
the railway platform are mysql workbench somtimes
please help those data are important
check with mysql workbench, do not use the railway dashboard to view your data
also empty now when i use mysl workbench
all table a cleared
try restarting the database
what about the datas i just loosed?
try restarting the database please
let me try
how todo that?
from the settings tab in the plugin
otion is not clickable
this option is not clickable
show me?
okay
i cant't loose thos data please help
are you there?
@thomas something doesn't seem right here
??
I don't work for railway, Thomas does, he's a support engineer
I need more details, project ID please
@thomas
okay a moment
Yeah don't do that, you will be banned, Brody can you can't
Can you link the rules Brody
6631d42b-d095-4ee8-ae80-f7815322a9c0
please no pings #🛂|readme #5
i did not know
we understand this is a stressful situation, but please be patient while this gets sorted out
Okay thank you. so what do i do know
please be patient while this gets sorted out+ be available if thomas needs any more information from you
Okay i will be waiting
are you sure you can't click restart database?
it's kinda greyed out by default
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?
can or can't?
can't
Possibly, it depends what happened to it
it won't hurt
can I restart it for you?
please
or can you do a rollback from your side or something like that?
restarting
and not tonight I can't
did you drop the table or something?
no!
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
everything was working fine a just made a push then all my datas was cleared
all tables?
I see tables
all important tables
please check again
still empty
use mysql workbench for this check please
jusct checked
with mysql workbench?
i just used it
still empty
this is the first time i have such a big issue on the platform
are you still there?
yes, but not for much longer
this is past the end of my day
so what do i do?
can someone else help me?
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
i make a push every 2 o 3 days
this never happen
Good night, please be polite. I understand that. Please document as much as possible for me tomorrow
Thread has been flagged to Railway team by @thomas.
@Teph Gab how are you interfacing with mysql from your main app?
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
No i mean how does your apps talk to your mysql db? via an ORM or executing raw sql (persay)?
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?
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
Noted. thank you
well this is a realy stressfull situation
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?
no.
I'm not really sure how much they can do for you here unfortunately
oh God i hope they can find a way
I would not hope if i where you, just trying to be realistic here
Do railway are still doing upgrade or something like that that would provoke that kind of issue?
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
@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
the root cause can extend beyond their commit, something they did in the dashboard, or something they did in mysql workbench
push commit you said?
share your latest commit that 'broke' the DB and we can have a look code wise
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
@Teph Gab what does your backup strategy look like? How are you performing backups
i use mysql workbench to perform backup. i always perform backups at midnight or later
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
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
well yeah there's your cause of the dropped tables
lol
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
migrate:fresh => clean tables, migrate => just migrate new table
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
i'm using the plaform since 3 or four month now
!resolve
@Brody has marked this thread as resolved.
and a thank you to ayush for asking the question that lead us to this discovery