漏洞? #1146-表'xxx.xxxxx'不存在 [英] Bug? #1146 - Table 'xxx.xxxxx' doesn't exist
问题描述
我正在使用Windows XP.我正在使用其内置的create table功能在phpMyAdmin中创建一个表,
我的数据库名称是ddd
.
I am using windows XP. I am creating a table in phpMyAdmin using its built-in create table feature,
my database name is ddd
.
它生成以下代码:
CREATE TABLE `ddd`.`mwrevision` (
`asd` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`sddd` INT NOT NULL
) ENGINE = INNODB;
并显示以下错误:
MySQL said:
#1146 - Table 'ddd.mwrevision' doesn't exist
可能是什么问题?
推荐答案
我过去也遇到过同样的问题.将数据库文件移动到新位置并更新mysql服务器后,一切都发生了.所有带有InnoDB引擎的表都从我的数据库中消失了.我试图重新创建它们,但是mysql一直告诉我1146: Table 'xxx' doesn't exist
,直到我重新创建数据库并重新启动mysql服务为止.
I also had same problem in past. All had happend after moving database files to new location and after updating mysql server. All tables with InnoDB engine disappeared from my database. I was trying to recreate them, but mysql told me 1146: Table 'xxx' doesn't exist
all the time until I had recreated my database and restarted mysql service.
我认为有必要阅读有关InnoDB表二进制文件的信息.
I think there's a need to read about InnoDB table binaries.
这篇关于漏洞? #1146-表'xxx.xxxxx'不存在的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!