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

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!