Hi all First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2 with MySQL 4.1.12, rpm install.
Changed the data directory. My /etc/my.conf [mysqld] datadir=/home.dbdata/mysql socket=/home.dbdata/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Ran these commands for permissions: chown -R mysql:mysql /home.dbdata/mysql chmod -R go-rwx /home.dbdata/mysql Running /etc/rc.d/init.d/mysqld start says that mysql start failed BUT ps -aux shows that mysql is running 0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pidmysql 6184 0.2 3.4 125808 17636 pts/0 Sl 15:47 0:01 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usrroot 6336 0.0 0.1 2920 744 pts/0 R+ 15:57 0:00 ps -aux Log shows 051114 14:51:07 mysqld started 051114 14:51:08 InnoDB: Started; log sequence number 0 43634 /usr/libexec/mysqld: ready for connections. Version: '4.1.12' socket: '/home.dbdata/mysql/mysql.sock' port: 3306 Source distribution 051114 15:47:06 [Note] /usr/libexec/mysqld: Normal shutdown 051114 15:47:06 InnoDB: Starting shutdown... 051114 15:47:09 InnoDB: Shutdown completed; log sequence number 0 43634 051114 15:47:09 [Note] /usr/libexec/mysqld: Shutdown complete 051114 15:47:09 mysqld ended 051114 15:47:33 mysqld started 051114 15:47:33 InnoDB: Started; log sequence number 0 43634 /usr/libexec/mysqld: ready for connections. Version: '4.1.12' socket: '/home.dbdata/mysql/mysql.sock' port: 3306 Source distribution Please advise what I have done wrong. I suspect permissions &/or incorrect data directory migration. Please help. With regards. Sanjay. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
