[Gllug] MySQl Problem - Please Help

[Richard Huxton]

wendy carr wrote:
> Hi,
> 
> Thanks for you comments. I have another server wiyh
> same mysql configuration , so i suppose making changes
> as in the error log is not a solution. I have used
> rpms to install mysql and only one version.Also there
> is only one instance running, i have cheked with ps
> axf and pstree.
> 
> is there any test procedure ? 

Whenever I've hit a wall like this, it's because one of my assumptions 
has been wrong.
If you have another server that's not complaining, then either it's got 
a different version of MySQL (and underlying libraries) or a different 
config file. One of those *must* be true.

Make sure the config files are the same by running diff against them.

Stop any running copies of mysql
Check you've killed all of them:
   ps auxw | grep my
Check no sockets are in use:
   netstat -na | grep my
   netstat -na | grep 3306
Manually start mysql
   safe_mysqld
   or /etc/init.d/mysql start
Check your logs

Repeat the same on the working server.

If you still can't see any differences, run md5sum against the mysql 
binaries.

*Something* must be different between the two installations.
-- 
   Richard Huxton
   Archonet Ltd
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug