Hello all,
My query is about changing the tmpdir on mysql. As stated in on the mysql.com site it states that if it is not set it uses the default, in my case, the default was /tmp. It also states that to change it you can do so in the mysqld_safe startup file. It makes no mention of changing it in the my.cnf file.
What page on mysql.com are you looking at?
my.cnf *is* the startup file, so you can set tmpdir using by placing the appropriate option in the [mysqld] group of the file:
[mysqld] tmpdir=/the/path/you/want/to/use
You can put these lines in any of the startup files that the server reads, such as /etc/my.cnf.
My questions are:
1) Can you set the tmpdir in the conf file my.cnf? if so, how? 2) if you can only make that change in mysqld_safe, how do you?
I did not mention the change at command line, e.g. mysqld_safe -tmpdir=/whatever because I don't want to have to change the startup scripts.
Thanks for the help,
dan
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
