Re: Fw: RE: No binary file generated

[Moon's Father]

Please check whether your mysqld is running or not?

On Wed, May 7, 2008 at 7:41 PM, martín arrieta <necrite@stripped> wrote:

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



-- 
I'm a mysql DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn