Re: The my.cnf problem

[Nic Carter]

hi,

Can anyone join the party or just people called nic? Oh, yea that me anyway! I seem to have a similar problem.

I made a couple of changes to my.cnf and now the server won't fire up, or doesn't show as being there. As you will se from the log below it seems to be there as it closes but when it starts again it says 'Fail' but seems to be present but not active. I've checked all the ownership and access rights and they are all set to 'mysql' and 755.

Any ideas gratefully received.

Best regards nic

My.cnf
Changes made are dated. First changes seemed to work ok but second change caused problem and removing it or commenting it doesn't help!

[mysqld]

datadir=/mnt/mysql

socket=/mnt/mysql/mysql.sock

#datadir=/var/lib/mysql

#socket=/var/lib/mysql/mysql.sock



#skip all the innodb **** (nic 02Feb09)

skip-innodb



# switch on cache and allocate 32M (nic 30Jan09)

query_cache_limit=2M

query_cache_type=1

query_cache_size=32M



# 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

basedir=/mnt



[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid


---------------
mysql.log
The command : service mysqld restart
was issued from PuTTY and received a 'Fail'.
Reissuing the command seems to close the 'non-existant' instance and fails to restart.

090203 09:38:43 mysqld ended



090203 09:38:44 mysqld started

090203 9:38:44 [Note] /usr/libexec/mysqld: ready for connections.

Version: '5.0.45' socket: '/mnt/mysql/mysql.sock' port: 3306 Source distribution

090203 9:40:27 [Note] /usr/libexec/mysqld: Normal shutdown



090203 9:40:27 [Note] /usr/libexec/mysqld: Shutdown complete



090203 09:40:27 mysqld ended



090203 09:40:28 mysqld started

090203 9:40:28 [Note] /usr/libexec/mysqld: ready for connections.

Version: '5.0.45' socket: '/mnt/mysql/mysql.sock' port: 3306 Source distribution



Edited 1 time(s). Last edit at 02/03/2009 10:10AM by Nic Carter.