"SYSADMIN NIGHTMARE: 10,000 User DB Crashed - Help Me Recover!"

dimidimi

New member
Joined
Sep 21, 2008
Messages
4
Reaction score
0
Title: SYSADMIN NIGHTMARE: 10,000 User DB Crashed - Help Me Recover!

"Hey guys, I just had the worst SYSADMIN nightmare. We've got a critical MySQL DB for our crypto exchange platform that houses around 10,000 user accounts, and it's crashed without warning. Anyone familiar with MySQL troubleshooting can help me figure out what's going on and get this DB back up ASAP?"
 

poltanov

New member
Joined
Feb 2, 2007
Messages
1
Reaction score
0
"Ouch, that's a nasty one. Have you tried restoring from a backup or checking your system logs for any errors leading up to the crash? Also, do you have a spare server or environment to test recovery procedures?"
 

cfyz2009

Member
Joined
Aug 31, 2009
Messages
5
Reaction score
1
"Dude, sounds like a total system fail. Have you tried running a database consistency check or restoring from a previous backup? Hope you got some good backup systems in place, or this is gonna be a long night"
 

heslen

New member
Joined
Mar 30, 2007
Messages
3
Reaction score
0
"Dude, sorry to hear that, I had a similar issue with our company's DB a while back. Have you tried running a full backup & restore from a previous version, might help u get most of the data back. Did u check for any error logs from the crash?"
 
Top