I seem to have get everything apart from the PID file to re-locate.
I did actually manage to get the PID file to a different location. The
reason why I was stumped on it before was because in the results from doing
SHOW VARIABLES the name of the variable for the location of MySQL's PID file
is listed as 'pid_file', but mysqld expects it as 'pid-file' in your my.cnf
file!!
Anyway, I have hit upon another trouble. Is it possible to get the MySQL
error log to write to a different location other than /var/lib/mysql/? I
can't seem to find a variable to set for that.
Regards,