Lost hosts after migrating.

linuxman1 · Post by **linuxman1** » Sun Sep 05, 2010 6:16 am

I migrated a Cacti installation to another server and it went fine except there are some hosts after some days we discovered it were not there on the new system, What I missed when I migrated the Cacti, Mysql tables or some old Cacti files or what cause the loss of some hosts were there on the cacti web interface?

Post by **gandalf** » Sun Sep 05, 2010 11:43 am

The required procedure is to
- copy the code
- mysqldump and restore cacti db
- rrdtool dump and restore the rrd files
That's it. If you did that, please verify, that the "missing" hosts were available before. For polling errors, please see 2nd link of my sig
R.

linuxman1 · Post by **linuxman1** » Mon Sep 06, 2010 3:11 am

Thanks for helping, When I migrated Cacti from a Debian system to another I migrated the Mysql data bases and it's web directory which is /usr/share/cacti/site and the rrd files which reside in /var/lib/cacti/rra/
So do you see I missed something, By the way I found the old graphs rrd files for the hosts we missed in /var/lib/cacti/rra/ but we lost the hosts them selves on the web interface, I still have backups from the old system and wish to restore the lost hosts, What should I do and I want to be careful so I don't miss any new added or modified hosts we may added.

Post by **gandalf** » Mon Sep 06, 2010 4:42 am

linuxman1 wrote:When I migrated Cacti from a Debian system to another I migrated the Mysql data bases

How did you do? mysqldump and restore?
R.

linuxman1 · Post by **linuxman1** » Mon Sep 06, 2010 7:40 am

Although I know it wasn't the best method to do so, I stopped the Mysql service and copied the data a cross the network using scp, and then started the Mysql service on the new system, I just missed some hosts and most of hosts were there OK. I still have other backups and the whole old hard disk containing the old setup, Do you see to restore the data bases again from the old system using a better way?

Post by **gandalf** » Fri Sep 10, 2010 3:32 pm

Yep. It's not better, it's REQUIRED.
Please dump the database using mysqldump. Then restore again. See e.g. http://docs.cacti.net/manual:087:4_help ... _logrotate
R.

linuxman1 · Post by **linuxman1** » Tue Sep 14, 2010 4:20 am

Thanks for the help,
I have a problem, I don't want to restore the data bases from the old as I will lost any new changes since the last backup, So I want to restore only the difference between them, Can you help.

Post by **gandalf** » Tue Sep 14, 2010 10:13 am

In case you do not have access to the "old" mysql tables, I can't help
R.

linuxman1 · Post by **linuxman1** » Wed Sep 15, 2010 2:25 am

I have access to it, Help me on how to restore it without losing any new changes may happened to the new data bases.

Post by **gandalf** » Thu Sep 16, 2010 2:52 pm

Are they still available to mysql (e.g. "show databases;" shows them) or only as files?
R.

linuxman1 · Post by **linuxman1** » Wed Sep 22, 2010 3:35 am

Yes I have it, It's intact. How I may restore it without overwriting any new records.

Cacti