Datbase error

[colinmann]

When i go to my photos site @ www.colinmann.com/photos, i get this...

"While executing query "SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category >= 10000" on 0

mySQL error: Can't open file: 'cpg11d_pictures.MYI'. (errno: 145)"

Things were working fine earlier today. Please don't tell me it means I've got to rebuild what I've done. I've tried to repair the database... but it says:

"error    : Can't open file: 'cpg11d_pictures.MYI'. (errno: 138)"

Have you please got any other ideas?

[Joachim Müller]

http://forum.coppermine-gallery.net/index.php?topic=10409.0

[kegobeer]

If you still can't access/repair the table, you might be out of luck.  Do you have a recent MySQL database backup handy?

[colinmann]

i was unable to restore the database, so i restored it from december :-(. Still an amazing application.

[kegobeer]

Here's more MySQL repair information:

http://dev.mysql.com/doc/mysql/en/repair.html