[RESOLVED] Change the value of the tmpdir variable

reeksy

Hi all

I'm running MySQL 4.0.12 and i need to change the value of the tmpdir variable due to permission issues. Does anyone know how and where to do this!? I've been scratching my head with this one all morning. I'm running WinXP.

Regards,
Jon

bradgrafelman

Have you already read this page of the MySQL manual?

You should be able to specify the tmpdir option in your my.cnf/my.ini config file.

reeksy

Hi bradgrafelman.

Thanks for the reply. I have had a look at the documentation but even when i put the following line in my 'my.ini' the variable value still doesn't change:

my.ini

tmpdir=C:\WINDOWS\temp_mysql\

If i then run the following statment in MySQL

SHOW VARIABLES LIKE 'tmpdir';

'C:\WINDOWS\TEMP\' is returned.

Any ideas?

Also does anyone know if the tmpdir variable is global or on a per-database level?

Regards,
Jon

Joseph07

Do you mean the upload tmp directory? You have to change it in php folder/php.ini

Look for this line. upload_tmp_dir

And change to the directory you want.

reeksy

Hi Joseph07.

No it's not the upload tmp directory. This is strictly a MySQL issue rather than PHP.

MySQL accesses temporary MYD files within it's defined temporary directory. However these files are being accessed by a virus scanner which locks and scans the MYD file when they are opened. If the MYD files are large enough the virus scanning application and MySQL bump into each other causing intermittent (fatal) errors.

Regards,
Jon

Joseph07

I see. My wrong for interpreting wrongly.

I'm not that good with mySQL, hope that you can get the answer soon.

bradgrafelman

The tmpdir variable, if not specified, will default to your system's default temporary folder (the 'TEMP' folder in your Windows folder, obviously).

To specify the tmpdir variable, make sure you add it to your my.ini file after the [mysqld] header. For instance, I have:

[mysqld]
old_passwords=1

# The TCP/IP Port the MySQL Server will listen on
port=3306

#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 5.0/"

#Path to the database root
datadir="X:/web/mysql/data/"

tmpdir="X:/web/mysql/tmp/"

After you add that variable under the mysqld header, make sure you restart your MySQL server.

reeksy

Perfect. Thanks for the resolution.