NetXMS Support Forum

English Support => General Support => Topic started by: rmoki on December 04, 2017, 09:04:00 PM

Title: ERROR - nxdbmgr import - database format version
Post by: rmoki on December 04, 2017, 09:04:00 PM
Hi,

After installation on a new server I can not import the database from the old server to the new one.

When I try to run nxdbmgr import, I get follow error:

nxdbmgr import /......
NetXMS Database Manager Version 2.1.2 Build 9015 (2.1.2) (UNICODE)

ERROR: Import file was created for database format version 0.404, but this tool was compiled for database format version 21.4
Database import failed.

Execution on the old server nxdbmgr upgrade also does not lead to positive results:

nxdbmgr upgrade
NetXMS Database Manager Version 2.0.5 Build 8070 (UNKNOWN) (UNICODE)

Upgrading database...
Your database format is up to date

OS - Linux DEBIAN 9.2

How can I convert and move the database from the old server to the new one?

Thank you in advance for your answer !!
Title: Re: ERROR - nxdbmgr import - database format version
Post by: Victor Kirhenshtein on December 07, 2017, 10:47:20 AM
Hi,

is it an option to upgrade old server to the last version first? It should simplify migration. Alternatively, you can try to upgrade export file directly (although it may fail) - it is essentially an SQLite database, so you can set your netxmsd.conf to be like this:

DBDriver = sqlite.ddr
DBName = /path/to/export/file

and run nxdbmgr upgrade. Then revert netxmsd.conf to correct settings and try import again.

Best regards,
Victor