I have installed Enterprise Linux 5 version with the MySQL Version
5.0.22.
I would like to have my datadir as /data/mysql and have the
following lines in /etc/my.cnf file
[mysqld]
datadir=/data/mysql
socket=/data/mysql/mysql.sock
[mysql.server]
basedir=/data
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysql.pid
*I have also* copied /var/lib/mysql to /data/mysql and have set the
permissions.
*Problem:* When I start the mysql daemon it returns with a timeout.
Just replacing '/data/mysql' with the default '/var/lib/mysql' runs fine.
Any issues on what is wrong or how to fix.
Thanks in advance
..venu