MYSQL Help!

Grant McLean Grantm at web.co.nz
Wed Mar 5 15:25:05 CST 2003


Sorry Don, forensic MySQL isn't my specialty.  You might want
to try the WellyLUG mailing list.

===============================================================
Grant McLean        BearingPoint Inc - formerly The Web Limited
+64 4 495 9026                     135 Victoria Street, Box 920
gmclean at bearingpoint.biz                Wellington, New Zealand



> -----Original Message-----
> From: Don Jones [mailto:don at gamma.net.nz]
> Sent: Thursday, March 06, 2003 9:56 AM
> To: wellington-pm-list at pm.org
> Subject: MYSQL Help!
> 
> 
> Hi
> 
> This is a plea for help!
> 
> This is a mysql question, with a perl script thrown in to 
> keep it on topic, Im
> asking here as I may get an intelligent response
> 
> I am not a DBA but unfortunately am the closest thing to one 
> here, we have a
> mysql db which I look after, its version: 3.22.26a on FreeBSD 
> 4.0-RELEASE (ie
> OLD). This db does a bunch of isp related stuff, ie dialup 
> users info and ip
> billing.
> 
> The problem is that there is a perl script which updates a 
> particular table
> each night. 
> 
> I ran this command:
> 
> mysql> delete from NeTraMet_Daily where date like '2001%';
> ERROR 1034: Incorrect key file for table: 'NeTraMet_Daily'. 
> Try to repair it
> 
> now when the script runs mysql will segfault
> 
> I asked for help on #mysql on irc.freenode.net where they 
> politely told me I
> should have upgraded 2 years ago, this is true but 
> unfortunately doesnt help
> my imediate problem. 
> 
> I was also advised to use the tool myisamchk, unfortunately 
> my version seems
> to old to include this tool.
> 
> Any suggestions on how to "Try to repair it" would be welcome.
> 
> Thanks
> 
> Don Jones
> 
> 



More information about the Wellington-pm mailing list