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

[Raj Shekhar <rajlist@xxxxxxxxxxxxxx>]

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/mysql?unsub=royale@xxxxxxxxxx