Results 1 to 2 of 2
Hi,
I am new to work under unix and linux, the administrator left us stuck with an application running with mySQL 4.1 on a unix based server
any query that ...
- 06-06-2006 #1Just Joined!
- Join Date
- Jun 2006
- Posts
- 1
How to change mySQL tmp directory
Hi,
I am new to work under unix and linux, the administrator left us stuck with an application running with mySQL 4.1 on a unix based server
any query that includes big data cause errcode 28, which seems due to the size of the \tmp directory of mySQL
my question:
how can i know where did the admin locate the mySQL tmp directory
and how can i change it to bigger one.
any help is appreciated, the application is live, and every day costs us loss of clients. Please be detailed in your replies ..we nearly have no experience with unix and linux environment
Thanks
- 07-18-2006 #2Just Joined!
- Join Date
- Jul 2006
- Posts
- 1
Try adding this to your my.cnf
tmpdir = /path/to/mysqltempdirectory
Solomon Chang


Reply With Quote