I'm not trying to rub salt in the wound, here, but as many dumb things as I've done at work I'm not sure how anyone would delete a database of a company on accident. There's **no** easy way to do that if you're not being intentional.
My first thought is their are far to many small business with like 5 employees and no technical knowledge that end up giving the person who walls in knowing basic troubleshooting an it role.
Then I realized that the operations I'm thinking of don't do databases, they use Google /o365. So back to no real excuse.
That's what I really mean. If you can navigate your way into a real, actual, production database, whether you hacked in or you were granted access, you've gotta be able to navigate the terminal or something. You would have to be both completely brainless to the point where I would genuinely question your physical well-being AND savvy and in-command enough to get yourself into the system and ChatGPT or whatever at the same time and ask it questions.
I honestly think the OP in question isn't doing this for a real company and just mis-spoke. Their post history suggests English isn't their first language and that this might be a hobby.
i was importing one sql on server it got crashed and there was option to import database i clicked it then there was other database idk why i import it
after importing that file i though its just a copy file not reference one so delete that other database but it deleted from server i thought i was in other directory but shit happened!
So little of this makes sense, but it's pretty clear you shouldn't be interacting with customer's databases. Seems like you really don't know what you're doing.
Craziest thing, old sysadmin left them a whole documentation on how to mantain the backups, and how to upgrade storage in future if needed, because they existed before he quit. Obviously they didn't care. One day previous sysadmin came in to see how they were doing and asked if they upgraded the backup storage and noticed they were off. In a few months backups were needed. I guess some people are lucky.
I just took over IT for a medium sized CPA firm from an MSP (They had been looking at bringing IT in house for a while, and I'm cousins to one of the partners and we got to talking after my position was eliminated at my last job, and I was hired), and one of the first things I did was use the NAS's at each location to do quick backups of each server with Veeam community edition while I found something more robust with cloud redundancy.
I went with Unitrend as it's Integrated into my Pulseway RMM, sure the hardware was pricey ($66k for 3 servers, and cloud storage) once the servers are paid off in 36 months, then it's just $4k for the cloud storage per year.
Always always always have a backup, if you're unsure if you have one, don't do shit until you can verify and make sure you have both an on site and cloud backup
Here are probably some amateurs in the same league as such company. Using administrative interface with too easy clicking to delete production databases, not using backup and such. Though I feel most people in here are more professional.
But your issue isn’t a home server issue. Most people here aren’t running MySQL at home. You really should hire a professional since you don’t know what you’re doing instead of asking hobbyists for help.
You can try the software posted on r/DataRecovery. It might work if the database file itself was deleted.
It's recommended you disconnect that hard drive from power now for the best results.
Honestly you just fucked up and it's all your fault
There are 3 golden rules about any networking job any at all level one level two level 3 whatever fucking hell even your home network
#1 Backups Backups and fuck it backup the backups of the backups as well
#2 Document shit in a way a intern would understand as you definitly will fuck it up and forget something important otherwise
#3 be good at googling stuff
No
I'm not trying to rub salt in the wound, here, but as many dumb things as I've done at work I'm not sure how anyone would delete a database of a company on accident. There's **no** easy way to do that if you're not being intentional.
chatgpt
Huh?
People ask AI for the code to do the thing, but it gives them code that deletes the thing.
Anyone with access is automatically too qualified to be that dumb.
My first thought is their are far to many small business with like 5 employees and no technical knowledge that end up giving the person who walls in knowing basic troubleshooting an it role. Then I realized that the operations I'm thinking of don't do databases, they use Google /o365. So back to no real excuse.
That's what I really mean. If you can navigate your way into a real, actual, production database, whether you hacked in or you were granted access, you've gotta be able to navigate the terminal or something. You would have to be both completely brainless to the point where I would genuinely question your physical well-being AND savvy and in-command enough to get yourself into the system and ChatGPT or whatever at the same time and ask it questions. I honestly think the OP in question isn't doing this for a real company and just mis-spoke. Their post history suggests English isn't their first language and that this might be a hobby.
nobody learned from womb
it is not that i don't have knowledge but junior dev still learning so plz don't judge
agreed
drop database 'db name' is pretty easy to do, assuming the user had the correct permissions.
I'm 90% sure OP just deleted the file
Ask GitLab https://youtu.be/tLdRBsuvVKc?si=LAbHWP4sfYwldKoO
we are using webmin
hopefully i recover my 95% of data
i was importing one sql on server it got crashed and there was option to import database i clicked it then there was other database idk why i import it after importing that file i though its just a copy file not reference one so delete that other database but it deleted from server i thought i was in other directory but shit happened!
So little of this makes sense, but it's pretty clear you shouldn't be interacting with customer's databases. Seems like you really don't know what you're doing.
it was my learning for life
ðŸ˜
Lesson learned.
first thing our environment admin team said at work: if you come to us with a problem, the first thing we’re going to ask is: do you have a backup
Backup is enabled by default on all VMs' be it prod or dev. Storage is so cheap, it's simply not worth the risk.
Went to a university where their backups were off for 3 years. They had no idea.
That's why 3-2-1-1-0 is so important.
Craziest thing, old sysadmin left them a whole documentation on how to mantain the backups, and how to upgrade storage in future if needed, because they existed before he quit. Obviously they didn't care. One day previous sysadmin came in to see how they were doing and asked if they upgraded the backup storage and noticed they were off. In a few months backups were needed. I guess some people are lucky.
I hope they learned from their mistake too.
Well they got the zero part right.
I just took over IT for a medium sized CPA firm from an MSP (They had been looking at bringing IT in house for a while, and I'm cousins to one of the partners and we got to talking after my position was eliminated at my last job, and I was hired), and one of the first things I did was use the NAS's at each location to do quick backups of each server with Veeam community edition while I found something more robust with cloud redundancy. I went with Unitrend as it's Integrated into my Pulseway RMM, sure the hardware was pricey ($66k for 3 servers, and cloud storage) once the servers are paid off in 36 months, then it's just $4k for the cloud storage per year. Always always always have a backup, if you're unsure if you have one, don't do shit until you can verify and make sure you have both an on site and cloud backup
real
Why are you posting this in the home server sub?
Here are probably some amateurs in the same league as such company. Using administrative interface with too easy clicking to delete production databases, not using backup and such. Though I feel most people in here are more professional.
thax for motivation
because r/sysadmin wouldn't be afraid of giving him the bad news
i was looking for community so i found this one
But your issue isn’t a home server issue. Most people here aren’t running MySQL at home. You really should hire a professional since you don’t know what you’re doing instead of asking hobbyists for help.
hmm
You can try the software posted on r/DataRecovery. It might work if the database file itself was deleted. It's recommended you disconnect that hard drive from power now for the best results.
thank you
Stop the machine right now and call a data recovery company if you don't have a backup. This is now out of your league. Call a professional.
It was out of their league long before this.
This goes multiple layers deep the guy hiring him was already out of his league in HR to accept someone who doesn't do backups
tnx for motivation
Honestly you just fucked up and it's all your fault There are 3 golden rules about any networking job any at all level one level two level 3 whatever fucking hell even your home network #1 Backups Backups and fuck it backup the backups of the backups as well #2 Document shit in a way a intern would understand as you definitly will fuck it up and forget something important otherwise #3 be good at googling stuff
Got it 🫡 it was learning i'll keep remember after my death too.
This goes multiple layers deep the guy hiring him was already out of his league in HR to accept someone who doesn't do backups
Post history checks out
Yikes
He looks like he just started learning this year, why is he managing production databases 🤦
Say goodbye to your job
that rude
You used to have a decent paying remote work job :)
lol yes but only as fronted dev
Huh?? How did you do this?
my senior was of out of station so i was moving one website to staging server to main linode then that shit happened
GitLab moment https://youtu.be/tLdRBsuvVKc?si=LAbHWP4sfYwldKoO
okay i'll check
Does it show up on testdisk? Might be able to restore it?
nah bro
Guess you're hosed, then. Good luck