Hi Ed,
wouldn't that be the same cause >> "no space left on device" ??
A index is using perhaps another 30% of the whole table.
Best regards
Nils Valentin
Tokyo/Tokyo
2003年 8月 13日 水曜日 00:27、あなたは書きました:
> Hey Nils,
>
> I just tried it again, and it worked. :)
>
> However, I tried creating a few indexes in the db within SQLyog (GUI
> front end), and got the same error ("error 28 within table handler").
> Why would I be getting an error from trying to create an index?
>
> Thanks,
>
> Ed
>
>
> -----Original Message-----
> From: Nils Valentin [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 12, 2003 9:46 AM
> To: Ed Kraft
> Subject: Re: Error Code 28?
>
>
> Hi Ed,
>
> hmm, what does "perror 28" say ?
>
> If I guess right than it shoud say " no space left on device " or
> something
> like this. This is only the partition where the data files are on. The
> other
> partitions are not of interest for this.
>
> Could you let me know which MySQL version and from where (MySQL or f.e
> Redhat)
> and which format (RPM or tar etc.) and which Linux OS. I will see what
> I can
> find out
>
> Best regards
>
> Nils Valentin
> Tokyo/Japan
>
> 2003年 8月 12日 火曜日 22:38、あなたは書きました:
> > Thanks Nils. I am running this on Linux, but when I check my hd
> > usage, I'm not full. I don't get it. :)
> >
> > Thanks,
> >
> > Ed
> >
> >
> > -----Original Message-----
> > From: Nils Valentin [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, August 12, 2003 9:26 AM
> > To: Ed Kraft; [EMAIL PROTECTED]
> > Subject: Re: Error Code 28?
> >
> >
> > Hi ED,
> >
> > Very close you are. If you run Linux than this message means "get a
> > new Harddisk for me please" ;-) I am full ;-)
> >
> > You can check this with "perror 28".
> >
> > Perror works only for the OS dependent messages (1-150) The other you
> > will have to figure out yourself ;-)... or you can check my homepage
> >
> > http://www.knowd.co.jp/staff/nils/mysql-error-codes.html
> >
> >
> > Best regards
> >
> > Nils Valentin
> > Tokyo/Japan
> >
> > 2003年 8月 12日 火曜日 21:18、Ed Kraft さんは書きました:
> > > Hey All,
> > >
> > > Does anyone know what this error code means? I think it may have
> > > something to do with the database being too large. The exact error
> > > is, "ERROR 1030: Got error 28 from table handler"
> > >
> > > What I tried doing was importing into a mySQL db via a text file.
> > > There are approximately 1.7 million records in the text file (the
> > > text
> > >
> > > file is 467 mb).
> > >
> > > Any suggestions would be greatly appreciated.
> > >
> > > Thanks,
> > >
> > > Ed
--
---
Valentin Nils
Internet Technology
E-Mail: [EMAIL PROTECTED]
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
