How to check your tables

Choose the database you are working with by clicking on it in the left menu

On the right side of the page, you will see a listing of your tables. Click “Check All” and then from the drop down choose “Check Table“

The page will refresh and give you a summary of table that may be corrupted. As you can see from the screenshot below, all the tables are OK. If you receive any errors, you can continue reading to find how to repair your tables.

Apparently I have no database connection. Only some of my tables are showing up. They’re all okay. But I need to check and repair the others so I can get my site back up. Here’s the error message I got. Please help! Thanks.

Sorry to hear those tables are reported missing. It’s possible the tables are there but there is an issue with your SQL service. If you have a VPS or Dedicated server I advise restarting the SQL services. Or, if you’re unsure of that you can contact our Live Support and request a restart.

It will never hurt to check and repair your database. If you are still getting errors, you can always contact the Live Support team so they can take a look at what is causing that many connections to your database.

Alex, I feel your pain. I’ve been a customer for 5 years and things have really gone south lately. Our site has gone down several times in the last few weeks alone. There is a service interruption every week. Yesterday, another outage, this time with DB corruption. Utterly unacceptable reliability issues. The problem is systemic. I’ve spoken with everyone from Level 1 support, L2, Billing, all the way up to Customer Service managers over the past year. Nothing has been done to fix the underlying reliability issues. No sense of urgency to help their customers. For example, yesterday’s DB corruption issue was promised to have been fixed yesterday after business hours. Now its end of day 24 hours later, still no resolution and no communication.

Clearly, InMotion is no longer concerned about customer satisfaction. We’ve given them more than enough 2nd chances. Second chances for the numerous billing errors. Second chances for the embarrassing number of reliability issues, outages, DB issues, and the list goes on. At this point, they’re just taking advantage of their customers.

i did what they said, first i check all table and all said OK also i run for repair but it was still nothing happen!! now my site working because they help me but i still did’t know how to fix database if this happe again??

I’m sorry to hear that you’ve been having problems with your WordPress site. Unfortunately, your comment has no specific information on your account. The Support Center is here to help if you require it. Please provide us some information on your hosting account, and a description of the issue and we would happy to investigate, if you wish.

I have the error “Error establishing a database connection.” I was sent here from support.inmotionhosting.com during a broad problem where apparently many people were experiencing this due to a server error.

The messages on the site imply that I should be able to get my site back up on my own by following these instructions.

I now anticipate that I am about to call InMotionHosting back, wait on hold for a while (tying up your resources and wait times), and I expect to be told that this will be fixed at your end as soon as possible. But I am not sure, so I have to call.

I have checked my tables using the steps above. There are no errors shown. This article does not say what to do if the error persists, but there are no bad tables.

Thank you for putting up the information that you HAVE put up, but this article is not quite on the mark for what is needed today, I think.

First, we thank you for your patience and understanding during the issue, you are quite the gentleman here. The fix was indeed meant for the vast majority, however there are some databases that may need individual attention. You may want to contact the Live Support team so they can take a more in-depth look at your database since you have already tried the recommended fix.

Well, there is a bit of CRITICAL information missing in your reply. It’s not simply “-pPasswordHere” it MUST be –password=’PasswordHere’ The password MUST be in single quotes, not in brackets or double-quotes. So, for anyone else like me out there here it is:

Sorry for the lack in clarification, while typing in -pPasswordHere, you literally have a -p then no space, then your password. You can also just leave the password option off altogether and it will prompt you for one, but that wouldn’t be ideal for a cronjob. I’m guessing you might have a character such as a ! in your password possibly causing the shell to interpret it as another command, so that’s why only using quotes works in your case.

The long hand form that you’ve mentioned also works, so thanks for pointing that out as well. Here is the part when you do a man mysqlcheck on the server about the command itself and how it functions:

The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the option and the password. If you omit
the password value following the --password or -p option on the command line, mysqlcheck prompts for one.

InMotion Hosting is a leading web hosting company serving customers around the world. We provide reliable, high-performance hosting environments that are affordable and easy to use, but the hallmark of InMotion is excellence in customer service. Our aim is to delight every customer with friendly service that is readily available, expert and effective.
InMotion is a trusted partner for businesses both large and small, with over 10 years in the hosting business and over 100,000 satisfied customers hosting their websites on our servers. We care about our community and the environment, with green data centers and ongoing sustainability programs.

LIMITED TIME ONLY! Get all the amazing speed and performance of our WordPress Hosting Platform, including free SSL and much more. That means you get 2 websites, 80GB of storage, unlimited email accounts and a FREE JetPack Personal License, all for $6.99! https://zcu.io/eCNw