There is no need to edit the mysqldump sql file. It is even not recommended
to modify it.
Just drop the table llx_accounting_account and/or llx_accounting_system
manually before launching the load.

2018-02-28 19:16 GMT+01:00 MENGUAL Jean-Philippe <[email protected]>:

> Hi,
>
> I am restoring a 5.0.3 Dolibarr and mysql command prints:
> ERROR 1005 (HY000) at line 20: Can't create table
> `dolibarr`.`llx_accounting_account` (errno: 150 "Foreign key constraint
> is incorrectly formed")
>
> In the dump, I added, as recommended on the wiki:
>
> SET FOREIGN_KEY_CHECKS=0;SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
>
> and at the end:SET FOREIGN_KEY_CHECKS=0;
>
> I addd this after the error appeared. Then i retried, idem.
>
> Should I be worry with it? Can I fix it? What about the remaining of the 
> database, can I consider it is restored?
>
> Tnaks for help
> regards,
>
>
>
> --
> [image: Logo Hypra] JEAN-PHILIPPE MENGUAL
> DIRECTEUR TECHNIQUE ET QUALITÉ
> 102, rue des poissonniers, 75018, Paris
> Tel : +331 84 73 06 61 <+33184730661> Mob : +336 76 34 93 37
> <+33676349337>
> [email protected]
> www.hypra.fr
> [image: Facebook Hypra] <https://www.facebook.com/hyprasoftware/> [image:
> Twitter Hypra] <https://twitter.com/Hypra_> [image: Linkedin
> Jean-Philippe]
> <https://fr.linkedin.com/in/jean-philippe-mengual-800133135>
>
>
> _______________________________________________
> Dolibarr-user mailing list
> [email protected]
> https://lists.nongnu.org/mailman/listinfo/dolibarr-user
>



-- 
EMail: [email protected]
Web: http://www.destailleur.fr
------------------------------------------------------------------------------------
Google+: https://plus.google.com/+LaurentDestailleur-Open-Source-Expert/
Facebook: https://www.facebook.com/Destailleur.Laurent
Twitter: http://www.twitter.com/eldy10
------------------------------------------------------------------------------------
* Dolibarr (Project leader): https://www.dolibarr.org (make a donation for
Dolibarr project via Paypal: [email protected])
* AWStats (Author) : http://awstats.sourceforge.net (make a donation for
AWStats project via Paypal: [email protected])
* AWBot (Author) : http://awbot.sourceforge.net
* CVSChangeLogBuilder (Author) : http://cvschangelogb.sourceforge.net
_______________________________________________
Dolibarr-user mailing list
[email protected]
https://lists.nongnu.org/mailman/listinfo/dolibarr-user

Répondre à