0

The tables in the database i use for my website was dropped in some way. I didn't do it, but i don't know who did it. My hosting company says we didn't do either. So is there a way to know who did it? If there is a solution for it, i'll be grateful. My website is offline now.

Thanks

mehmetserif
  • 1,035
  • 5
  • 23
  • 43
  • Of course you have backups correct? No, there is no way of finding out who done this unless you have full logging enabled, which is unlikely. Even then, I am not sure it will give you that information. – ChrisBint Apr 04 '14 at 10:32
  • If you were using it using An Application in which your code was exposed, then it is very easy for anyone to go there and drop the tables. Sorry about this. – ErrorNotFoundException Apr 04 '14 at 10:33

1 Answers1

1

Provided you do not have a backup: as Stanley has pointed out, your code might have been vulnerable. This is just one out of many possible solutions.

Small checklist:

  • Check whether the DB is accessible from outside localhost (usually it should not)
  • Check password security
  • Check who has access to your DB and whether you can trust them
  • Check your code for SQL injection vulnerability: What is SQL injection?
Community
  • 1
  • 1
nilsole
  • 1,423
  • 2
  • 9
  • 23