Re: Lost connection to MySQL server during query
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)
...
----------------------
Subject
Written By
Posted
November 12, 2017 08:21PM
November 12, 2017 08:39PM
November 12, 2017 10:46PM
Re: Lost connection to MySQL server during query
November 13, 2017 04:52AM
November 13, 2017 12:06PM
November 13, 2017 09:25PM
November 13, 2017 09:59PM
November 13, 2017 10:43PM
November 14, 2017 09:58AM
November 14, 2017 10:49AM
November 14, 2017 11:25AM
November 14, 2017 11:51AM
November 14, 2017 12:13PM
November 14, 2017 12:24PM
November 14, 2017 12:30PM
November 14, 2017 01:11PM
November 14, 2017 01:16PM
November 14, 2017 01:40PM
November 14, 2017 02:11PM
November 14, 2017 02:13PM
November 14, 2017 02:22PM
November 14, 2017 03:50PM
November 14, 2017 04:41PM
November 14, 2017 04:08PM
November 14, 2017 05:11PM
November 14, 2017 06:53PM
November 14, 2017 06:56PM
November 14, 2017 06:59PM
November 14, 2017 07:00PM
November 14, 2017 09:47PM
November 19, 2017 06:50AM
November 14, 2017 12:21PM
Sorry, you can't reply to this topic. It has been closed.
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.