Re: Import Dump Erreur ERROR 1449 (HY000)

[John322 pinfada]

Effectivement vous avez raison.

Le Dump est beaucoup trop gros.
Voici un partie du dump (concernant les vues qui me pose problème).

/*!50001 DROP TABLE IF EXISTS `actorsbyuser`*/;
/*!50001 DROP VIEW IF EXISTS `actorsbyuser`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = latin1 */;
/*!50001 SET character_set_results     = latin1 */;
/*!50001 SET collation_connection      = latin1_swedish_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER='test'@'test.client.priv' SQL SECURITY DEFINER */
/*!50001 VIEW `actorsbyuser` AS select `conf_affectation`.`OID` AS `OID`,`conf_affectation`.`TIMESTAMP` AS `TIMESTAMP`,`conf_affectation`.`COL_ACTOROID` AS `useroid`,(case `conf_affectation`.`COL_DELEGATED` when '1' then `conf_affectation`.`COL_DELEGATOROID` else `conf_affectation`.`COL_ACTOROID` end) AS `agtoid`,`conf_affectation`.`COL_DELEGATED` AS `isdelegated` from `conf_affectation` where ((`conf_affectation`.`COL_BEGINDATE` <= sysdate()) and (`conf_affectation`.`COL_ENDDATE` >= sysdate()) and ((`conf_affectation`.`COL_REF_ROLE` like 'Manager_CO%') or (`conf_affectation`.`COL_REF_ROLE` like 'GestRH_CO%'))) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;