Find the answer to your Linux question:
Results 1 to 2 of 2
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1

    How to change mySQL tmp directory


    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


  2. #2

    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