Record Disappeared from Mysql Table, How Can I Find Out What Happened?
Posted
by Jascha
on Stack Overflow
See other posts from Stack Overflow
or by Jascha
Published on 2010-03-24T01:00:35Z
Indexed on
2010/03/24
1:03 UTC
Read the original article
Hit count: 323
I got the fire alarm phone call, AIM messages and email today from a client stating "The site is down!, WTF happened?!"
Well, after a little digging, it turns out one of the records in a table had been wiped clean, but without removing the row itself. So, I had the representation of data, but a bunch of empty fields. (needless to day I need to write into my code a catch for this.)
What my real question is, where can I figure out what happened? I've got access to phpmyadmin and that's about it. I found some access logs on in the root directory of my server, but that just tells me the client was in the admin area I built editing that record, I'd like to know specifically what they did that made all of the data go away. (what query was run etc...)
is it possible without real server admin access? is there a neat little php to mysql class that returns data like this?
Thanks in advance. -Jascha
© Stack Overflow or respective owner