You must copy /usr/share/doc/MySQL-server-community-5.1.39/my-somefile.cnf file into /etc/my.cnf
If no .cnf file in /etc MySQL use default config. if server has 2G RAM then use my-huge.cnf Good luck. ----- Original Message ----- From: "Sydney Puente" <sydneypue...@yahoo.com> To: <mysql@lists.mysql.com> Sent: Friday, November 13, 2009 3:10 AM Subject: cannot find my.cnf file > Hello, > I want to log all sql queries made against a mysql db. > Googled and found I should add a line to my.cnf. > > However I cannot find a my.cnf file > [r...@radium init.d]# ps -ef | grep mysql > root 13614 1 0 Sep24 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe > --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/object01.pid > mysql 13669 13614 0 Sep24 ? 00:21:40 /usr/sbin/mysqld --basedir=/ > --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/object01.err > --pid-file=/var/lib/mysql/object01.pid > root 23050 22746 0 19:05 pts/0 00:00:00 grep mysql > [r...@radium init.d]# locate cnf > /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnf > /usr/share/doc/MySQL-server-community-5.1.39/my-innodb-heavy-4G.cnf > /usr/share/doc/MySQL-server-community-5.1.39/my-large.cnf > /usr/share/doc/MySQL-server-community-5.1.39/my-medium.cnf > /usr/share/doc/MySQL-server-community-5.1.39/my-small.cnf > /usr/share/man/man8/cnfsheadconf.8.gz > /usr/share/man/man8/cnfsstat.8.gz > /usr/share/ssl/openssl.cnf > /usr/share/mysql/my-large.cnf > /usr/share/mysql/my-huge.cnf > /usr/share/mysql/my-innodb-heavy-4G.cnf > /usr/share/mysql/my-medium.cnf > /usr/share/mysql/my-small.cnf > Any ideas? > I might add i did not install mysql and I did not start it and the guy who > did is in holiday! > > TIA > > Syd > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=old...@posbank.co.kr > >
