Trying to move datadir of mysql
I am using RHEL V4 with the default install of mysql 4.1.xx I am trying to move the data directory from the default of /var/lib/mysql to /studio folder which is another harddrive that is raid 5.
I have made the change in the my.cnf - copied the files over and can not seem to get mysqld started. I have even at one point made symbolic links from /var/lib/mysql to /studio folder.
If anyone has any feedback on how to move the data directory i would greatly appreciate it. I would like to keep all my data on the raid 5 drive and the OS on the raid 1 drive.