Re: strange error after restoring database from backups

Since this error could happen easily, and the CACHEDATA is not that 
important, I was thinking we can have a "Repair CACHE table" button in the 
Admin page somewhere that basically drops the table and creates a new one 
(in one shot).

what do you think ?

of course, it would have to check if it has permissions for droping and 
creating tables first. And if not, then use a different user/password... (a 
la phpgroupware).


>On Mon, May 12, 2003 at 08:48:46PM -0400, Luis M wrote:
> >
> > This is the error I got presented with when doing a regular check on my 
>own
> > website after restoring the site from a nightly backup:
> >
> > Database error: Invalid SQL: delete from CACHEDATA where CACHEKEY LIKE
> > "%-slashSess-3f74954be3f20e903ae3a1eeb7f7419d%"
> > MySQL Error: 1016 (Can't open file: 'CACHEDATA.MYD'. (errno: 145))
> > Session halted.
> >
>
>This indicates a corrupt table I think.

----)(-----
Luis Mondesi
System Administrator
LatinoMixed.com

[email protected]

"...The Mac does this so smoothly, it feels like an extension of your mind." 
- Paula Speer, MacWorld Magazine 2003-04

Public signature: http://www.latinomixed.com/lems1/public-a.asc

_________________________________________________________________
MSN Messenger : discutez en direct avec vos amis ! 
http://www.msn.fr/msger/default.asp



-------------------------------------------------------
Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara
The only event dedicated to issues related to Linux enterprise solutions
www.enterpriselinuxforum.com