NetXMS Support Forum

Hello,

I have exported a database from a windows platform (32 bit) and am trying to import the database onto a Ubuntu (32 bit) platform. Both are 1.2.16 using MySQL, when I run the import I receive the following SQL errors:

Importing table raw_dci_values
SQL query failed (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1):
INSERT INTO raw_dci_values (item_id,raw_value,transformed_value,last_poll_time) VALUES ('8600','ô_B•ô_öXw¡4775807','ô_B•ô_öXw¡4775807','1352840681')
ERROR: SQL query "SELECT * FROM raw_dci_values" on import file failed (callback requested query abort)
Database import failed.


I have run nxdbmgr upgrade, check, check-data-tables am at a loss where to go. Any ideas?

I am trying to export my database (currently 1.2.16) and receive the below error:

C:\NetXMS\bin>nxdbmgr export c:\NetXms-2511142.db
NetXMS Database Manager Version 1.2.16 Build 7885

ERROR: Schema version mismatch between dbschema_sqlite.sql and your database. Pl
ease check that NetXMS server installed correctly.
Database export failed.

I have re-installed the lib\SQL file, but these appear to be incorrect (dated 28/7/2014) Are these the correct SQL files for the schema?