Re: Fw: RE: No binary file generated

[martín arrieta]

Hi,

If you change the socket variable and it works, the right place for the
my.cnf file is /etc/mysql/.

For the bin log, please check this :

# *mysqladmin  variables | grep "log_bin "*
| log_bin                         |
ON                                                     |

If you get "OFF" in this variable, you have to set the variable *log-bin =
mysql-bin* in your my.cnf file.

Good  luck !

Martin

2008/5/6 Database System <database100@stripped>:

> The my.cnf is readable by everybody.
>
>
> --- On Tue, 5/6/08, Rick James <rjames@stripped> wrote:
>
> > From: Rick James <rjames@stripped>
> > Subject: RE: No binary file generated
> > To: database100@stripped
> > Cc: replication@stripped
> > Date: Tuesday, May 6, 2008, 10:52 AM
> > Is my.cnf readable by mysql?  (ls -l, chown, ...)
> >
> >
> > MySQL Geeks - Consulting & Review
> > Email: rjames@stripped
> > Messenger : rjasdf
> > http://twiki.corp.yahoo.com/view/Devel/MySQLGeeks
> >
> >
> >
> > > -----Original Message-----
> > > From: Database System [mailto:database100@stripped]
> > > Sent: Tuesday, May 06, 2008 8:49 AM
> > > To: Replication MySQL
> > > Subject: No binary file generated
> > >
> > > Hi,
> > >
> > > I have been used MySQL on Windows no problem. Now we
> > start to
> > > use non-RPM Linux.
> > > I installed MySQL followed manual. But the fact is
> > different
> > > than manual told.
> > > My problem is: if I put my.cnf in /etc/ dir, the
> > socket file
> > > is always generated in /tmp/, named mysql.sock. But
> > when
> > > client try to connect to server, get message
> > "Cannot connect to
> > > local MySQL server through socket
> > > '/var/run/mysqld/mysqld.sock'. Even though in
> > my.cnf setup
> > > socket file=/var/run/mysqld/mysqld.sock or start
> > option setup to
> > > that dir.  But the server works fine, generates binary
> > log
> > > file at that time.
> > >
> > > If I put my.cnf in /etc/mysql/ dir, after start the
> > server,
> > > although client is able to connect to server at this
> > setting,
> > > but there is no binary log file generated from server
> > any more.
> > >
> > > Any one has success configured server, could you let
> > me know
> > > what I can do or let me know:
> > > 1) Where do you put your my.cnf file?
> > > 2) Where do you setup socket file dir in your my.cnf?
> > (in all
> > > 3 sections: mysql, mysqld, client)
> > > 3) How do you start server (use mysql.server or
> > mysqld_save)
> > > if it has affect?
> > >
> > > Thanks advance,
> > > Lisa
> > >
> > >
> > >
> > >
> > >
> > >
> > ______________________________________________________________
> > > ______________________
> > > Be a better friend, newshound, and
> > > know-it-all with Yahoo! Mobile.  Try it now.
> > >
> > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
> > >
> > > --
> > > MySQL Replication Mailing List
> > > For list archives: http://lists.mysql.com/replication
> > > To unsubscribe:
> > >
> > http://lists.mysql.com/replication?unsub=1
> > >
> > >
> >
> > --
> > MySQL Replication Mailing List
> > For list archives: http://lists.mysql.com/replication
> > To unsubscribe:
> > http://lists.mysql.com/replication?unsub=1
>
>
>
> 
> ____________________________________________________________________________________
> Be a better friend, newshound, and
> know-it-all with Yahoo! Mobile.  Try it now.
> http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?unsub=1
>
>