Exporting Dashboards

[blariv]

Hi,

built a latest version nagiosXI server. I have exported everything over but cant figure out if I can export the custom dashboards we created, any ideas?

Thanks!

[npolovenko]

Hello, @blariv. Did you use a backup-restore to transfer everything over to the new server? Or did you manually export the configuration files?
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

[blariv]

I had to do it manually since I went from 2012 to the latest version

[npolovenko]

@blariv, There's no easy way to do this since all dashboards information is stored in the database. So, technically you could dump the database tables and entries from the old system and then reinsert them into the new one. But there's no guarantee that the table structure stayed the same in the new XI. So you risk damaging your new XI database. Here's the MYSQL query to extract the dashboard information from the database:

Code: Select all

echo "select * from xi_usermeta where keyname = 'dashboards';" | mysql -uroot -pnagiosxi nagiosxi

[blariv]

that is not working on the old system.

what are people doing other than recreating all their dashboards?

[root@nagiosxi ~]# echo "select * from xi_usermeta where keyname = 'dashboards';" | mysql -uroot -pnagiosxi nagiosxi
ERROR 1049 (42000): Unknown database 'nagiosxi'

[tgriep]

The old system is probably using the Postgress database so you would have to use this command instead.

Code: Select all

echo "select * from xi_usermeta where keyname = 'dashboards';" | psql nagiosxi nagiosxi

[blariv]

thanks for all the help, you can close this