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?
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 !
run from CMD & %path%=set to mysql/bin
mysql_upgrade -u user -ppassword
Check filenames.
You might need to create a new database in phpmyadmin that matches the database you're trying to import.
I had this problem because of a trigger not working..Worked after I deleted the trigger.
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.
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.