Print

[jagmike8]

While executing query "SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND category >= 10000" on 0

mySQL error: Can't open file: 'cpg132_pictures.MYD'. (errno: 145)

i tried searching on here and came up with something about repairing the file cpg132 because something is broken, but when i go to my phpmyadmin database tool, and try to click on the file cpg132_pictures it says: 
 Can't open file: 'cpg132_pictures.MYD'. (errno: 145)

Error

SQL-query :

SHOW KEYS FROM `cpg132_pictures`

MySQL said:
#1016 - Can't open file: 'cpg132_pictures.MYD'. (errno: 145)

[Documentation] · [Back]

any suggestions?

[Nibbler]

Run the repair query in the sql tab without attempting to view the table first

Code: [Select]

REPAIR TABLE `cpg132_pictures`

[jagmike8]

sweet. it worked.  thanks for your help.