Re: [Dolibarr-user] Problem restoring a database

[MENGUAL Jean-Philippe]

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?

JEAN-PHILIPPE MENGUAL DIRECTEUR TECHNIQUE ET QUALITÉ 102, rue des poissonniers, 75018, Paris Tel : +331 84 73 06 61 Mob : +336 76 34 93 37 address@hidden www.hypra.fr

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 <address@hidden>:

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,

--

JEAN-PHILIPPE MENGUAL DIRECTEUR TECHNIQUE ET QUALITÉ 102, rue des poissonniers, 75018, Paris Tel : +331 84 73 06 61 Mob : +336 76 34 93 37 address@hidden www.hypra.fr

_______________________________________________
Dolibarr-user mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-user

--

EMail: address@hidden

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: address@hidden)

* AWStats (Author) : http://awstats.sourceforge.net (make a donation for AWStats project via Paypal: address@hidden)

* AWBot (Author) : http://awbot.sourceforge.net

* CVSChangeLogBuilder (Author) : http://cvschangelogb.sourceforge.net

_______________________________________________
Dolibarr-user mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-user