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.?
MySQL Server

Avatar of undefined
Last Comment
brandon_walsh

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Daniel Wilson

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Aaron Feledy

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
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.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy