search cancel

How to change the MySQL temporary directory path

book

Article ID: 41456

calendar_today

Updated On:

Products

CA Application Delivery Analysis MTP (NetQoS / ADA)

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

Release: SAMCNS99000-10.2-NetQoS-SuperAgent-Management Console
Component: