How to change the MySQL temporary directory path
Article ID: 41456
Updated On:
Products
Issue/Introduction
Introduction/Summary:
On Windows, MySQL uses in order the values of the TMPDIR, TEMP, and TMP environment variables as the path name of the directory in which to store temporary files. For the first one found to be set, MySQL uses it and does not check those remaining. If none of TMPDIR, TEMP, or TMP are set, MySQL uses the Windows system default, which is usually C:\windows\temp\.
Background:
Customer can change the path name of the directory in which to store temporary files by editing the my.ini config file.
Environment:
CA Application Delivery Analysis
CA Network Flow Analysis
CA Unified Communications Monitor
Instructions:
You can modify the temporary directory for MySQL by editing the my.ini configuration file. Then you can go and exclude that temporary directory from AV scan.
1. Edit the file <Install>\CA\MySql\my.ini 2. Under [mysqld] add the following line where the custom directory for example is C:\mysqltemp and save file:
tmpdir = C:/mysqltemp
3. Restart CA Mysql service under Windows services
4. Verify that the changes have taken effect by typing the following commands from the Windows prompt:
mysql
SHOW VARIABLES LIKE 'tmpdir';
Environment
Component:
Feedback
