Re: RedHat-9

[Nils Valentin]

Hi Jean;

enter into /etc/my.cnf or ~/.my.cnf

datadir=/mnt/data/mysql

login to mysql and do

SHOW VARIABLES LIKE '%data%'

That should do it.

Best regards

Nils Valentin
Tokyo/Japan


On Fri, 30 May 2003 15:06:35 +0200, Jean Christophe <lavieenrose@stripped> 
wrote:

> Hi,
> I have mysql running on a redhat-9. (rpm files)
> I tried to change the datadir from /etc/my.conf without succes.
> What do I have to do to change the directory of my databases from 
> /var/lib/mysql (default) to /mnt/data/mysql ?
> is the fact that /mnt/data a vfat partition a problem (if it is, I can 
> make it to a ext3 !)
> Thank's
> ;-)
> Jean Christophe
>
>