Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Our company trying to migrate to mySQL 5.0 and I'm having some problems setting it up on our first new server.
System: 8 GB Ram, Dual-core.
OS: Red Hat Enterprise Linux 4
I was able to get it to start but I'm trying to change the directory the database is stored. I understand this is the datadir value in the my.cnf. This file doesn't exists so I copied the my-huge.cnf file and inserted the following lines at the bottom:
Also do I change all the /var/lib/mysql/ to the new directory or the one value. Only other path in the file was for socket, so I changed that even though I could find the fine it was originally pointing to. When I try to start mysql I get the following message.
[root@Hostname /]# service mysql start
Starting MySQLCouldn't find MySQL manager or server [FAILED]
I copied the /var/lib/mysql director to /sqldir and chown it to mysql user. I tried changing basedir=/sqldir/mysql/, putting the socket path back as it was and commenting it out but continue to get the above error. if I remove my.cnf then mysql starts fine only not using desired database path.