Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098 Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia
Post
by Chris Corbyn » Sat Feb 12, 2005 2:23 pm
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.
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Sat Feb 12, 2005 2:30 pm
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098 Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia
Post
by Chris Corbyn » Sat Feb 12, 2005 2:59 pm
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
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098 Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia
Post
by Chris Corbyn » Sat Feb 12, 2005 3:17 pm
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....
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098 Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia
Post
by Chris Corbyn » Sat Feb 12, 2005 3:32 pm
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