I've been trying to relocate the data directory and have set the permissions for the new location to reflect those of the old.
Every time I try to restart mysqld it shuts down right away. it says it can't find the socket file, though I didn't change it's location physically nor in the /etc/my.cnf file
I've also been interested in upgrading to 4.0.23 however once I got the rpm's it doesn't really say anything about upgrading. I have found I'm still running my old version 3.
I really need to find out how to move the data directory because the default directory is on a drive that's almost full.