Re: strange error after restoring database from backups

My solution for this...

connect to mysql and do:
drop table CACHEDATA

then from command line create a file .sql with just the information on how 
to build the cachedata table and :

mysql -u USER -p DATABASE < cachedata.sql

I hope that helps somebody out there


>
>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.
>
>
>I fixed it by deleting the cookies from Mozilla 1.3 related to my own site. 
>Should that error be, say, coming from phpslash.org (or even slashdot.org), 
>I would never thought that my own cookies had something to do with it.
>
>Something should be done to jpcache so that it can recover from this type 
>of errors by itself. And yes, I tried making $cachetimeout=-1 before 
>deleting the cookies.
>
>This is the first time I see this error, I just hope no other user who 
>regularly visits my website ever sees this.
>
>Any input on this subject?


----)(-----
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