Urgent! all my_sql data are gone! please help! | Railway | Page 1

thin gate Oct 17, 2023, 1:39 AM

#

i just made a push then all mysql data are now empty!

normal iglooBOT Oct 17, 2023, 1:39 AM

#

Project ID: N/A

rugged matrixBOT Oct 17, 2023, 1:39 AM

#

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution

surreal hound Oct 17, 2023, 1:40 AM

#

where do you see the missing data?

thin gate Oct 17, 2023, 1:41 AM

#

all my table are empty

surreal hound Oct 17, 2023, 1:41 AM

#

what software are you using to view the database data?

thin gate Oct 17, 2023, 1:42 AM

#

the railway platform are mysql workbench somtimes

#

please help those data are important

surreal hound Oct 17, 2023, 1:42 AM

#

check with mysql workbench, do not use the railway dashboard to view your data

thin gate Oct 17, 2023, 1:43 AM

#

also empty now when i use mysl workbench

#

all table a cleared

surreal hound Oct 17, 2023, 1:44 AM

#

try restarting the database

thin gate Oct 17, 2023, 1:44 AM

#

what about the datas i just loosed?

surreal hound Oct 17, 2023, 1:45 AM

#

try restarting the database please

thin gate Oct 17, 2023, 1:45 AM

#

let me try

#

how todo that?

surreal hound Oct 17, 2023, 1:45 AM

#

from the settings tab in the plugin

thin gate Oct 17, 2023, 1:46 AM

#

otion is not clickable

#

this option is not clickable

surreal hound Oct 17, 2023, 1:47 AM

#

show me?

thin gate Oct 17, 2023, 1:48 AM

#

okay

#

#

i cant't loose thos data please help

#

are you there?

surreal hound Oct 17, 2023, 1:52 AM

#

@wary comet something doesn't seem right here

thin gate Oct 17, 2023, 1:52 AM

#

??

surreal hound Oct 17, 2023, 1:53 AM

#

I don't work for railway, Thomas does, he's a support engineer

wary comet Oct 17, 2023, 1:53 AM

#

I need more details, project ID please

thin gate Oct 17, 2023, 1:53 AM

#

@wary comet

#

okay a moment

wary comet Oct 17, 2023, 1:54 AM

#

Yeah don't do that, you will be banned, Brody can you can't

#

Can you link the rules Brody

thin gate Oct 17, 2023, 1:54 AM

#

6631d42b-d095-4ee8-ae80-f7815322a9c0

surreal hound Oct 17, 2023, 1:54 AM

#

thin gate <@1084208484339421336>

please no pings #🛂｜readme #5

thin gate Oct 17, 2023, 1:55 AM

#

i did not know

surreal hound Oct 17, 2023, 1:55 AM

#

we understand this is a stressful situation, but please be patient while this gets sorted out

thin gate Oct 17, 2023, 1:56 AM

#

Okay thank you. so what do i do know

surreal hound Oct 17, 2023, 1:57 AM

#

surreal hound we understand this is a stressful situation, but please be patient while this ge...

please be patient while this gets sorted out

be available if thomas needs any more information from you

thin gate Oct 17, 2023, 1:57 AM

#

Okay i will be waiting

wary comet Oct 17, 2023, 1:57 AM

#

#

are you sure you can't click restart database?

#

it's kinda greyed out by default

thin gate Oct 17, 2023, 1:58 AM

#

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?

wary comet Oct 17, 2023, 2:00 AM

#

thin gate i just try again and i still can click

can or can't?

thin gate Oct 17, 2023, 2:00 AM

#

can't

wary comet Oct 17, 2023, 2:00 AM

#

thin gate do that will help getting the datas back?

Possibly, it depends what happened to it

#

it won't hurt

#

can I restart it for you?

thin gate Oct 17, 2023, 2:01 AM

#

please

#

or can you do a rollback from your side or something like that?

wary comet Oct 17, 2023, 2:01 AM

#

restarting

#

and not tonight I can't

#

did you drop the table or something?

thin gate Oct 17, 2023, 2:02 AM

#

no!

wary comet Oct 17, 2023, 2:03 AM

#

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

thin gate Oct 17, 2023, 2:04 AM

#

everything was working fine a just made a push then all my datas was cleared

wary comet Oct 17, 2023, 2:04 AM

#

all tables?

#

I see tables

thin gate Oct 17, 2023, 2:04 AM

#

all important tables

wary comet Oct 17, 2023, 2:05 AM

#

please check again

thin gate Oct 17, 2023, 2:05 AM

#

still empty

surreal hound Oct 17, 2023, 2:05 AM

#

use mysql workbench for this check please

thin gate Oct 17, 2023, 2:05 AM

#

jusct checked

wary comet Oct 17, 2023, 2:05 AM

#

with mysql workbench?

thin gate Oct 17, 2023, 2:05 AM

#

i just used it

#

still empty

#

this is the first time i have such a big issue on the platform

#

are you still there?

wary comet Oct 17, 2023, 2:08 AM

#

yes, but not for much longer

#

this is past the end of my day

thin gate Oct 17, 2023, 2:09 AM

#

so what do i do?

#

can someone else help me?

wary comet Oct 17, 2023, 2:10 AM

#

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

thin gate Oct 17, 2023, 2:10 AM

#

i make a push every 2 o 3 days

#

this never happen

wary comet Oct 17, 2023, 2:11 AM

#

Good night, please be polite. I understand that. Please document as much as possible for me tomorrow

quick pilotBOT Oct 17, 2023, 2:11 AM

#

Thread has been flagged to Railway team by @wary comet.

ripe musk Oct 17, 2023, 2:52 AM

#

@thin gate how are you interfacing with mysql from your main app?

thin gate Oct 17, 2023, 2:58 AM

#

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

ripe musk Oct 17, 2023, 3:01 AM

#

No i mean how does your apps talk to your mysql db? via an ORM or executing raw sql (persay)?

thin gate Oct 17, 2023, 3:03 AM

#

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?

surreal hound Oct 17, 2023, 3:07 AM

#

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

thin gate Oct 17, 2023, 3:08 AM

#

Noted. thank you

#

well this is a realy stressfull situation

surreal hound Oct 17, 2023, 3:09 AM

#

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?

thin gate Oct 17, 2023, 3:14 AM

#

no.

surreal hound Oct 17, 2023, 3:14 AM

#

I'm not really sure how much they can do for you here unfortunately

thin gate Oct 17, 2023, 3:15 AM

#

oh God i hope they can find a way

surreal hound Oct 17, 2023, 3:16 AM

#

I would not hope if i where you, just trying to be realistic here

thin gate Oct 17, 2023, 3:18 AM

#

Do railway are still doing upgrade or something like that that would provoke that kind of issue?

surreal hound Oct 17, 2023, 3:19 AM

#

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

ripe musk Oct 17, 2023, 3:20 AM

#

@thin gate 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

surreal hound Oct 17, 2023, 3:21 AM

#

the root cause can extend beyond their commit, something they did in the dashboard, or something they did in mysql workbench

thin gate Oct 17, 2023, 3:23 AM

#

push commit you said?

ripe musk Oct 17, 2023, 3:25 AM

#

share your latest commit that 'broke' the DB and we can have a look code wise

surreal hound Oct 17, 2023, 3:26 AM

#

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

ripe musk Oct 17, 2023, 3:26 AM

#

@thin gate what does your backup strategy look like? How are you performing backups

thin gate Oct 17, 2023, 3:27 AM

#

i use mysql workbench to perform backup. i always perform backups at midnight or later

cedar mulch Oct 17, 2023, 3:28 AM

#

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

thin gate Oct 17, 2023, 3:29 AM

#

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

surreal hound Oct 17, 2023, 3:31 AM

#

well yeah there's your cause of the dropped tables

ripe musk Oct 17, 2023, 3:32 AM

#

lol

surreal hound Oct 17, 2023, 3:34 AM

#

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

thin gate Oct 17, 2023, 3:34 AM

#

migrate:fresh => clean tables, migrate => just migrate new table

surreal hound Oct 17, 2023, 3:34 AM

#

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

thin gate Oct 17, 2023, 3:35 AM

#

i'm using the plaform since 3 or four month now

surreal hound Oct 17, 2023, 3:35 AM

#

!resolve

quick pilotBOT Oct 17, 2023, 3:35 AM

#

@surreal hound has marked this thread as resolved.

#Urgent! all my_sql data are gone! please help!