i been running links SQL since 2001 and it's been working fine and still is except i'm getting this error

Error

MySQL said: Can't open file: 'ClickTrack.MYD'. (errno: 145).

Query: SELECT COUNT(*) FROM ClickTrack

i'm unable to backup the database because of this error

how can i fix it

Hi,

Sounds like your database is corrupt :(

A couple of suggestions;

1) Run this from MYSQLMonitor;

REPAIR TABLE ClickTrack;

2) Search for *.MYI and *.MYD on Google, or just click here :)

http://www.google.com/...e=utf-8&oe=utf-8

3) Try running myisamchk on your database files (your host may need to do this for you).

Hope that helps

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates