MySQL Forums
Forum List  »  Data Recovery

MYsql only able to start with innodb_force_recovery=1
Posted by: Khairur Rijal
Date: February 17, 2009 08:43AM

When I started mysql server normally it wont start, only when I start it with innodb_force_recovery=1, this happened after I create multiple data files and after it successfull, I was again changed the path of the file by copying to another location restarted it then the problem raised.Do anyone here have any idea how to make sure normal start possible with Mysql5.1 again ?

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqld --console --verbose
InnoDB: Error: tablespace size stored in header is 10624 pages, but
InnoDB: the sum of data file sizes is only 9984 pages
090217 22:34:41 InnoDB: Started; log sequence number 0 530149171
InnoDB: !!! innodb_force_recovery is set to 1 !!!
090217 22:34:42 [Note] Event Scheduler: Loaded 0 events
090217 22:34:42 [Note] mysqld: ready for connections.
Version: '5.1.29-rc-community-log' socket: '' port: 3306 MySQL Community Server (GPL)

Options: ReplyQuote

Written By
MYsql only able to start with innodb_force_recovery=1
February 17, 2009 08:43AM

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.