SQL Error [nagiosxi] : Table 'nagiosxi.xi_cmp_favorites' doesn't exist

[kmsharma]

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?

[kmsharma]

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?

PLEASE HELP ME IN FINDING SOLUTION FOT THIS

[kg2857]

There are a ew posts about missing tables when converting. You might try a search.

[kmsharma]

There are a ew posts about missing tables when converting. You might try a search.

I searched but havnt got the solution.

[swolf]

Hi @kmsharma,

It looks like this is the same problem as viewtopic.php?t=65867 - it doesn't help anyone if the details around your singular problem are spread out across 4-5 threads. I'm going to lock this thread; I recommend that you continue to update the thread that's already open.

-Sebastian Wolf