Hi all,
I'd like to migrate to newer database server. Learned that I should use nxdbmgr export and then import. Thing is I'd prefer not migrate any old collected data (because I don't need that history in DB), just configuration and etc. needed table from database.
My bigest table was 'syslog' which is easy to recognize and I cleared it using truncute under mysql.
But there are many tables 'idata_*' and 'tdata_rows_*' and I don't know which are safe to clear / delete from / truncate.
Is there any tool (or help) which can migrate or export only configuration related data from mysql?
Thanks in advance
.t
nxdbmgr -h
...
Valid commands are:
...
migrate <source> : Migrate database from given source
...
Valid options are:
...
-s : Skip collected data during migration or export.
Backup your old config file to for example "netxmsd.conf.old".
Configure your "netxmsd.conf" with new database.
Then run: "nxdbmgr -s migrate netxmsd.conf.old"
I see.
tried export / import with -s
thanks