Re: migrate cacti from 0.8.7b to 0.8.7i

Hi Paul,

Many, many  thanks for your help.
In my case, I have logged in cacti and I didn't follow the upgrade link.
I understand that I should dump & restore the database and then log in in
cacti.
Should I search and follow the upgrade link? or only log in
Does it preserve the new version and web interface for new version?
Is compatible cacti database version 0.8.7b with cacti web interface 0.8.7i?
I want to lost new features of cacti 0.8.7i.
I have disabled the cacti's cron in new server.

Thanks in advanced
fabian


On Wed, Feb 6, 2013 at 3:33 PM, Paul Gevers <[email protected]> wrote:

> Hi,
>
> The best way is to NOT try to fix things yourself in the database. Just
> copy the full database and follow cacti's directions after you log in.
> Cacti has update scripts incorporated for all 0.8.7 releases.
>
> Of course you should still copy the rrd files appropriate. Please find
> the migration pages in the FAQ/docs section of the web-site.
>
> Paul
>
> On 06-02-13 21:09, f3b wrote:
> > 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
> > _______________________________________________
> > cacti-user mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/cacti-user
> >
>
>
>
>
------------------------------------------------------------------------------
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