InMotion Hosting Support Center

Tables completely missing from WP site

Category: Wordpress

2016-01-19 6:50 pm EST

Hits: 1,329
Between yesterday and today several tables in my WP site went AWOL. Neither me or my tech guy had gone into my site and of course we could not open it. He went into the PhpAdmin and confirmed that the tables were actually gone and restored from a backup from yesterday. He suggested this was a hosting problem. Any thoughts? Under what circumstances could this happen? Following were the tables that were missing.
wp_users: Table doesn't exist
wp_usermeta: Table doesn't exist
wp_posts: Table doesn't exist
wp_comments: Table doesn't exist
wp_links: Table doesn't exist
wp_options: Table doesn't exist
wp_postmeta: Table doesn't exist
wp_terms: Table doesn't exist
wp_term_taxonomy: Table doesn't exist
wp_term_relationships: Table doesn't exist
wp_commentmeta: Table doesn't exist

You must login before you can ask a follow up question.

You must login before you can submit an answer.



11,130 Points
2016-01-19 7:06 pm EST
Hello LilyJ,

I checked your database for the domain you mentioned and I see the tables there. I would like to get more information from you but be mindful this question is on our public-facing site. However, any more data you can provide will help us investigate further.

Christopher M.

You must login before you can post a comment about this answer.

Hi Christopher--yes, my tech guy did a restore to yesterday's backup, so all the tables are there now. I believe he did save a copy of the website in its "missing table" condition and I could have him send that to you if you give me an address to send it to. I don't know what other information you would want--I modified the list of tables above and took out the reference on each item to my web address. What information do you want that might have private information? The website is in development mode. It is not yet available to the public.
11 Points
2016-01-19 9:25 pm EST

11,130 Points
2016-01-19 10:09 pm EST
Thank you for your reply. Yes, it is helpful to know this. However, if the data was was lost entirely we would not be able to recover it unless it was in one of automatic recovery backups. These run every 24-36 hours and are overwritten. If you would like us to check you can request a data restoration request through your Account Management Panel.

You must login before you can post a comment about this answer.

Hi Christopher--we have already recovered from a back-up so no need for a data restoration request. We have a copy of the wp file in its corrupted state. We could send this to you to look at if you tell me where to send it. The main question would be--how did this happen in the first place and how to prevent it from happening again. But if you can't determine that by looking at the corrupted version, then there is no point in sending it to you. Thanks for getting back to me.
11 Points
2016-01-20 2:00 pm EST
Like this Question?

Forum Login

You are NOT logged in. You can still browse our Support Center.

To participate within our Community Support Forum:

Need more Help?

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!