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