Repair Database script does not work on Offloaded DB

[rajasegar]

Repair database script does not work on Offloaded DB.
Please provide a scripts that works.

Thanks

Code: Select all

[nagios@nagiosprodxi1 scripts]$ sudo ./repair_databases.sh
mysqld is stopped
Starting mysqld:                                           [  OK  ]
mysqld (pid  7274) is running...
DATABASE: nagios
TABLE:
/usr/local/nagiosxi/scripts/repairmysql.sh: line 49: pushd: /var/lib/mysql/nagios: No such file or directory
ERROR: Could not change to dir: /var/lib/mysql/nagios
mysqld (pid  7274) is running...
DATABASE: nagiosql
TABLE:
/usr/local/nagiosxi/scripts/repairmysql.sh: line 49: pushd: /var/lib/mysql/nagiosql: No such file or directory
ERROR: Could not change to dir: /var/lib/mysql/nagiosql
Stopping ndo2db: done.
Starting ndo2db: done.
Running configuration check...done.
Stopping nagios: .done.
Starting nagios: done.

[tgriep]

You can use the following command below to repair the Mysql databases. Run it from the XI server.
Replace <user>, <password> and xxx.xxx.xxx.xxx with the correct information for your server.

Code: Select all

mysqlcheck -f -r -u <user> -p<password> --databases nagios nagiosql -h xxx.xxx.xxx.xxx

[rajasegar]

You can use the following command below to repair the Mysql databases. Run it from the XI server.
Replace <user>, <password> and xxx.xxx.xxx.xxx with the correct information for your server.

Code: Select all

mysqlcheck -f -r -u <user> -p<password> --databases nagios nagiosql -h xxx.xxx.xxx.xxx

Ok. Thanks.
Ideally the repair script should pick all this up automatically from the relevant xml files.

Anyway please close this case.