漏洞?#1146 - 表 'xxx.xxxxx' 不存在 [英] Bug? #1146 - Table 'xxx.xxxxx' doesn't exist

问题描述

我使用的是 Windows XP.我正在使用其内置的创建表功能在 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' does not 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屋！