MySQL Forums
Forum List  »  InnoDB

Re: InnoDB check tables
Posted by: Eric Bergen
Date: June 20, 2008 10:35PM

InnoDB supports the check tables sql statement but it doesn't support repair tables. To recover tables from innodb you need to start it with the appropriate recovery options then use mysqldump to extract as much data as you can. You can find the details about innodb recovery options here:

http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html

High Performance MySQL Consulting.
Proven Scaling LLC
http://provenscaling.com

Options: ReplyQuote


Subject
Views
Written By
Posted
5168
June 12, 2008 08:33PM
Re: InnoDB check tables
1990
June 20, 2008 10:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.