Tables fail to load when Windows Indexer or antivirus program accesses temporary MySQL files

During the table-loading phase, MySQL makes temporary files. If Windows Indexer is running, or your antivirus program is running a real-time scan, these programs may try to access your temporary MySQL files, locking them, and causing table loading to fail.

Workaround:Create a separate directory to contain temporary MySQL files, and then:

1. Configure Windows Indexer or the antivirus software to ignore the directory.
2. Access the non-default MySQL configuration file, located at: <Server_install>/config/kwmysql.ini
3. In the kwmysql.ini file, add: tmpdir=<path_to_exempt_directory>
   Note: Backslashes should be doubled when specifying a Windows folder path. Windows example:"C:\\temp\\exempt"
4. Restart the Klocwork Database Server.