How to repair `information_schema`.`TABLES`?

mysql information-schema repair
Teneff picture Teneff · Jun 29, 2012 · Viewed 6.9k times · Source

I'm trying to list the contents of information_schema.TABLES like this:

SELECT * FROM information_schema.`TABLES` LIMIT 10

but it gives me an error:

ERROR 2013 (HY000): Lost connection to MySQL server during query

Then I tought that REPAIR TABLE TABLES should fix it, but it gave me:

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    396
Current database: information_schema

ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'information_schema'

Anyone had that problem before or have an idea what could I do to fix this ?

Answer

Sajan Parikh picture Sajan Parikh · Jul 1, 2012

Take a look at your my.conf file and see if raising the following values fixes this issue for you.

interactive_timeout
wait_timeout

Related questions

How to find all the tables in MySQL with specific column names in them?

I have 2-3 different column names that I want to look up in the entire DB and list out all tables which have those columns. Any easy script?

Read More
MySQL disable all triggers

For test correctness of query I need disable all triggers in db. I see that in information_schema exists table TRIGGERS. Is possible temporarily disable all triggers using this table? E.g. like: update TRIGGERS set TRIGGERS_SCHEMA='myschema_new' …

Read More
Generate CREATE statements for all MySql Tables

I want All CREATE statements of MySql Tables in 1 query result. For example, INFORMATION_SCHEMA contains all table names,comments etc. but where are the CREATE statements are stored in MySql ? can it be retrieved in one query for all …

Read More