[SOLVED] MySQL temp files on root (t12a.1 etc)

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

[SOLVED] MySQL temp files on root (t12a.1 etc)

Post by Chris Corbyn »

MySQL puts two temporary files on C:\ called something along the lines of t12a and t12a.1 (filename changes eac time the service starts).

How can i make these move somewhere else like C:/mysql/tmpfiles/
I tried putting
tmpdir=C:/mysql/tmpfiles/
in my.ini but it didn't work

I'm just an awkard s*d and like my PC looking tidy ;-)
Last edited by Chris Corbyn on Sat Feb 12, 2005 3:33 pm, edited 1 time in total.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

Cheers feyd but I tried
tmpdir=C:/Tmp/
and
Server=C:/PHP/mysql/bin/mysqld.exe --tmpdir=C:/Tmp/
But neither method works... I still get soem files in C:\ when the service is running.... It doesn't really matter... I'm only tidying up... mysql is working fine so I shouldn't really be playing with the ini settings ;-)
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

I'm reading on the mysql website and it's a known bug with Windows..

I'm using a beta version so I'll try getting the newest finished version and see if it fixes....
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

alreet.... solved this by just getting a newer version...

If anybody is using mysql-4.0.20 beta and has the same problem your fix is to get another version... there's a bug with it ;-)
Post Reply