Galleries dead! Help!

[chimera15]

I woke up today, and tried to access my galleries, I have two of them.  Big galleries with years of work in them, and I get this,"There was an error while processing a database query  " 
I checked the database's and they look intact and fine.  No other database's on my site have become corrupted. I run a store and a forum also.  Any clues? Nothing was changed, or anything, it just seems to have died for no reason.

Thanks

[chimera15]

Ok, I read some previous posts and I enabled debug mode and get this:

While executing query "SELECT * FROM cpg135_cms WHERE conid='0' AND type='0' ORDER BY cpos" on 0

mySQL error: Table './chimera/cpg135_cms' is marked as crashed and should be repaired


am I dead?

[chimera15]

Ok, I read that I have to do a repair table in mysql..I read some of the articles, but can't make much sense of it. I don't see any repair button in the database, it's a mysql command?  Anyone feel like walking me through this?

[Nibbler]

Go into phpmyadmin, navigate to the Coppermine database, click on the SQL tab and enter

Code Select Expand

REPAIR TABLE cpg135_cms

[chimera15]

It worked it work! Thank you so much! I thought I was totally in trouble.

Phew!

Time to backup everything.<lol>

[chimera15]

uh oh, maybe it didn't?  There might be a problem with the two databases..?
I try to log into the other database and I get the first one!?

[chimera15]

oop, nope, they're both ok, just had to repair that one <beam>

Thanks again.