mysql wont start afer power failure

[gleaming]

Hi,

our mysql database server wont start after an unsuspected system shutdown. I can start the database with innodb_force_recovery = 4 and then i get the following lines on the .err file.

 

InnoDB: for more information.

121115 21:49:39  InnoDB: Error: page 1196090 log sequence number

366303858209

InnoDB: is in the future! Current system log sequence number 363674086422.

InnoDB: Your database may be corrupt or you may have copied the InnoDB

InnoDB: tablespace but not the InnoDB log files. See

InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html

InnoDB: for more information.

121115 21:49:39  InnoDB: Error: page 1196059 log sequence number

367805782117

InnoDB: is in the future! Current system log sequence number 363674086422.

InnoDB: Your database may be corrupt or you may have copied the InnoDB

InnoDB: tablespace but not the InnoDB log files. See

InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html

InnoDB: for more information.

[MrPhil]

You'd probably do better asking on a MySQL forum. Maybe, if you're lucky, somewhere here can answer your question, but that kind of deep stuff is probably out of most people's range here.

[burt]

Be aware that these people asking technical questions have (very) similar email addresses, so will likely come back in a few days with new username and reply with some excellent spam.

[douglaswalker]

Ahh I see so something like

 

Excellent DataBase specialist would recommend going to www.spammityspamapam where  I will fix everything including your life.

Just send your bank details...

Sounds reasonable (w00t) .

[oscMarket]

lol.... here is the free answer :

 

X:\yyyy\bin\mysql\mysql5.x.xx\data 

 

Temp fix:

 

DELETE following 2 files :

ib_logfile0

ib_logfile1

 

Restart mysql

 

100% fix

 

Export ALL your databases.

Remove (or rename) beside the 2 logfiles also : ibdata1

 

Restart mysql

import your databases back.

[burt]

I will probably just start nuking new users who post irrelevance on this forum.

[clustersolutions]

Why 4? Needs more error logs b4 you set the 4. 

 

I can start the database with innodb_force_recovery = 4 and then i get the following lines on the .err file.