MySQL Forums
Forum List  »  Newbie

Re: Lost connection to MySQL server during query
Posted by: Christopher Popplewell
Date: November 13, 2017 04:52AM

Hi Peter! Thank you so much for responding. I have checked all of the tables in the MySQL db as well as my website db and all tables come back as 'OK'. Below is some of the output:

---------------------
Database changed
mysql> check table db;
+----------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+----------+-------+----------+----------+
| mysql.db | check | status | OK |
+----------+-------+----------+----------+
1 row in set (0.00 sec)

mysql> check table event;
+-------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------+-------+----------+----------+
| mysql.event | check | status | OK |
+-------------+-------+----------+----------+
1 row in set (0.00 sec)

mysql> check table func;
+------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+------------+-------+----------+----------+
| mysql.func | check | status | OK |
+------------+-------+----------+----------+
1 row in set (0.00 sec)

mysql> check table general_log;
+-------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------------+-------+----------+----------+
| mysql.general_log | check | status | OK |
+-------------------+-------+----------+----------+
1 row in set (0.00 sec)

mysql> check table help_category;
+---------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------------------+-------+----------+----------+
| mysql.help_category | check | status | OK |
+---------------------+-------+----------+----------+
1 row in set (0.00 sec)

mysql> check table help_keyword;
+--------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+--------------------+-------+----------+----------+
| mysql.help_keyword | check | status | OK |
+--------------------+-------+----------+----------+
1 row in set (0.00 sec)

mysql> check table help_relation;
+---------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------------------+-------+----------+----------+
| mysql.help_relation | check | status | OK |
+---------------------+-------+----------+----------+
1 row in set (0.00 sec)

mysql> check table help_topic;
+------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+------------------+-------+----------+----------+
| mysql.help_topic | check | status | OK |
+------------------+-------+----------+----------+
1 row in set (0.01 sec)
...
----------------------

Options: ReplyQuote


Subject
Written By
Posted
Re: Lost connection to MySQL server during query
November 13, 2017 04:52AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.