Missing my.cnf after installing mysql 5.1.35

jdnow09 · 06-18-2009, 02:13 PM

Hello,

I installed mysql version 5.1.35 on centos 5.3. These are fresh installation.

I am not able to locate my.cnf file on /etc directory. I want to be able to change the location of data location (changed the default).

Any help would be appreciated.

Btw, I did the yum update before installing mysql.

John

bathory · 06-18-2009, 04:59 PM

How did you install it?
You should use your package manager (yum) to install both mysql and mysql-server. I think /etc/my.cnf is available by the client mysql package. Or you can find under /usr/share/mysql configuration files for various needs, so you can copy the one that fits your needs under /etc/my.cnf.

If you used the binary from mysql.com you can find under /<install-dir>/mysql/support-files also various .cnf to choose the one that matches your needs.

jdnow09 · 06-18-2009, 06:31 PM

I installed both the server and client.

I went into /usr/share/mysql and copied one of the .cnf files (my-small.cnf) to the etc calling it my.cnf.

I also move all the files from /var/lib/mysql to my new directory.

Edited the my.cnf file with no luck.

Starting MySQL.Manager of pid-file quit without updating file.[FAILED]

The new directory has all the rights.

Edit: I used the rpm package from mysql.com. What would the command to install mysql from yum?

thanks,
john

jdnow09 · 06-18-2009, 11:10 PM

i finally went with --> 'yum install mysql-server' and it worked. Mysql version is a little older.

I modified the my.cnf and move all the databases over to the new location.

I did run into another problem. If i enforce "selinux", mysqld won't start. Any idea how it can fix this?

I will post another thread for this problem.

john