|
|
| Author |
Message |
msw1970 Cacti User
Joined: 09 Jan 2007 Posts: 153
|
Posted: Thu Mar 08, 2007 5:16 am Post subject: Device Types |
|
|
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??
|
|
| Back to top |
|
 |
TheWitness Developer
Joined: 14 May 2002 Posts: 9671 Location: MI, USA
|
Posted: Thu Mar 08, 2007 8:34 am Post subject: |
|
|
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
|
|
| Back to top |
|
 |
msw1970 Cacti User
Joined: 09 Jan 2007 Posts: 153
|
Posted: Thu Mar 08, 2007 8:53 am Post subject: |
|
|
| 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
|
|
| Back to top |
|
 |
TheWitness Developer
Joined: 14 May 2002 Posts: 9671 Location: MI, USA
|
Posted: Thu Mar 08, 2007 8:01 pm Post subject: |
|
|
Absolutely. You need to restore from your last backup.
TheWitness
|
|
| Back to top |
|
 |
lavermil
Joined: 15 Feb 2007 Posts: 45 Location: Phoenix, Arizona
|
Posted: Mon Mar 12, 2007 11:47 am Post subject: |
|
|
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
| Description: |
|
 Download |
| Filename: |
mactrack-device-types_sql.txt |
| Filesize: |
7.88 KB |
| Downloaded: |
303 Time(s) |
|
|
| Back to top |
|
 |
|