Migration NagiosXI

[dferrero]

Hello,

I have a CentOS 7 server with NagiosXI 5.11.1 installed and I'm trying to migrate it to an Ubuntu 22.04.4 with a clean NagiosXI 5.11.1 in it. I've made a backup in the original machine, copied it in the other one, and following Nagios' official guide, repaired the restore using this script: "https://assets.nagios.com/downloads/nag ... _repair.sh".
I get this error every time I try to run it (note that "password" is a random password I've chosen and not the original MySQL root password, in case that matters). Also the database is a MariaDB 5.5.68.


> Creating database with user
> Enter MySQL root password: "password"
> Using command line supplied credentials for account/db creation...
> Username: ndoutils
> Password: *****
> Database: nagios
> Press <ENTER> to continue...
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1007 (HY000) at line 1: Can't create database 'nagios'; database exists
Something went wrong creating database 'nagios'
Finished restore repair OK

Any ideas?
Thanks!

[jsimon]

Hi @dferrero,

Reading the steps you took from your post, it seems like you may have run the restore_repair script before restoring your backup. I believe you need to run the restore_xi script mentioned in the "Backing Up and Restoring Nagios XI" document first, and then you'll be able to continue the process from there. Please let us know if you have any more issues with this, or if I'm wrong in my assumption!

[ssunga]

Link to suggested document: https://assets.nagios.com/downloads/nag ... ios-XI.pdf