Error in migration
Posted: Fri Aug 18, 2023 10:18 pm
I was trying to migrate my nagios xi from "ubuntu22.04" to "debian 10"
I took the backup on old server and copied my backup from old server to new serrver ,then untar it in new server and ran the restore script .
it is giving me an error saying database restore failed
I ran the script restore_repair.sh
then I was getting error on web browser "Database Error
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 script and I was getting
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"
what to do now to migrate from old server to new server of diff OS?
I took the backup on old server and copied my backup from old server to new serrver ,then untar it in new server and ran the restore script .
it is giving me an error saying database restore failed
I ran the script restore_repair.sh
then I was getting error on web browser "Database Error
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 script and I was getting
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"
what to do now to migrate from old server to new server of diff OS?