Erro ao Importar BASE

[InSoNiA 0]

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+

[Wagner Bianchi 0]

A cada comando excutado pelo parser do MySQL, ele executou um comando SHOW WARNINGS e não soube lidar com essa abordagem em meio ao restore.

Provavelmente, quando você mandou exportar, colocaste coisa a mais em meio ao dump e deu esta mensagem. Ignore, se a base restaurou, está tudo bem.

 

A presto... http://forum.imasters.com.br/public/style_emoticons/default/thumbsup.gif

[giesta 29]

As vezes abrir o arquivo e ir na linha q o programa alega ter erro ajuda mto...