I am getting the error code message when I login to the database and use the "show tables" command. Could anyone tell me how to solve this problem? Below is a list of commands I performed and their corresponding outputs. You can see that
the "show tables" command fails.
QUOTE
Type 'help;' or 'h' for help. Type 'c' to clear the buffer
mysql> show databases;
+----------+
| Database |
+----------+
| dbcbo |
| dbciv |
| mysql |
+----------+
3 rows in set (0.01 sec)
mysql> use dbcbo;
Database changed
mysql> show tables;
ERROR 12: Can't read dir of './dbcbo/' (Errcode: 13)
mysql>
mysql> show databases;
+----------+
| Database |
+----------+
| dbcbo |
| dbciv |
| mysql |
+----------+
3 rows in set (0.01 sec)
mysql> use dbcbo;
Database changed
mysql> show tables;
ERROR 12: Can't read dir of './dbcbo/' (Errcode: 13)
mysql>
If I restart the mysqld server, I have no problems. The database is there and the data is not corrupted either. But after a while(usually less than several hours), the same thing happens again. I need a long term solution to this problem.
Thanks.