migrate cacti from 0.8.7b to 0.8.7i

f3b <[email protected]>
Newsgroups gmane.network.cacti.user
Message-ID <CAC+OyahMA3u3YPhX0dRo26nuE13h60OhbKdE9pZ_K1bZm2anYg@mail.gmail.com>
Hi List,

Can somebody help me we this issue?

I have two Linux servers, one server with Linux distribution based on
debian 5.x and cacti 0.8.7b and the other server  with Ubuntu 12.0.4 with
cacti 0.8.7i from repositories.
I want to migrate from cacti 0.8.7b to 0.8.7i, but the tables in both
versions are different and the table 'VERSION' has different values in both
versions.
cacti 0.8.7b have four tables more than 0.8.7i, the tables are thold,
thold_data, thold_template and tholdset and table VERSION has 0.8.7b.

I tried dump the database of 0.8.7b with the command:
$ mysqldump --compat -t --ignore-table=cacti.thold
--ignore-table=cacti.thold_data --ignore-table=cacti.thold_template
--ignore-table=cacti.tholdset \
--ignore-table=cacti.version -u cactiuser -p cactidatabase > dump.slq

and I tried restore the database in 0.8.7i with command:
$ mysql -u cactiuser -p cactidatabase < dump.sql
but I get the error:
ERROR 1062 (23000) at line 1: Duplicate entry '3' fro key  'PRIMARY'

I have the following questions:
are the tables in both versions equals?
what about 'version' table?
does it store the cacti version?
How to migrate graphs, data and setup from 0.8.7b to 0.8.7i?

Thanks in advanced for any help

fabian
------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013 
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.