NetXMS Forum

FYI, we stripped the data from inside the database and that removed the illegal characters. The (shell) database then loaded successfully and we were able to use the database, although all of the historic values were missing (we had stripped them)). Could this be something to do with the export/import function?

Hello Victor,

The NetXMS was compiled on the server using the source code download - netxms-1.2.16.tar.gz

Thank you for your reply,

Yes both Databases are using Latin1_swedish_ci as the collation and Latin1 as Characterset

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?

OK, so I downloaded the source files for 1.2.16 and copied the dbschema_sqlite.sql (dated 4/8/14) into the SQL directory and the Export worked :O)

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?