I am running MySQL 4.0.17 on QNX 6.2.1B.

When I run the mysql client, mysql, it hangs.  There is no output even
when I do:

        mysql -v -v -v

I can see that the MySQL daemon is running:

# ps -ef | grep mysql
    0     901147          1  - Sep23 ?        00:00:00 /bin/sh
/usr/local/mysql/bin/mysqld_safe --basedir=/usr/local/mysql
--ledir=/usr/local/mysql/libexec --datadir=/usr/local/mysql/var
    0    1290268     221209  - 16:20 ?        00:00:00 grep mysql
  101    1056797     901147  - Sep23 ?        00:40:39
/usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
--datadir=/usr/local/mysql/var --user=mysql
--pid-file=/usr/local/mysql/var/smithers.pid --port=3306
--socket=/tmp/mysql.sock
  101    1056797     901147  - Sep23 ?        00:40:39
/usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
--datadir=/usr/local/mysql/var --user=mysql
--pid-file=/usr/local/mysql/var/smithers.pid --port=3306
--socket=/tmp/mysql.sock
  101    1056797     901147  - Sep23 ?        00:40:39
/usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
--datadir=/usr/local/mysql/var --user=mysql
--pid-file=/usr/local/mysql/var/smithers.pid --port=3306
--socket=/tmp/mysql.sock
  101    1056797     901147  - Sep23 ?        00:40:39
/usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
--datadir=/usr/local/mysql/var --user=mysql
--pid-file=/usr/local/mysql/var/smithers.pid --port=3306
--socket=/tmp/mysql.sock
  101    1056797     901147  - Sep23 ?        00:40:39
/usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
--datadir=/usr/local/mysql/var --user=mysql
--pid-file=/usr/local/mysql/var/smithers.pid --port=3306
--socket=/tmp/mysql.sock

However, there is no pid file.

Here is the output of the err file:

040923 15:39:52  mysqld started
040923 15:39:53  InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 1 202150249
InnoDB: Doing recovery: scanned up to log sequence number 1 202150933
040923 15:39:54  InnoDB: Starting an apply batch of log records to the
database.
..
InnoDB: Progress in percents: 36 37 38 39 40 41 42 43 44 45 46 47 48 49
50 51 52
 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
77 78 7
9 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 #

This same setup was working on this machine before I reformated the hard
drive and reinstalled.  In order to install, I copied the
/usr/local/mysql directory from a working system.

Stephen Rasku
Tantalus Systems Corp.
Your Power. Your Data. One Wireless Network.
T: 604-299-0458 x220  F: 604-451-4111
www.tantalus.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to