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
