Import database backup file

Started by CrUser, September 08, 2017, 07:38:03 PM

Previous topic - Next topic

CrUser

Hi,

I need help with importing database file into new NetXMS database.
I have followed instruction to create database backup with instruction nxdbmgr export export_file.
Export file has created without error but in proces of importing  this file into fresh NetXMS database i have got error:

"SQL query failed (Incorrect integer value: "" for column 'port_rows'. I have put complete error message in attachment.
Obviously, something is wrong with database data but application is working fine without any error or warning for this node.
If anybody have advice what can I do to avoid this importing error please help me.

Thanks,
Tomislav


Victor Kirhenshtein

Hi,

what NetXMS version you are using and what database?

Best regards,
Victor

CrUser

Hi Victor,

Thank you for you replay.

I use MySQL database and NetXMS version 2.1.

Tomislav

Victor Kirhenshtein

Hi,

that's a bug in export/import procedure. I registered it in our issue tracker: https://track.radensolutions.com/issue/NX-1330

Best regards,
Victor