Moving MySQL datadir

[MichaelS-R]

I am trying to move my MySQL datadir. my.cnf is now:

[mysqld]
datadir=/mnt/data1/mysql
socket=/mnt/data1/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

This all seemed pretty straightforward but I now cannot get mysqld to start (or can I?). It is really not clear what is happening - when I run mysqld_safe I get the error message: A mysqld process already exists. service mysqld stop produces a Stopping MySQL: [ OK ] message.

I am really confused as to what is going on - help greatly appreciated!

I also get constant SELinux errors (currently in permissive mode so should not actually be stopping it) and cannot work out what to do about them at all..

Thanks,

Michael

[MichaelS-R]

Ok - new development. It appears that the server is running correctly now (mysqld_safe never exits) BUT... connecting requires that I specify the mysql.sock file or it does not work (I copied /mnt/data1/mysql/mysql.sock from the my.conf file). What am I missing?

Thanks,

Michael