error while doing a select

2007-06-01 Thread Ananda Kumar 

Hi All,
We are using mysql version 5.0.40.

We took a snapshot of the our database, and copied over the snapshot to
anther machine and start mysql on the new snapshot. Its innodb engine

when i treid to select from one of the tables i am getting this error, how
do i fix this ,please help

select count(*) from auth;
ERROR 1033 (HY000): Incorrect information in file: './auth/auth.frm

regards
anandkl

Re: error while doing a select

2007-06-01 Thread Baron Schwartz 

Hi,

Ananda Kumar wrote:

Hi All,
We are using mysql version 5.0.40.

We took a snapshot of the our database, and copied over the snapshot to
anther machine and start mysql on the new snapshot. Its innodb engine

when i treid to select from one of the tables i am getting this error, how
do i fix this ,please help

select count(*) from auth;
ERROR 1033 (HY000): Incorrect information in file: './auth/auth.frm


You should read the entire manual chapter on InnoDB before going further:

http://dev.mysql.com/doc/refman/5.0/en/innodb.html

You should read the sections on errors, troubleshooting, and startup as many times as 
necessary.  Make sure you understand InnoDB tablespaces, log files, and so on.  Then I 
think you will not have any more troubles :-)


Regards,
Baron

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