Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 437
  • Last Modified:

Set mysql to write into /tmp and not /var/tmp

How do I set mysql to write to /tmp and not /var/tmp.

How can I edit this config to do this.

I am using freebsd 7.2 and mysql 5

thanks,
0
ITCity
Asked:
ITCity
  • 2
1 Solution
 
nociSoftware EngineerCommented:
in my.cnf:

tmpdir                                                = /tmp/
0
 
ITCityAuthor Commented:
in my.cnf i found this

# Point the following paths to different dedicated disks
#tmpdir            = /tmp/

To do Just conver to this ?

# Point the following paths to different dedicated disks
tmpdir            = /tmp/
0
 
nociSoftware EngineerCommented:
yes & restart mysqld.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now