Problem with mysql database - '.frm' corrupted

[Guest]

Hi there,

 

after a mysql shutdown and restart, my customer listing (address_book.frm) seems to be corrupted.

 

System is a debian stable with backports:

 

PHP 4.3.9

MySQL 4.1.7

 

Error message:

 

1033 - Incorrect information in file: './schnuffelnase/address_book.frm'

 

select count(*) as total from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id

 

[TEP STOP]

 

After calling customer list in the admin section.

 

Is this a known issue of a mysql 4.x incompatibility?

 

Is there a known solution? I hope there's no loss to the customers' list, that would be fatal :-(

 

Kind regards,

Peter

[Guest]

use phpmyadmin, select the table, use tools, select repair and repair the table and you should be good to go

[Guest]

Hi Mibble,

 

use phpmyadmin, select the table, use tools, select repair and repair the table and you should be good to go

<{POST_SNAPBACK}>

 

phpmyadmin won't let me use the table. It's marked as 'in use' and the result of the attempt to use it is:

 

Incorrect information in file: './xyz/address_book.frm'

 

So that won't work, neither do manual attempts to repair that little <censored> in any other way I know: via mysql-client 'repair table', mysqlcheck, myisam etc....

 

I'm at the end of my knowledge and frustrated as hell as the shop software doesn't allow new customers to register at the moment. My last backup is less then one week old, but that's not really an option because of many new customers.

 

I _love_ mysql *sigh*

 

Kind regards,

Peter