change system variable - MySQL

[Bruintje Beer]

Hi,

How do I change the variable 'save_load_tmpdir' in MySql. ( it point to an
non existing directory )

When I do set global save_load_tmpdir=<new value> in mysql
I get an error that the variable not exist. How do I change it.

Johan

[Kai Ruhnau]

Bruintje Beer wrote:

> How do I change the variable 'save_load_tmpdir' in MySql. ( it point to an
> non existing directory )
>
> When I do set global save_load_tmpdir=<new value> in mysql
> I get an error that the variable not exist. How do I change it.

Do you mean slave_load_tmpdir?
-------------^

Greetings
Kai

--
This signature is left as an exercise for the reader.

[Bruintje Beer]

"Kai Ruhnau" <kai.newsgrouptragetaschen.dyndns.org> schreef in bericht
news:dkqjjh$33e$03$1news.t-online.com...

> Bruintje Beer wrote:

>> How do I change the variable 'save_load_tmpdir' in MySql. ( it point to
>> an non existing directory )
>>
>> When I do set global save_load_tmpdir=<new value> in mysql
>> I get an error that the variable not exist. How do I change it.

>
> Do you mean slave_load_tmpdir?
> -------------^
>
> Greetings
> Kai
>
> --
> This signature is left as an exercise for the reader.

yes, i made a typo

how to change ?

Johan