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