McAfee M-1250 Upgrade Guide - Page 40

4 Upgrading the Manager Stand-alone Manager upgrade 11 Log on to the Manager. You can verify the version on the Log on page. 12 Check the Status page to ensure that the Manager database and the Sensors are up. Now upgrade the signature set and the Sensor software. See Performing Signature Set and Sensor Software Upgrade. Tasks • Running additional scripts on page 40 See also Reviewing the upgrade requirements on page 31 Reviewing the Upgrade Considerations on page 33 Backing up Network Security Platform data on page 25 MDR Manager upgrade on page 36 Running additional scripts on page 40 Performing Signature Set and Sensor Software upgrade on page 3 Running additional scripts When you install the 6.0 Manager, if there are 1 million or more, alerts or host events, in your current Manager setup, you will be prompted to run two SQL scripts as described below. Run alertproc_offline_1.sql and alertproc_offline_2.sql only if prompted to do so. The system prompts you only when there are 1 million or more, alerts or host events, in the Manager database. If you run these scripts when not prompted, you will receive SQL errors. In this case, contact McAfee Technical Support with the details of the message. Ensure that you run the sql scripts soon after the Manager upgrade is complete. McAfee recommends that you select a relatively idle time to run the scripts to minimize the impact on performance. Task 1 After a successful upgrade of the Manager to 6.0, check that it is up, Sensors are connected, and alerts are generated. 2 Log in to MySQL by running: \mysql\bin\mysql -u usr -ppwd -D db_name 3 In the MySQL shell, run: mysql>source /db/mysql/migrate/alertproc_offline_1.sql If an SQL error message is displayed, stop proceeding further and contact McAfee Technical Support with the details of the message. 4 Shut down the Manager. 40 McAfee® Network Security Platform 6.1 Upgrade Guide