Anyone know why a db would disappear?


#1

I had a mysql instance containing 3 databases, and today, one is gone.

Nothing on my account appears to be out of the ordinary, and I see nothing suspicious.

Anyone have any idea how this could happen?

More importantly, anyone know if this can be recovered by Dreamhost?

Thanks!


#2

Open up a support ticket, and we may be able to restore it.

Does anyone else have access to your account info?


#3

I’m also having the same problem. When I login into PMA the database is still listed but there are no tables in it.

I tried to restore the backup database from 5 days previous but it appears there were no tables in that database either.

I’m the only person with access to my account.

I have sent a support ticket.

Thanks for your help.


#4

Generally speaking, DB’s don’t magically delete themselves unless there’s been a catastrophic loss of data (which we’d notice), or the app that uses that database self-deletes. What app was using that DB?


#5

Stop looking, I think I’ve found the problem - the site was probably hacked. It was a db for a PhPBB. When I go back through the last couple of backups I see that the db was growing in size much faster than the number of posts.

I was receiving the error-

SQL ERROR [ mysqli ]

Table ‘mydatabase.phpbb_config’ doesn’t exist [1146]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

I’ve done some reading and my guess it was probably hacked with SQL injection.

Thanks for your help