MySQL Forums
Forum List  »  Knowledge Base

Re: The my.cnf problem
Posted by: Nic Carter
Date: February 03, 2009 09:57AM

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
The changes made on 02Feb09 caused restart failure, and remove them or commenting them out makes no differnce:

[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
command given via PuTTY: service mysqld restart
was sent after previous start returned 'Failed'.
log details:
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


------------------------

Options: ReplyQuote


Subject
Views
Written By
Posted
3626
January 05, 2009 02:07AM
3448
February 03, 2009 09:50AM
Re: The my.cnf problem
3659
February 03, 2009 09:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.