RE: No binary file generated

[Rick James]

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