MySQL Forums
Forum List  »  French

Re: Import Dump Erreur ERROR 1449 (HY000)
Posted by: John322 pinfada
Date: January 27, 2015 09:22AM

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 */;

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Import Dump Erreur ERROR 1449 (HY000)
1383
January 27, 2015 09:22AM


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.