Incorrect key file for table

[Ilano 0]

Olá pessoal,

 

Estou com problemas ao ser executada a consulta abaixo:

 

SELECT c.*,

g.name AS groupname, cc.title AS name, u.name AS editor, f.content_id AS frontpage,

s.title AS section_name, v.name AS author

FROM jos_content AS c

LEFT JOIN jos_categories AS cc ON cc.id = c.catid

LEFT JOIN jos_sections AS s ON s.id = c.sectionid

LEFT JOIN jos_groups AS g ON g.id = c.access

LEFT JOIN jos_users AS u ON u.id = c.checked_out

LEFT JOIN jos_users AS v ON v.id = c.created_by

LEFT JOIN jos_content_frontpage AS f ON f.content_id = c.id

WHERE c.state != -2

ORDER BY section_name , section_name, cc.title,

c.ordering LIMIT 0, 20;

 

O erro retornado é:

 

Error: "Incorrect key file for table '/tmp/#sql_1684_0.MYI'; try to repair it"

 

Utilizo o SQL Manager for MySQL e já mandei reparar e checar as tabelas, mas continua com o mesmo erro. Como posso resolver este problema?

 

Grato,

 

Ilano.

[Andrey Knupp Vital 136]

É o seguinte, pare o serviço do MySQL, vá até a pasta bin, 'procure pelo' myisamchk, e digite 'myisamchk [PATH\PARA\ARQUIVO.MYI]'

C:\Users\Andrey Knupp Vital>chdir \

C:\>cd C:\dev\mysql\bin

C:\dev\mysql\bin>myisamchk C:\dev\mysql\data\db\alunos.frm
myisamchk: error: 'C:\dev\mysql\data\db\alunos.frm' is not a MyISAM-table

C:\dev\mysql\bin>

 

No caso, não deu certo .. pois não tenho nenhuma tabela corrompida .. !