Mysql service not starting

[MaZZie]

I have update my mysql to the latest version.
Now it wont start.

The only thing i can found is this:
2005:05:08-20:27:00: service mysqld wasn't running, starting it
2005:05:08-20:27:10: service mysqld didn't start, re-starting it


I don't know where i can find why he is not starting

 

[jmstacey]

What is the error, if any, that you receive when you try to start it through ssh?

What Operating System are you running. What versions of MySQL were you running (before/after) the upgrade.
What steps did you go through in upgrading as well as troubleshooting this problem?

 

[MaZZie]

I Use Redhat 9.0

I had the basic Mysql after DA installation.
Now i have the latest version. The service is running becouse i can make users and things but DA display me that the service is stopped

 

[jmstacey]

So you upgraded using MySQL's provided rpm's?

If the service is running and fully operational but DirectAdmin still doesn't see it on, make sure that MySQL is isntalled using the id "mysqld" and not "mysql" which will mess it up.

 

[MaZZie]

This is wat what I get with ps -aux

mysql 12481 0.1 3.1 120596 15792 ? S 05:19 0:00 /usr/sbin/mysqld-

What is the command to check wat you says and how can I change it

 

[Mikej0h]

I recommend to uninstall the version you installed now.
The reason is simple: the rpm made it look like a mess.

If you uninstall the database, the datadirs will normally not be deleted, if you reinstall MySQL it automaticly reads the information from the data directorys, and MySQL will not loose any data.
The data directory is located here: /var/lib/mysql
Every database in your setup is located there in a seperate directory.

EDIT: Maybe it's smarter to make a backup before you start uninstalling MySQL.
Do something like:

cd /var/lib
cp -rR mysql/ mysql-bak/