There were no any error message on console or in error log.
The symptoms are
1) the binary log file goes to /data/mysql/data/ dir, not as defined in /data/mysql/log/
2) the binary log files name start with "mysql-bin", not as I defined in my.cnf
I created directories as following and changed the owner to mysql account
/data/
/data/mysql/
/data/mysql/log/
/data/mysql/data/
I thought about might be I need to define "basedir" in my.cnf when I define log-bin. But
no matter what value I put in, the server cannot start.
from ps -ef I saw the default --basedir =/
but I cannot put this value in my.cnf either.
Thanks,
Lisa
--- On Wed, 9/17/08, Rick James <rjames@stripped> wrote:
> From: Rick James <rjames@stripped>
> Subject: RE: Consulting
> To: database100@stripped
> Cc: replication@stripped
> Date: Wednesday, September 17, 2008, 3:00 PM
> I don't see anything obviously wrong.
>
> What about ownership, etc, of /data/mysql/, itself?
>
> Did you mkdir /data/mysql/log and check its ownership,
> etc.
>
> "binary log directory doesn't work" -- what
> symptoms?
>
>
>
>
>
> > -----Original Message-----
> > From: Database System [mailto:database100@stripped]
> > Sent: Wednesday, September 17, 2008 12:52 PM
> > To: Rick James
> > Cc: replication@stripped
> > Subject: Consulting
> >
> > Rick,
> >
> > I have question need to consult you. Hope you use
> similar OS
> > system. I use MySQL on windows few years and it works
> fine.
> > Now I'm starting MySQL on RedHat Linux. I
> installed RPM
> > packege. After installation, the data files &
> error files are under:
> > /var/lib/mysql/
> > the mysql executable is under
> > /etc/init.d/ I can start the server from here
> > mysqld_safe is under
> > /usr/bin/
> > there was no my.cnf generated, I had to create one and
> put it in /etc/
> >
> > what value should I put for basedir = in my.cnf
> > I added datadir = /data/mysql/data and it worked fine.
> The
> > server access database in the directory I setup in
> my.cnf.
> >
> > But after I added "log_bin =
> /data/mysql/log/binlog" in my.cnf,
> > the log files are generated under /data/mysql/data/
> (same dir
> > with database files) and the log file name start with
> > mysql-bin which is not what I designed start with
> 'binlog'
> > I also tried "log_bin = /data/mysql/log" it
> did help anything.
> >
> > I checked the mysql account owns all dir's from
> /data/ and down.
> >
> > Do you know why I set datadir is working and binary
> log
> > directory doesn't work?
> >
> > Thank you,
> > Lisa
> >
> >
> >
> >
