Re: migrate cacti from 0.8.7b to 0.8.7i

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

_______________________________________________
cacti-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/cacti-user

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBCAAGBQJREr4QAAoJEJxcmesFvXUKKqEH/RirDinJuJSbCWivITfEHX6x
WpaXPvgpmN25TGvJTPaUFghJXs7wD1wcnlXKlcHEFQYp7s2DLKWBw+9nXXZuhRhv
o7jsqmy8InpMyfDAsu4S3PtMokQziZLZxVmrGcH7rZkHAKIu8FMOl6AdKdgfYO7m
J0Wr5G8erKJtWyEhGq4ztJrr/TL9xFfvTHzPjudDJywwbPEMysJNkcnbqgveFmWT
cI8KHLBObz23LX7k5d+cineaxf9klpdRNA2fBFik1yxfjTlIjfF6LhR1ZQRCpajz
YG6GoHOCnY35cPy96pdwuymu4svkvmZGh6+UPT+wLrmtRkpZbWSht2oUt+/22eg=
=ZpoH
-----END PGP SIGNATURE-----