[Dolibarr-user] Problem restoring a database

[MENGUAL Jean-Philippe]

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