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

Filed under:
|
|

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

Related posts about mysql

Related posts about cms