Nagios Support Forum

kmsharma wrote: ↑Fri Aug 18, 2023 10:43 pm I was migrating my nagiosxi from ubuntu22.04 to debian10
after moving the backup form old to new server and running restoring script ,I was getting error ,then I ran restore_repair.sh then I was getting database error on browser
"A database connection error has been detected, please follow the repair prompt below. If the issue persists, please contact Nagios support.
Run the following from the CLI as root to attempt to repair the DB:
/usr/local/nagiosxi/scripts/repair_databases.sh"
then i ran the above told script ,then it is giving me an error
"nagios database repair succeeded
nagiosxi database repair FAILED, please check output above!
"/usr/local/nagiosxi/scripts/repairmysql.sh: line 112: pushd: /var/lib/mysql/nagiosxi: No such file or directory
ERROR: Could not change to dir: /var/lib/mysql/nagiosxi""
then i created the given dir structure
and again ran the database repair script
now script output is restored successfully but on browser it is saying
"SQL Error [nagiosxi] : Table 'nagiosxi.xi_cmp_favorites' doesn't exist"
what to do now?

kg2857 wrote: ↑Sun Aug 20, 2023 1:39 am There are a ew posts about missing tables when converting. You might try a search.