We recommend that you check the nsas database before upgrading. You can use the mysqlcheck command to verify that the database tables are set up properly. The check can correct some types of problems and can help you avoid an upgrade failure.
This topic describes how to run the check. If the CA Anomaly Detector software is on an upgraded NFA console server or stand-alone server, you may have already checked the nsas database as part of the earlier upgrade.
Checking large database tables can be time-consuming. If you run the check on an entire database, each table in the database is locked in read-only state sequentially. The table that is being checked is unavailable for write operations.
You can run mysqlcheck without stopping the MySQL service.
Follow these steps:
mysqlcheck --all-databases
mysqlcheck --databases db_name
Example:
mysqlcheck --databases nsas
where:
db_name = Name of the database to check
You do not need to specify the path to the database. The mysqlcheck command finds any or all databases that use the default port (port 3308).
The command checks each table, attempts to repair any problems, then analyzes and optimizes the table. The return text lists the database tables that were checked and reports the status for each one.
If the table passed the check, "OK" follows the table name. If a warning is returned and is followed by "OK," the problem was resolved. If unresolved errors occur, contact CA Support.
Next: Stop the services, then back up the databases, as described in the following topics.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|