mysql error : Incorrect information in file: ./table.frm

by Gabi Solomon

After tinkering with my VPS settings to optimize it ( it was having some low memory problems ) and after restarting the server, just when i tought everything was ok i noticed that i managed to break some websites.

they all got this error:

mysql error : Incorrect information in file: ./table.frm

After a bit of googling i found the problem … apparently it could be because there is no support for InnoDB … oops. In my quest for optimization i disabled the support for InnoDB tables thinking that there werent any InnoDB tables in the websites hosted on that VPS .. apparently they were .

Hope you get here faster then i found the solution.
Cheers

Date March 11, 2009 at 01:24
Under Programing, mysql Tags: error, mysql
You can follow any responses to this entry through the RSS 2.0 feed .
You can leave a response , or trackback from your own site .

Gabi Solomon

if you dont use InnoDb tables its recommended to turn out the support because that suport creates a load in the server to some extend
aleahhill

Why no InnoDB? I'm new to MySQL, but I thought those were the only tables with foreign keys? Or should I be throwing out my beginning My SQL book? :P

blog comments powered by Disqus

About

GS Design is a developers blog of Gabi Solomon, a professional PHP programmer and web developer from Romania. This blog is meant to serve as an informative resource for web developers with specific insignts offered on the subjects of PHP, Javascript, XHTML, CSS and design. For more information about the blog or about the author, read the About page.

GS Design Just another developer blog