Re: Error No. 1033 Incorrect information in file: 'filename'
I had the same problem after i have changed mysql configuration through MYSQL Administrator.
MYSQL Administraton has a bug, it overwrites the my.ini file and put comments (#) everywhere.
So, do this:
1) switch to last backup of my.ini file (and copy it somewhere)
2) specify the path for innodb data file.
I have obtained the correct string using MYSQL Administration -> Startup variables -> innoDB variables -> check data file path
This action add a line at the end of my.ini (but again comment all other lines!)
So, copy this line (example: mine is innodb_data_file_path=ibdata1:102760448:autoextend), add the line to the old (and good!) my.ini and overwrite again the my.ini file with this file.
3) Restart
....And it works again!
Antonio Beghi.
infinitevs Wrote:
-------------------------------------------------------
> Hi Everyone,
>
> I spoke to my web hosting company and they said
> that the INNODB database corrupted somehow.. I
> have no backups as they were supposed to daily and
> weekly backups, it took them a week to realise
> what happened so the backups got overwritten, and
> the corrupted tables did not backup as they were
> corrupted.
>
> When I click on the database tables in question
> they come up with:
>
> "Error No. 1033 Incorrect information in file:
> 'filename'"
>
> Is there anyway to recover this data or is it lost
> forever?
>
> kind regards,
>
> Sean.
Subject
Views
Written By
Posted
118168
July 31, 2006 11:06PM
62502
August 01, 2006 03:15AM
Re: Error No. 1033 Incorrect information in file: 'filename'
47528
December 11, 2006 02:44AM
29607
April 14, 2007 11:14PM
27692
May 24, 2007 08:05AM
26439
July 12, 2007 08:02PM
21378
July 16, 2008 04:25PM
15407
February 14, 2009 09:08PM
12176
May 22, 2009 10:13AM
11930
May 26, 2009 01:28AM
10854
July 02, 2009 09:25AM
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.