ERROR - nxdbmgr import - database format version

Started by rmoki, December 04, 2017, 09:04:00 PM

Previous topic - Next topic

rmoki

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 !!

Victor Kirhenshtein

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