Inventory not exported with Hosts

[treyw00]

Hi,

I exported all my hosts to a new Fog Server (both were running 1.2.0) and the Hosts imported correctly, yet the Inventory wasn’t included for any of the machines. Is there a way to transfer the inventory information?

Thanks

[Wayne Workman]

Export:

 mysqldump fog inventory > inventory.sql

Import:

mysql -D fog < inventory.sql

You may also use the username and password arguments if necessary.
Reference: https://steveswanson.wordpress.com/2009/04/21/exporting-and-importing-an-individual-mysql-table/

[Tom Elliott]

Inventory is stored 100% separate from the rest of the items.

There are many tables stored in such manner. All the export cares about at that point is the data of the given object (hosts->hosts, not hosts->inventory,groups,snapins,etc…).

[treyw00]

soooo good news / bad news…

Good news is, I got the export/import of the sql data to work…bad news is, it didn’t match up to the devices correctly…

[Wayne Workman]

@treyw00 Are you aware of the DB import/export feature in 1.2.0 ?

FOG Configuration -> Configuration Save -> Import / Export

[treyw00]

I was not…and that worked like a dream!

Thank you so much!