Database corruption...

[crashnet]

I visited my website today to do maintenance (it was fine this morning), but a few minutes ago when I visited it I got a critical database error from a query.  This is what my integrated IPB Board said

mySQL query error: SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc,
                 c.image, c.url, m.member_name as mod_name, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid
                 FROM ibf_forums f, ibf_categories c
                   LEFT JOIN ibf_moderators m ON (f.id=m.forum_id)
                 WHERE c.id=f.category
                 ORDER BY c.position, f.position

mySQL error: Got error 28 from table handler
mySQL error code:
Date: Thursday 21st of April 2005 07:29:09 PM

Cpanel has a check for the database, and errors were thrown on the cpg11d_pictures table...here are those:

papered_ivbd.cpg11d_pictures
warning  : Table is marked as crashed and last repair failed
warning  : Size of indexfile is: 91136      Should be: 63488
warning  : Size of datafile is: 67892       Should be: 62384
error    : Keypointers and record positions doesn't match
warning  : Found 532 deleted space.   Should be 0
warning  : Found 16 deleted blocks       Should be: 0
warning  : Found 538 parts                Should be: 304 parts
error    : Corrupt

Here is what mySQL said:

MySQL said: 

#1016 - Can't open file: 'cpg11d_pictures.MYI'. (errno: 144)

Any assitance would be greatly appreciated.  Thanks!

[krkeegan]

Well for sure if you have a recent Database backup that always helps.

Are you running a bridged version? Some of those first error codes are not familair to me.

You had errors in your pictures database. But from what you posted the database should be okay. Did your site display any pictures or it immediatly displayed this error?

Kevin

[crashnet]

Well for sure if you have a recent Database backup that always helps.

Are you running a bridged version? Some of those first error codes are not familair to me.

You had errors in your pictures database. But from what you posted the database should be okay. Did your site display any pictures or it immediatly displayed this error?

Kevin

When I go into phpmyadmin and click on the pictures table, that mySQL error above displays.  You can get to other portions of the gallery (config, search) but anything that involves displaying images gives me a critical error.  I have a integrated version with Invision Power Board 1.3.  I have the "last five uploads" mod at the top of my index page of my forum, so the forum does not display (the first set of errors up there are from the IPB).  Hope that helps you some.  I just want to see if I can fix it before using the backup.  Here is the coppermine error:

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

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

Is there anyway to just recover the cpg11d_pictures.MYI from a sql file without overwriting the entire database?  The problem was a full device on the server and they lost the backups in the process.

[Joachim Müller]

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

[crashnet]

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

Thanks GauGau.  When I originally made this thread I did not know that the picture table was corrupted, so I didn't search for anything on that.  I tried that query and it worked great.  All restored.  Thanks!