Check to see if your system uses "inodes" and whether or not they are corrupt.
It may be worth running fsck, too.
Hood
Dave Hodgkinson <daveh@stripped> on 03/30/2000 10:32:40 AM
To: sinisa@stripped
cc: mysql@stripped (bcc: Hood Gardner/SpeedlineAmericas/Cookson)
Subject: Re: ERROR 1030: Got error 28 from table handler
sinisa@stripped wrote:
>
> Dave Hodgkinson writes:
> >
> > Any idea what this might be?
> >
> > mysql> select
> > -> zone.name, month,count(distinct zone,month,username)
> > -> from
> > -> hit_gimp, zone
> > -> group by zone,month ;
> > ERROR 1030: Got error 28 from table handler
> >
> > TIA,
> >
> > Dave
>
> Hi!
>
> You ran out of disk space.
Where? It'd be nice to know.
root@ziggurat /root]# df -k
Filesystem 1k-blocks Used Available Use% Mounted on
/dev/hda3 9305844 8353300 479832 95% /
/dev/hda1 15522 6131 8590 42% /boot
/dev/md0 17630936 2156392 14578936 13% /u0
--
David Hodgkinson, Technical Director, Sift PLC http://www.sift.co.uk
Editor, "The Highway Star" http://www.deep-purple.com
Dave endorses Yanagisawa saxes, Apache, Perl, Linux, MySQL, emacs, gnus
--
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread32724@stripped
To unsubscribe, send a message to:
<mysql-unsubscribe-hgardner=speedlinetech.com@stripped>