# Restore database Fail

**URL:** <https://www.dolibarr.org/forum/t/restore-database-fail/18783>\
**Category:** Installing my Dolibarr\
**Created:** [March 27, 2020, 1:10pm UTC](https://www.dolibarr.org/forum/t/restore-database-fail/18783 "2020-03-27T13:10:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![seif1979](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/s/7feea3/32.png) [@seif1979](https://www.dolibarr.org/forum/u/seif1979)\
**Post date:** [March 27, 2020, 1:10pm UTC](https://www.dolibarr.org/forum/t/restore-database-fail/18783/1 "2020-03-27T13:10:05Z")

</div>

hello  
I can’t restore dolibarr database after reinstallation and i have this message bellow : ERROR 1005 (HY000) at line 25: Can’t create table `dolibarr`.`llx_accounting_account` (errno: 150 “Foreign key constraint is incorrectly formed”).  
Please help me.

BR.

---

<div class="post-metadata">

**Author:** ![simicar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/simicar/32/3072_2.png) [@simicar](https://www.dolibarr.org/forum/u/simicar)\
**Post date:** [April 10, 2020, 7:23am UTC](https://www.dolibarr.org/forum/t/restore-database-fail/18783/2 "2020-04-10T07:23:26Z")

</div>

Hi,

Please have a look at  
[https://wiki.dolibarr.org/index.php/Restores](https://wiki.dolibarr.org/index.php/Restores)  
and how to disable foreign\_key\_checks as well as the troubleshooting paragraph.

Regards,  
Marc