Restore mysql db w/ err 1022 (duplicate key)

Hi,

I am trying to migrate a 4.0.4 installation from go daddy to google cloud bitnami image but got the following error:
ERROR 1022 (23000) at line 310: Can’t write; duplicate key in table ‘doli_adherent’

I have searched wiki and try to disable the foreign key check but no luck:
https://wiki.dolibarr.org/index.php/Restores

Hope someone can help. THANKS.

BR,
Tony

Problem solved. Due to different database prefixes.