Erro ao Importar BASE
Olá pessoal!
Fiz a modelagem de um banco de dados que estou fazendo exportei para um arquivo SQL. O problema é que ao Restaurar backu pelo MySQL Administrator deu erro: Warning: Do not know how to handle this statement at line 5:
SHOW WARNINGS;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 13:
SHOW WARNINGS;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 20:
SHOW WARNINGS;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 27:
SHOW WARNINGS;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 43:
SHOW WARNINGS;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 46:
SHOW WARNINGS;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 53:
SHOW WARNINGS;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 70:
SHOW WARNINGS;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 73:
SHOW WARNINGS;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 80:
SHOW WARNINGS;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 93:
SHOW WARNINGS;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 100:
SHOW WARNINGS;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 107:
SHOW WARNINGS;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 114:
SHOW WARNINGS;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 121:
SHOW WARNINGS;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 128:
SHOW WARNINGS;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 140:
SHOW WARNINGS;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 143:
SHOW WARNINGS;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 150:
SHOW WARNINGS;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Error while executing this query:CREATE TABLE IF NOT EXISTS `mydb`.`templatescores` (
`idcor` INT NOT NULL AUTO_INCREMENT ,
`cor` VARCHAR(45) NOT NULL ,
`templates_idtemplates` VARCHAR(255) NULL ,
PRIMARY KEY (`idcor`) ,
CONSTRAINT `fk_templatescores_templates`
FOREIGN KEY (`templates_idtemplates` )
REFERENCES `mydb`.`templates` (`idtemplate` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB DEFAULT CHARSET=utf8;
The server has returned this error message:Can't create table 'mydb.templatescores' (errno: 150)MySQL Error.
Ai então eu ativei a opção para Ignorar Erros e criou o banco normalemente, tabelas e etc. O problema é que estou com receio de tentar utilizar o banco, popular e etc e dar problema no futuro. Será que alguém já passou por isso e tem alguma idéia de como posso resolver?
Agradeço que puder ajudar.
T+
Discussão (2)
Carregando comentários...