MySQL won't change database directory
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.
I appreciate any help with this.