|
From: | Laurent Destailleur (aka Eldy) |
Subject: | Re: [Dolibarr-user] Problem restoring a database |
Date: | Wed, 28 Feb 2018 19:41:41 +0100 |
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, ParisTel : +331 84 73 06 61 Mob : +336 76 34 93 37
_______________________________________________
Dolibarr-user mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-user
[Prev in Thread] | Current Thread | [Next in Thread] |