Find the answer to your Linux question:
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just 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

  2. #2
    Just Joined!
    Join Date
    Jul 2006
    Posts
    1

    Try adding this to your my.cnf

    tmpdir = /path/to/mysqltempdirectory


    Solomon Chang

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •