Inventory not exported with Hosts
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?
I was not…and that worked like a dream!
Thank you so much!
@treyw00 Are you aware of the DB import/export feature in 1.2.0 ?
FOG Configuration -> Configuration Save -> Import / Export
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…
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…).
mysqldump fog inventory > inventory.sql
mysql -D fog < inventory.sql
You may also use the username and password arguments if necessary.