Bug? #1146 - Table 'xxx.xxxxx' doesn't

2019-01-06 15:13发布

I am using windows XP. I am creating a table in phpMyAdmin using its built-in create table feature, my database name is ddd.

It generates the following code:

CREATE TABLE  `ddd`.`mwrevision` (

`asd` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`sddd` INT NOT NULL
) ENGINE = INNODB;

and the following error shows up:

MySQL said:     
#1146 - Table 'ddd.mwrevision' doesn't exist 

What might be the problem?

18条回答
对你真心纯属浪费
2楼-- · 2019-01-06 15:41

In my case I ran this command even if the table wasn't visible in PhpMyAdmin :

DROP TABLE mytable

then

CREATE TABLE....

Worked for me !

查看更多
劳资没心,怎么记你
3楼-- · 2019-01-06 15:41

run from CMD & %path%=set to mysql/bin

mysql_upgrade -u user -ppassword

查看更多
Melony?
4楼-- · 2019-01-06 15:42

Check filenames.
You might need to create a new database in phpmyadmin that matches the database you're trying to import.

查看更多
相关推荐>>
5楼-- · 2019-01-06 15:43

I had this problem because of a trigger not working..Worked after I deleted the trigger.

查看更多
我只想做你的唯一
6楼-- · 2019-01-06 15:44

I had the same problem. I tried to create a table in mysql and got the same error. I restarted mysql server and ran the command and was able to create/migrate table after restating.

查看更多
乱世女痞
7楼-- · 2019-01-06 15:45

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.

I think there's a need to read about InnoDB table binaries.

查看更多
登录 后发表回答