|
|
| Author |
Message |
jjames
Joined: 21 Nov 2008
Posts: 2
|
 Posted: Fri Nov 21, 2008 10:50 am Post subject: Migrating data from two Cacti servers to a new one |
 |
|
All are running Debian-based OSs (the new one is Ubuntu 8.10 Server).
What I'd like to be able to do is migrate the managed devices, and the associated graphs to the new box from two older ones. The actual data is less important than the graphs themselves.
Not really wanting to enter them manually I have been trying to work out how to do this scripted, by extracting the relevant data from the SQL database. Without much success it has to be said lol. I have the devices ready to enter to the new system but not their graphs.
I'm not an expert by any stretch of the imagination with SQL but I'm pretty sure that the procedure is not as simple as an ordinary migration -- the two databases would have to be merged which presumably would mean that everything would have to be re-indexed.
Is there a straightforward way of achieving this? Thanks. |
|
| Back to top |
|
 |
khufure
Cacti User
Joined: 24 Oct 2007
Posts: 164
Location: San Francisco, CA
|
| Posted: Fri Nov 21, 2008 2:35 pm Post subject: Re: Migrating data from two Cacti servers to a new one |
|
|
| jjames wrote: | All are running Debian-based OSs (the new one is Ubuntu 8.10 Server).
What I'd like to be able to do is migrate the managed devices, and the associated graphs to the new box from two older ones. The actual data is less important than the graphs themselves.
Not really wanting to enter them manually I have been trying to work out how to do this scripted, by extracting the relevant data from the SQL database. Without much success it has to be said lol. I have the devices ready to enter to the new system but not their graphs.
I'm not an expert by any stretch of the imagination with SQL but I'm pretty sure that the procedure is not as simple as an ordinary migration -- the two databases would have to be merged which presumably would mean that everything would have to be re-indexed.
Is there a straightforward way of achieving this? Thanks. |
No. You could do one but not two without serious hacks. If I were you I'd invest your time into using the CLI (command line interface) tools to create new devices for you. |
|
| Back to top |
|
|
gandalf
Developer
Joined: 02 Dec 2004
Posts: 12642
Location: Muenster, Germany
|
| Posted: Sat Nov 22, 2008 5:58 am Post subject: |
|
|
Strongly agrred with
Reinhard |
|
| Back to top |
|
|
jjames
Joined: 21 Nov 2008
Posts: 2
|
| Posted: Sat Nov 22, 2008 3:12 pm Post subject: |
|
|
Yeah, thankd for the replies.
Talking to the resident Linux experts at work I came to more or less the same conclusion -- the way I think I am going to approach this is to migrate one of the databases, print out the graphing details for each device from the other, create the devices for the second device using the CLI (I have a piece of C code that can help with this) and then enter the graphs manually.
Looks like I have my work cut out  |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
