Re: error 27

une 25, 2004 1:17 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: error 27 I don't really understand the difference (I need to read up a bit more). My (default mysql) table internet_usage has the following columns: uid varchar (10) ip bigint time datetime urlid int size int Is there som

Re: error 27

a backup of your data before making any changes. Donny -Original Message- From: J S [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 1:17 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: error 27 I don't really understand the difference (I need to read up a bit more)

Re: error 27

You can check error numbers with perror. : perror 127 Error code 127: Unknown error: 127 127 = Record-file is crashed You need to repair your table. See the manual for details . Michael J S wrote: Even the ALTER gave me an error! mysql> alter

Re: error 27

Even the ALTER gave me an error! mysql> alter table internet_usage change uid uid char(10); ERROR 1030: Got error 127 from table handler mysql> J S wrote: Thanks for your reply. I had to change the IP column to bigint because mysql was inserting the wrong value when it was just int. Are your ips

Re: error 27

J S wrote: Thanks for your reply. I had to change the IP column to bigint because mysql was inserting the wrong value when it was just int. Are your ips IPv4 (4 byte) or IPv6 (8 byte)? I'm guessing IPv4. In that case: mysql> SELECT INET_ATON('0.0.0.1'), INET_ATON('255.255.255.255'); +---

RE: error 27

which means it has varchar's, text, > >or > >blobs the limit is 2 gigs. If you are using a fixed table which uses > chars > >only, then there is no limit that I have seen. > > > >Donny > > > > > -Original Message- > > > From: J

RE: error 27

M > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: error 27 > > I don't really understand the difference (I need to read up a bit more). > My > (default mysql) table internet_usage has the following columns: > > uid varchar (10) > ip bigint > t

RE: error 27

--- > From: J S [mailto:[EMAIL PROTECTED] > Sent: Friday, June 25, 2004 9:38 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: error 27 > > Could this problem be due to the size of my tables? Is there a limit on > how > big the table can be? > I'm using m

RE: error 27

riday, June 25, 2004 9:38 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: error 27 > > Could this problem be due to the size of my tables? Is there a limit on > how > big the table can be? > I'm using mysql-standard-4.0.20. > > -rw-rw

RE: error 27

Could this problem be due to the size of my tables? Is there a limit on how big the table can be? I'm using mysql-standard-4.0.20. -rw-rw 1 mysqlmysql2147483647 Jun 25 01:49 internet_usage.MYD -rw-rw 1 mysqlmysql622724096 Jun 25 01:49 internet_usage.MYI Hi, I got an er