#1033 - Incorrect information in file: './database_name/table_name.frm'

php mysql phpmyadmin innodb myisam
warr0032 picture warr0032 · Mar 18, 2012 · Viewed 22.2k times · Source

I'm completely lost as to how or why this error is displaying when I go to browse the table data.

The one thing I did notice was that the Storage Engine has been switched to MyISAM with InnoDB saying it has been disabled.

I'm waiting to hear back from the hosting company but is there something I can explore until I hear back from them?

The sql should have been backed up on the server but when I download it, the file is empty.

Any tips on accessing this data is very much appreciated.

Answer

duskwuff -inactive- picture duskwuff -inactive- · Mar 18, 2012

Sounds like your host may have disabled InnoDB, which will make any existing InnoDB tables unusable. They may also have accidentally destroyed the InnoDB data file.

Either way, there's nothing you can do yourself to recover it.

Related questions

Import file size limit in PHPMyAdmin

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size. Why am I still seeing 2MB? Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.

Read More
How to log in to phpMyAdmin with WAMP, what is the username and password?

What does the word "root" mean in phpMyAdmin? Whenever I write localhost/phpmyadmin on the address bar, I am asked to enter a username and a password, but I don't know what they are. I don't remember when and where …

Read More
Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES)

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES) in C:\Users\xampp\htdocs\PHP_Login_Script\config.php on line 6 Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given in C:\Users\…

Read More