MySQL Forums
Forum List  »  Knowledge Base

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

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
3626
January 05, 2009 02:07AM
Re: The my.cnf problem
3447
February 03, 2009 09:50AM
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.