You may could not get information from the table in MySQL database, need to check the table status by mysqlcheck.
# mysqlcheck mysql_linuxfaq
mysql_linuxfaq.id OK
mysql_linuxfaq.name OK
mysql_linuxfaq.address OK
mysql_linuxfaq.videos
Error : Incorrect information in file: './ mysql_linuxfaq.videos/videos.frm'
error : Corrupt
To repair a particular table, before doing that take a backup of table or Database
mysql> use mysql_database;
mysql> repair table videos;
+---------------------------------+--------+------------+
| Table | Op | Msg_type | Msg_text |
+---------------------------------+--------+------------+
| mysql_linuxfaq.videos | repair | status | OK |
+---------------------------------+--------+------------+
1 row in set (0.02 sec)
*Database name : mysql_linuxfaq
*table name : videos
Another option is use mysqlcheck command.
Comments (0)