Originally Posted by glace
But I just found I had a 700 MB error log file in the mySQL dir. Must have grown big over the years. I did delete it and now it all seems fine.
I would check my logrotate setup on such a system to see why is isn't acting on th emysql logs (maybe it has never been told to, or maybe there is an error in the configuration).
re: the original question - I don't think having it in /home will be any less secure than having it in /usr as long as you make sure the file/dir permissions are correct in the new location.