我以前保存过/ var / lib /
mysql / ddms目录的副本(“ddms”是模式名称).现在我通过运行apt-get install mysql-server在新安装的Ubuntu 10.04.3 LTS上安装了一个新的
MySQL,我相信安装了5.1版本.在我复制/ var / lib / mysql下的ddms目录后,它的一些表工作正常,这些表是一组相关的三个文件:.frm文件,.MYD文件和.MYI文件.
但是,有两个表具有不同的文件集:.frm文件和.ibd文件.这两个表没有显示在phpMyAdmin的表列表中.当我查看错误日志时,它说:
[ERROR] Cannot find or open table ddms/dictionary_item from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
请帮助恢复这两个表.谢谢.