php #1033 - 文件中的信息不正确：'./database_name/table_name.frm'
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/9761166/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
#1033 - Incorrect information in file: './database_name/table_name.frm'
提问by warr0032
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.
我注意到的一件事是存储引擎已切换到 MyISAM，InnoDB 说它已被禁用。
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.
sql应该已经备份在服务器上，但是当我下载它时，文件是空的。
Any tips on accessing this data is very much appreciated.
非常感谢有关访问此数据的任何提示。
采纳答案by duskwuff -inactive-
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.
听起来您的主机可能已禁用 InnoDB，这将使任何现有的 InnoDB 表无法使用。他们也可能不小心破坏了 InnoDB 数据文件。
Either way, there's nothing you can do yourself to recover it.
无论哪种方式，您都无法自己恢复它。
回答by user3523326
Come to /etc/my.cnf an change config to
来 /etc/my.cnf 更改配置
max_connections = 2500
query_cache_limit = 2M
query_cache_size = 150M
tmp_table_size = 200M
max_heap_table_size = 300M
key_buffer_size = 300M
tmpdir = /dev/shm
Run command: service mysqld restart
运行命令：service mysqld restart
check again, Good luck
再次检查，祝你好运
回答by Sudheesh.M.S
Just try to restart mysql. It helped me fix the problem
只需尝试重新启动mysql。它帮助我解决了问题
