oh ok so what is status of the recommendation in the wiki? If I drop the key (I will search how to do as my db knowledge are low), dont I have a risk that something disappears?
signature_jp_2 Logo Hypra JEAN-PHILIPPE MENGUAL DIRECTEUR TECHNIQUE ET QUALITÉ 102, rue des poissonniers, 75018, Paris Tel : +331 84 73 06 61 <tel:+33184730661> Mob : +336 76 34 93 37 <tel:+33676349337> [email protected] <mailto:[email protected]> www.hypra.fr <http://www.hypra.fr/> Facebook Hypra <https://www.facebook.com/hyprasoftware/> Twitter Hypra <https://twitter.com/Hypra_> Linkedin Jean-Philippe <https://fr.linkedin.com/in/jean-philippe-mengual-800133135> Le 28/02/2018 à 19:41, Laurent Destailleur (aka Eldy) a écrit : > 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] <mailto:[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, > > > -- > Logo Hypra JEAN-PHILIPPE MENGUAL > DIRECTEUR TECHNIQUE ET QUALITÉ > 102, rue des poissonniers, 75018, Paris > Tel : +331 84 73 06 61 <tel:+33184730661> Mob : +336 76 34 93 37 > <tel:+33676349337> > [email protected] <mailto:[email protected]> > www.hypra.fr <http://www.hypra.fr/> > Facebook Hypra <https://www.facebook.com/hyprasoftware/> Twitter > Hypra <https://twitter.com/Hypra_> Linkedin Jean-Philippe > <https://fr.linkedin.com/in/jean-philippe-mengual-800133135> > > > > _______________________________________________ > Dolibarr-user mailing list > [email protected] <mailto:[email protected]> > https://lists.nongnu.org/mailman/listinfo/dolibarr-user > <https://lists.nongnu.org/mailman/listinfo/dolibarr-user> > > > > > -- > EMail: [email protected] <mailto:[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] > <mailto:[email protected]>) > * AWStats (Author) : http://awstats.sourceforge.net (make a donation > for AWStats project via Paypal: [email protected] > <mailto:[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
_______________________________________________ Dolibarr-user mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/dolibarr-user
