[Gllug] MySQl Problem - Please Help

[Richard Huxton]

wendy carr wrote:
> Hi,
> 
> Could you please help me to solve this problem ? I am
> getting totally frustrated. I have a redhat 7.3 server
> with around 500 web sites.It runs mysql 3.23 , up to a
> three days everything was ok. The problem is the
> mysqld server fails about every 10 minutes.I ve
> checked the /var/log/mysqld which says,
> 
> Cannot initialize InnoDB as 'innodb_data_file_path' is
> not set.
> If you do not want to use transactional InnoDB tables,
> add a line
> skip-innodb
> to the [mysqld] section of init parameters in your
> my.cnf

Well - that's clear enough.

> and
> 
> 050510  0:45:14  Aborting
> 
> 050510  0:45:14  /usr/libexec/mysqld: Shutdown
> Complete
> 
> 050510  0:45:14  Can't start server: Bind on TCP/IP
> port: Address already in use
> 050510  0:45:14  Do you already have another mysqld
> server running on port: 3306
>  ?
> 050510  0:45:14  Aborting
> 
> when i check netstat -na iget quite a few socket
> connections
> /var/lib/mysql/mysql.sock

Which implies mysql is still running. What about port 3306?

You don't have two versions installed by any chance - one by RPM, one 
from source? I've seen that cause this sort of confusion.

--
   Richard Huxton
   Archonet Ltd
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug