# Incorrect information in file in mysql

**URL:** <https://forums.percona.com/t/incorrect-information-in-file-in-mysql/1145>\
**Category:** Other MySQL® Questions\
**Created:** [April 13, 2009, 12:25am UTC](https://forums.percona.com/t/incorrect-information-in-file-in-mysql/1145 "2009-04-13T00:25:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ervaneet82](https://avatars.discourse-cdn.com/v4/letter/e/c68b51/32.png) [@ervaneet82](https://forums.percona.com/u/ervaneet82)\
**Post date:** [April 13, 2009, 12:25am UTC](https://forums.percona.com/t/incorrect-information-in-file-in-mysql/1145/1 "2009-04-13T00:25:48Z")

</div>

Hi,

I am getting the following error

* * *

‘error of Incorrect information in file in mysql: tablename.frm’.

* * *

I am using the storage engine of table is innodb.

I search in the google. It says the database is corrupted. But I didn’t get the solution to recover the data.

Vaneet Gupta

---

<div class="post-metadata">

**Author:** ![reyortsed](https://avatars.discourse-cdn.com/v4/letter/r/50afbb/32.png) [@reyortsed](https://forums.percona.com/u/reyortsed)\
**Post date:** [April 13, 2009, 1:04am UTC](https://forums.percona.com/t/incorrect-information-in-file-in-mysql/1145/2 "2009-04-13T01:04:45Z")

</div>

Sounds to me like you have either changed the data path of the InnoDB data file, or changed the buffer pool size without removing the log file first. Something has probably changed in your “my.ini” to cause this… what changes have you recently made, and what editor do you use for your my.ini?

//Steve

---

<div class="post-metadata">

**Author:** ![ervaneet82](https://avatars.discourse-cdn.com/v4/letter/e/c68b51/32.png) [@ervaneet82](https://forums.percona.com/u/ervaneet82)\
**Post date:** [April 13, 2009, 11:53pm UTC](https://forums.percona.com/t/incorrect-information-in-file-in-mysql/1145/3 "2009-04-13T23:53:26Z")

</div>

Hello Steve,

I think you are right. I think I had made the changes buffer pool size without deleting log file first. I use the editor edit plus.

Can you tell me why we need to delete log file. There are two log files which one is need to delete.

What is the relation b/w buffer pool size ?

Even I had made changes in my.ini

in MyISAM

max\_connections=500  
max\_connect\_errors=1000

Once in disable in innodb settings skip-innodb.