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: [email protected]
> 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]
