Hello everyone,

I am compiling mysql source and need stored MySQL datafiles and log files (log bin) separated. For example:

/var/log/mysql /* log files

and

/sgdb/data /* data files


I used --localstatedir in ./configure but both data files and log files was stored together.

How do this????


Thanks!!!!


Marcos Santos




Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento!
http://br.mail.yahoo.com/

Marcos VinÃ*cius Vieira dos Santos wrote:


> I used --localstatedir in ./configure but both data files and log files
> was stored together.

In your my.cnf file, put the lines (in [mysqld] section

datadir = /sgdb/data
log-bin = /var/log/mysql

--
raj shekhar
facts: http://rajshekhar.net | opinions: http://rajshekhar.net/blog
Yoda of Borg are we: Futile is resistance. Assimilate you, we will
'Borg? Sounds Swedish.' - Lily, Star Trek First Contact