Gossamer Forum
Home : Products : Gossamer Links : Discussions :

mysql error

Quote Reply
mysql error
 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
Quote Reply
Re: [theguy] mysql error In reply to
perror 145:
MySQL error: 145 = Table was marked as crashed and should be repaired

So repair table

Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================
Quote Reply
Re: [HyperTherm] mysql error In reply to
how can i repair it?
Quote Reply
Re: [theguy] mysql error In reply to
Hi,

Was there really a need for the double post Wink (in here, and "Database and MySQL").

As stated before... you probably need to run;

Code:
REPAIR TABLE ClickTrack;

..from MySQLMan / MySQLMonitor.

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!