Restores: Difference between revisions

Restores (view source)

355 bytes added , 8 years ago

m

31,028

edits

@@ Line 48: / Line 48: @@
-[[File:Warning.png]] in any case, '''your sql backup file should disable foreign keys prior to restoring''', else your backup won't be restorable because of foreign keys clashing!
+== Troubleshooting ==
+[[File:Warning.png]] ERROR 1005 (HY000) at line 20: Can't create table `dolibarr`.`llx_accounting_account` (errno: 150 "Foreign key constraint is incorrectly formed")
+=> If you have such error, you mut manually delete the table llx_accounting_account and llx_accounting_system, before trying again.
+[[File:Warning.png]] If you have error with foreign keys, check that '''your sql backup file disable foreign keys prior to restoring''', else your backup won't be restorable because of foreign keys clashing!
 Eg: Add FOREIGN_KEY_CHECKS in headers and footers:
 <source lang="sql">