RE: repair table (error 27)

, Martijn > -Original Message- > From: news [mailto:[EMAIL PROTECTED] On Behalf Of Dirk Vleugels > Sent: dinsdag 12 juli 2005 19:37 > To: mysql@lists.mysql.com > Subject: repair table (error 27) > > Hi, > > the DB resided on a network appliance filer (happily for a

Re: repair table (error 27)

Hello. > | eps4.inmail | repair | warning | Can't change size of indexfile, error: 27 As of MySQL 4.0.2, there is a USE_FRM mode for REPAIR TABLE. Use it if the .MYI index file's header is corrupted. See: http://dev.mysql.com/doc/mysql/en/repair-table.html

repair table (error 27)

ext | +-++--+---+ | eps4.inmail | repair | warning | Can't change size of indexfile, error: 27 | | eps4.inmail | repair | error| 27 for record at pos 9037492 | | eps4.inmail

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

ow > > > 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_

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

ot an error 27. DBD::mysql::st execute failed: Got error 27 from table handler at /home/u752359/logfile.pl line 144, line 3079464. The FAQs say: Check whether you have hit 2 Gb limit. If that is not the case, shutdown MySQL server and repair a table with (my)isamchk. How do I check if I have a 2GB

error 27

Hi, I got an error 27. DBD::mysql::st execute failed: Got error 27 from table handler at /home/u752359/logfile.pl line 144, line 3079464. The FAQs say: Check whether you have hit 2 Gb limit. If that is not the case, shutdown MySQL server and repair a table with (my)isamchk. How do I check if I

Re: table handler error 27 (cont'd)

Hi. Hm. Maybe you have too few free space in your tmp directory? Regards, Benjamin. On Fri, May 10, 2002 at 06:38:19PM -0400, [EMAIL PROTECTED] wrote: > I have checked my file size in my data dir and can't find any files > close to 2GB even looking in subdirs. > > Does this mean th

Re: table handler error 27 (cont'd)

nct value) from table; > on a table with more than 19 million records i got the error: > got error 27 from table handler (or something like that) > > i looked up the error in mysql perror which gave me "file too large" > > does this have to do with my file size in li

table handler error 27

when running select count(distinct value) from table; on a table with more than 19 million records i got the error: got error 27 from table handler (or something like that) i looked up the error in mysql perror which gave me "file too large" does this have to do with my file size i