Print Page - Import database backup file

Title: Import database backup file
Post by: CrUser on September 08, 2017, 07:38:03 PM

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

Title: Re: Import database backup file
Post by: Victor Kirhenshtein on September 19, 2017, 09:41:07 PM

Hi,

what NetXMS version you are using and what database?

Best regards,
Victor

Title: Re: Import database backup file
Post by: CrUser on September 21, 2017, 10:56:19 AM

Hi Victor,

Thank you for you replay.

I use MySQL database and NetXMS version 2.1.

Tomislav

Title: Re: Import database backup file
Post by: Victor Kirhenshtein on October 04, 2017, 11:23:17 PM

Hi,

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

Best regards,
Victor

NetXMS Support Forum

English Support => General Support => Topic started by: CrUser on September 08, 2017, 07:38:03 PM