NetXMS Support Forum

seems a bug in nxdbmbr yet exists.

1) https://www.netxms.org/forum/general-support/database-export-failed-gt-v-1-2-0-error-cannot-load-schema-file-windows-2008-r2/
2) https://www.netxms.org/forum/general-support/export-cannot-load-schema-file

i'm use mysql

this not work
C:\NetXMS_new\bin>nxdbmgr export c:\netxmsbase.sql
NetXMS Database Manager Version 1.2.0

ERROR: cannot load schema file "C\lib\sql\dbschema_sqlite.sql"
Database export failed.

and this not work too
C:\NetXMS_new\bin>nxdbmgr export c:/net.sql -c c:\netxms_new\etc\netxmsd.conf
NetXMS Database Manager Version 1.2.0

ERROR: cannot load schema file "C\lib\sql\dbschema_sqlite.sql"
Database export failed.
if i create path "C\lib\sql\", it not work again.

i'm use this way

on old srv (win)
mysqldump my_database --user=username --password=my_password > my_base.sql

on new srv (freebsd)

mysql -u username -pPassword
USE My_base
SOURCE MY_base.sql
exit;

nxdbmgr update
nxdbmgr check


but it didn't work

:26:53] Log file opened
:26:53] Platform subagent "/usr/local/lib/libnsm_freebsd.so" successfully loaded
:26:53] Database driver "mysql.ddr" loaded and initialized successfully
:26:53] Data directory "C:\NetXMS_new\NetXMS\var" does not exist or is inaccessible



how i can fix this? It old setting in database (

Hi!

Add parameter DataDirectory = path to your netxmsd.conf. It should override setting in database.

Best regards,
Victor

Quote from: Victor Kirhenshtein on July 25, 2012, 03:27:45 PM
Hi!

Add parameter DataDirectory = path to your netxmsd.conf. It should override setting in database.

Best regards,
Victor

thank, it works.

Maybe need add some ability in nxdbmgr?
-reset config in database? or overwrite
-reset account?

Yes, it could be useful. I'll add it as low priority feature request.

Best regards,
Victor