mysql_install_db hangs

[George Chelidze]

Hello,

One of my custommers use mysql database and a few days ago he asked me to solve the strange problem with it. I don't know the history of server so I am unable to feed you with information like what has been changed before problem occured, but below is the describtion of problem itself and maybe someone can tell what can be the reason.

facts:

ps ax doesn't show any mysql process running
netstat -lnp shows that tcp/3306 port is in listening state but application doesn't present ('-' instead). pid file still exsists but process with pid listed in pid file doesn't present. mysql is unable to start because "socket is already in use..."

I have uninstalled mysql rpm-s and rebooted, after system booted up 3306 port became finally closed so I tried to install new rpm-s. First I tried to install MySQL-<VERSION>.i386.rpm and after some time I saw:

Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables

after that it hangs and there is no message until I terminate it from shell using CTRL+c. After termination:

#ps ax | grep mysql

5736 pts/2 S 0:00 sh /usr/bin/mysql_install_db -IN-RPM
5741 pts/2 S 0:00 /usr/sbin/mysqld --bootstrap --skip-grant-tables --basedir=/ --datadir=/var/lib/mysql --skip-innodb --skip-gemini --skip-bdb

#netstat -lnp | grep 3306

tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN -

#

I have tried to install mysql from source and installation finished successfully but problem still exsist when I run mysql_install_db

Any ideas?
--
George Chelidze




---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php