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]

Reply via email to