create table if not exists 'tb_name' -> #1146 - Table 'tb_name' doesn't exist
Hi,
MySQL 5.5.16.
Started working on already existing database (engine MyISAM). Added few tables (mistakenly engine InnoDB). Wanted to make a copy of database, so I made a dump file (.sql). Every time I try to import this dump file I get this error:
"#1146 - Table 'my_rage' doesn't exist".
part of dump file to create this table (manualy changed ENGINE=InnoDB to MyISAM):
CREATE TABLE IF NOT EXISTS `my_rage` (
`ProjectType` int(10) NOT NULL,
`Name` varchar(255) NOT NULL,
PRIMARY KEY (`ProjectType`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
If I rename the table in this dump file (my_rage > myrage) then everything is imported just fine.
Can you help me understand why I got this kind of problem?
Subject
Written By
Posted
create table if not exists 'tb_name' -> #1146 - Table 'tb_name' doesn't exist
April 16, 2012 03:35AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.