mysql tables mysteriously emptied

tags:

views:

36

answers:

1

Q:

mysql tables mysteriously emptied

Hi,

I noticed that a couple of my mysql tables today were emptied. I can't think of any reason why this would occur. I store the DB in an AWS volume and we are well under the amount of space allocated to us. I was wondering if anyone had this issue before? Any suggestions of things that I can test? Sorry if I haven't provided enough information; its because I can't think of anything that would have caused this. Feel free to ask away.

A:

How about a delete statement? Bad code, bad security permissions, SQL injection etc

pjp 2009-11-01 09:46:22

Thanks for the comment. It could be poor code but there is nothing that I've written that could possibly delete a table. I can't imagine how someone would get access to our server. I've set the password and username and haven't told anyone. Finally, I don't think its SQL injection because we are using a PHP framework. I never insert things directly into the database but use Propel. I'm not sure if this is true, but Propel *should* prevent SQL injections

Russ 2009-11-01 10:03:41

ok this it totally harebrained, but is there any chance that it had ot do with daylight savings time? I'm sure it doesn't but the issue occurred between 1 and 2:30 AM today.

Russ 2009-11-01 10:17:41

ansaurus

tags:

views:

answers:

mysql tables mysteriously emptied

related questions