I  have  pretty much figured out what is going on. I forgot one pretty
major item from my initial message. I had started mysql up without any
my.cnf  configuration  file at first and was using it without prior to
my using the my-huge.cnf config file.

Please correct me if I'm wrong. That ultimately changed the way InnoDB
tables  were viewed by MySQL because of the new log file and data file
path parameters. Which ultimately lead me to this page:

  http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html

On Thursday, August 31, 2006 at 2:25:07 PM, Mikhail confabulated:

> How much do you care about "test" table, Duane?

> In your own words: "I do not have anything really set up yet", so drop
> the table or even the whole testdb database and see if that helps

> Regards,

> Mikhail Berman

> -----Original Message-----
> From: Duane Hill [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, August 31, 2006 10:18 AM
> To: Mikhail Berman
> Cc: mysql@lists.mysql.com
> Subject: Re: Incorrect information in file...

> On Thursday, August 31, 2006 at 2:02:42 PM, Mikhail confabulated:

>> Hi Duane,

>> Have you tried to repair "test" table using "REPAIR" to see if that 
>> solves your problem?

> That didn't seem to work. The result returned was:

>   mysql> repair table test;
>  
> +-------------+--------+----------+-------------------------------------
> --------------------+
>   | Table       | Op     | Msg_type | Msg_text
> |
>  
> +-------------+--------+----------+-------------------------------------
> --------------------+
>   | testdb.test | repair | error    | Incorrect information in file:
> './testdb/test.frm' |
>  
> +-------------+--------+----------+-------------------------------------
> --------------------+

> I even tried with the USE_FRM option and received the same result.
>   
>> -----Original Message-----
>> From: Duane Hill [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, August 31, 2006 9:49 AM
>> To: mysql@lists.mysql.com
>> Subject: Incorrect information in file...


>>   MySQL v5.0.24 on FreeBSD v6.0-RELEASE

>>   I  was  attempting  to  do  some  tweaking  in  a my.cnf to increase
>>   performance  on  a  server here. I had copied the my-huge.cnf config
>>   file  into /etc and uncommented the section on InnoDB from within. I
>>   also changed the thread_concurrency option from 8 to 4. That was the
>>   only  changes  I  made  in  the  configuration file. Upon restarting
>>   MySQL,  I  could  not select anything from any of the InnoDB tables
>>   and received this error:

>>       ERROR 1033 (HY000): Incorrect information in file:
>> './testdb/test.frm'
>>   
>>   I  did  do  some searching in the list archives but couldn't come up
>>   with anything concrete.

>>   For the convenience, here is the options that were uncommented:

>>       innodb_data_home_dir = /var/db/mysql/
>>       innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
>>       innodb_log_group_home_dir = /var/db/mysql/
>>       innodb_log_arch_dir = /var/db/mysql/
>>       innodb_buffer_pool_size = 384M
>>       innodb_additional_mem_pool_size = 20M
>>       innodb_log_file_size = 100M
>>       innodb_log_buffer_size = 8M
>>       innodb_flush_log_at_trx_commit = 1
>>       innodb_lock_wait_timeout = 50

-- 
"This message was sent using 100% recycled electrons."


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to