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
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