For steps on checking and repairing the Brightmail MySQL database, go to the section for the operating system installed.

If you use Brightmail AntiSpam 6.02, the user account was changed and the default password is now auto-generated and stored in the server.xml file.
For more information see "Access MySQL with brightmailuser Account Instead of root" in the section titled "Important Additions and Changes to Consider, Version 6.0.2" in Release Notes for Symantec Brightmail AntiSpam for Sendmail 6.0.2.

To obtain the password read Determining your MySQL user name and password for Symantec Brightmail 6.0.x or Symantec Mail Security 5 for SMTP product.

To check and repair the Brightmail MySQL database when using Windows

1. On the Windows taskbar, click Start > Run.
2. In the Open box, type the command:
   cmd.exe
    
3. Press Enter.
4. Change to the MySQL\bin folder.
   By default it is on drive C.
5. At the command prompt, type the command that applies to your version:
   • Symantec Mail Security 5 for SMTP
     
     The command is run from the directory location:
     C:\Program Files\Symantec\SMSSMTP\MySQL\Bin
     
     mysqlcheck -ubrightmailuser -p<paste password here> brightmail --auto-repair
     
     Replace <password> with the value found in the .brightmailuser file. The .brightmailuser file is located in the following directory by default:
     C:\Program Files\Symantec\SMSSMTP\
      
   • Symantec Brightmail version 6.0.2 or later
     The command is run from the directory location:
     C:\MySQL\bin folder
     
     mysqlcheck --auto-repair -ubrightmailuser -p<password> brightmail
     
     Replace <password> with the value found in the server.xml file. The server.xml file is located in the following directory by default:
     C:\Program Files\Symantec\SBAS\ControlCenter\Tomcat\jakarta-tomcat-4.1.27\conf\
      
   • Symantec Brightmail versions 6.0 and 6.0.1
     The command is run from the directory location:
     C:\MySQL\bin folder
     
     mysqlcheck --auto-repair -uroot -pbrightmail brightmail > check.txt
     
     There are two dashes before auto in the above command. This repairs the corrupted tables and outputs the results to the file Check.txt. The time to output the results to the file check.txt depends on the size of the MySQL database. The larger the database, the longer the time.
      
6. Press Enter.
7. Exit the command prompt.

To check and repair the Brightmail MySQL database when using Linux

1. Open a command prompt.
2. At the prompt type the following command to change to the correct MySQL/bin directory:
   cd /opt/symantec/sbas/ControlCenter/MySQL/Mysql-pro-4.0.16-pc-linux-i686/bin
   
   Change the above default path to where MySQL installed if the installation is in another location.
3. If the status check returns an error, type the command that applies to your version, and then press Enter:
   • 6.0.2 or later
     ./mysqlcheck -h127.0.0.1 --auto-repair -ubrightmailuser -p<password> brightmail > check.txt
     
     Replace <password> with the value found in the server.xml file. The server.xml file is located in the following directory by default:
     /opt/Symantec/SBAS/ControlCenter/Tomcat/jakarta-tomcat-4.1.27/conf/
      
   • Versions 6.0 and 6.0.1
     ./mysqlcheck --auto-repair -uroot -pbrightmail brightmail > check.txt
     
     There are two dashes before auto in the above command. This repairs the corrupted tables and outputs the results to the file Check.txt. The time to output the results to the file check.txt depends on the size of the MySQL database. The larger the database, the longer the time.
4. Exit the command prompt.

To check and repair the Brightmail MySQL database when using Solaris

1. Open a command prompt.
2. At the prompt, type the following command to change to the MySQL/bin directory:
   cd /opt/symantec/sbas/ControlCenter/mysql-pro-4.0.16-sun-solaris2.8-sparc/bin
   
   Change the above default path to where MySQL installed if the installation is in another location.
3. If the status check returns an error, type the command that applies to your version, and then press Enter:
   • Version 6.0.2
     ./mysqlcheck -h127.0.0.1 --auto-repair -ubrightmailuser -p<password> brightmail > check.txt
     
     Replace <password> with the value found in the server.xml file. The server.xml file is located in the following directory by default:
     /opt/Symantec/SBAS/ControlCenter/Tomcat/jakarta-tomcat-4.1.27/conf/
      
   • Versions 6.0 and 6.0.1
     ./mysqlcheck --auto-repair -uroot -pbrightmail brightmail > check.txt
     
     There are two dashes before auto in the above command. This repairs the corrupted tables and outputs the results to the file Check.txt. The time to output the results to the file check.txt depends on the size of the MySQL database. The larger the database, the longer the time.
4. Exit the command prompt.

References
 

Determining your MySQL user name and password for Symantec Brightmail 6.0.2 or later
Scheduling a check of the Quarantine Database and Control Center database on a computer with a supported Linux operating system



Technical Information
In the event a MySQL database repair does not correct the problem, a list of corrupted tables is given. You can then use try running a repair on each table listed. The command:
mysql -ubrightmailuser -p<password> brightmail REPAIR TABLE brightmail <tablename>

Additional information go to 13.5.2.6 REPAIR TABLE Syntax.