Link to home
Start Free TrialLog in
Avatar of brandon_walsh
brandon_walsh

asked on

My MYSQL database tables gone

I have a hosting account with blueHost.  I just opened one of my sites and got a pdoexeception error.  unknown db.  As it has been awhile since i worked on these sites, thought i had forgotten to setup the db for this particular one.  when i checked the server, several of my databases had missing tables.  Currently, the only similar thing i see is that my sites are
drupal 7 sites
of course mysql database
created micro sites of main site
The primary site is is body and I have several sites using that sites' source code, each has it's own db and these dbs are the one that are missing the tables.
one other thing, other databases, empty, have been create/appeared that are called body@002arm, body@002leg and so on.  So, for each db that has missing tables, another db has been created, with the different naming convention and is empty also.

spoke with tech at blueHost - he doesn't know why, how it happened.  Logs apparently only go back a week or two.

Trying to determine if I did something.  I know for certain that I did not go into several databases and drop tables. and also I did not go in and create several oddly named dbs and left them empty.

Does anyone have any insight on what could have happened.?
ASKER CERTIFIED SOLUTION
Avatar of Daniel Wilson
Daniel Wilson
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of brandon_walsh
brandon_walsh

ASKER

I have my drupal updates, but i wonder is there is something more.  Passwords for phpadmin and ssh are different and difficult, but you have my wondering now, but what is still odd is that this only happened with the multi-sites that i have installed.