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
>
>
>
>
