Re: Store MySQL data files and log files (log bin) separated!!!

[Raj Shekhar]

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


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Store MySQL data files and log files (log bin) separated!!!

[Marcos Vinícius Vieira dos Santos]

Hello everyone,

I am compiling mysql source and need stored MySQL data files 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/