Hi ED, thats a number to big for me yet. Sorry. I guess thats better posted to the mailing list.
The best I can do is an educated guess (or whatever thats called). And that would be some set limits either from mysql, because the search takes quite long (you could find out with log-slow-queries), or from the ASP side perhaps a time limit etc. Best regards Nils Valentin Tokyo/Japan 2003年 8月 13日 水曜日 01:00、あなたは書きました: > Hey Nils,. > > Is there a way I can set error checking on a page? I have a test mySQL > db that displays all the records in an ASP page. It works without a > problem (it's only 10 records). Then I try it with the main db (and the > 1.7 millions records), and it crashes, giving me a "page cannot be > displayed" error. > > How can I find out where the problem is at? > > 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]
