Re: Error 1146: Table 'mysql.1' doesn't exist

[jitin nandwani]

Hello All,

well , i faced a similar problem .

for a particular table , which is visible , when u fire " show tables" , but actually when u try to access the data in table , u get the error " table does not exist".

a simple solution to the problem is , remove the .frm file from the datadir , corresponding to the table , and restore the table from the last backup.


This is the only solution which worked for me .

bye....jitin
[phone]