Need to change the datadir on linux

[Bastien]

Hi All,

Having a problem changing the datadir to point to a new disk that we installed in the linux machine.

here is the my.cnf file:

# Replication Master Server
[client]
port = 3306
socket = /mysql_data/mysql/mysql.sock

[mysqld]
# Replication Master Server (default)
# binary logging is required for replication
log-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1

datadir=/var/lib/mysql
#datadir=/mysql_data/mysql 'new disk
socket=/var/lib/mysql/mysql.sock
#socket=/mysql_data/mysql/mysql.sock 'new disk

[mysql.server]
user=mysql
basedir=/var/lib
#basedir=/mysql_data

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

When the new disk lines are uncommented and the currecnt one are commented, the server won't start

Any idea?

Bastien

Cat, the other other white meat

 

[Bastien]

turned out it was a permissions/ownership problem on the new dir

Bastien

Cat, the other other white meat