Dolibarr 10.0.5 Database Migration (Import) Failing

Maintaining my Dolibarr
, ,
1

Hi Team:

Having some difficulty importing my database into a fresh install, getting this error on import:

ERROR 1005 (HY000) at line 460: Can’t create table dbname.llxc7_adherent (errno: 121 “Duplicate key on write or update”)

Deleting the table from the import file just creates the exact error on a table later on - Any ideas?

I used defaults in Admin - Backup - Dump.

Original GIT Install (Metal) 10.0.5: Ubuntu / MariaDB - MySQL or MariaDB 5.5.5-10.0.38-MariaDB-0ubuntu0.16.04.1
New GIT Install (VM) 10.0.5: Debian/MariaDB - MySQL or MariaDB 5.5.5-10.5.19-MariaDB-0+deb11u2

2

Try to delete all existing tables or start import on an empty database.

3

Hi acriqui

The import and use of imported database tables only works with identical program versions
Your new version of Dolibarr must have the same version as your existing one, otherwise errors may occur

Update your existing Dolibarr version to the same version as your new Dolibarr installation.
Then download the database of the existing ones.
Import the downloaded DB file into your new Dolibarr installation

reg Scalar

4

This was the fix.

Thanks gents.