Device Types

msw1970 · Post by **msw1970** » Thu Mar 08, 2007 5:16 am

Hi

Since upgrading our test cacti to the SVN version of mactrack, I appear to have lost all of my device types.

Is there anyway of getting them back??

Post by **TheWitness** » Thu Mar 08, 2007 8:34 am

Restore your latest backup to a separate database, export the appropriate table using something like MySQL Query Browser to a CSV and then import using the new Device Type import function.

Interested in "how" they got wiped though.

TheWitness

msw1970 · Post by **msw1970** » Thu Mar 08, 2007 8:53 am

TheWitness wrote:Restore your latest backup to a separate database, export the appropriate table using something like MySQL Query Browser to a CSV and then import using the new Device Type import function.

Interested in "how" they got wiped though.

TheWitness

The table contents don't appear to be in the SVN version of mactrack.sql.

I removed all the old tables on the test database before upgrading and starting again and then ran mysql test_cacti < mactrack.sql so I guess that's how I lost them

Post by **TheWitness** » Thu Mar 08, 2007 8:01 pm

Absolutely. You need to restore from your last backup.

TheWitness

lavermil · Post by **lavermil** » Mon Mar 12, 2007 11:47 am

I am fairly sure the reason he lost them all is because he didn't install the original version of mactrack from cactiusers.org. Once that is done and then upgrade, if I recall correctly, everything goes ok.

Anyhow in case anyone is interested. Here is an export of the device types. This is in SQL (4.1.10a) format

Cacti

Device Types

Device Types

Who is online