exporting

[lindeamon]

hi,

i am using netxms 1.1.9 with postgre sql on a linux platform.
i have scripts in my script library and i have object tools and i have other places with configuration that i cannot export.
i have deleted all the nodes and now i want to export it.
i have invoked "nxdbmgr export netxms.db" and it worked fine but it exported all the idata and names and ip address that i did not want to export.
i have invoked "nxdbmgr init netxms.db" and stopped giving an error with sqlite.

what is the correct way to export the db ?

Lindeamon

[lindeamon]

hi,

i have "vacuumed" the DB and then i have invoked "nxdbmgr check" and it indeed got rid of every "idata" and every node that i have deleted but...
i think that the snmp log and the event log were not cleand.

what is the next step ?

Lindeamon

[lindeamon]

hi victor,

i have opened the DB and started cleaning everything that i did not wanted.
basically i want the "object tools", "script library", "agent config" and "event rules", all of the customized config that aren't exportable.
what will happen if i delete all the unwanted tables in the DB and leave those i want and do an import ? will it work ? will i have to do this with the same version of netxms and afterwords upgarde to later release.

Best Regards,
Lindeamon

[victor]

Hi!

For successful import, you should keep tables, but just delete all content. Otherwise import will fail. You can delete all idata_* tables. You should do import using same version of NetXMS as you use for export.

Best regards,
Victor

[lindeamon]

thank you very much

Best Regards,
Lindeamon

[lindeamon]

hi victor,

should i delete what in the metadata table too ?

Best Regards,
Lindeamon

[victor]

Hi!

No, if you delete metadata nxdbmgr will not be able to handle import file. Please also note that during import target database is cleared before import.

Best regards,
Victor

[lindeamon]

what do you meen by "cleared" ? everything is deleted or just customized info ?
what will happen if the only info i left is the info i have created meening i have cleared all the info that the setup and the program creates.
wanted to give you an example. lets say that i have cleared everything in the event_policy table leaving only the events i created,when i do an import it will delete the default rows created by the system and leave only what was imported ?

Best Regards,
Lindeamon

[victor]

Everything is deleted, so you cannot import some data into existing database using nxdbmgr. Only full database import.

Best regards,
Victor

[lindeamon]

ok,
if i leave the defaults created by the software and only what i want it will be ok ?
won't it destroy the indexing and the "id's" and etc. that have been created automatically ?

Best Regards,
Lindeamon

[victor]

Yes, leaving default data and data you need should be ok.

Best regards,
Victor

[lindeamon]

i have came accross var_name called "ServerID" in the config table.
when it is created ? what will happen if i leave it as is from the backed up server ? what will happen if i change it ?

Best Regards,
Lindeamon

[lindeamon]

hi victor,

the whole thing is too risky.
i have exported everything i could using the old console and what i could not export i am going to leave in the exported file.
in the new server i will open the DB and copy/paste the values,it seems more safe this way.
we have to have a normal and easy way to export everything we have created.

Best Regards,
Lindeamon