Never mind. I installed MySQL from a different location and now it works. ...Stephen
> -----Original Message----- > From: Stephen Rasku [mailto:[EMAIL PROTECTED] > Sent: September 23, 2004 9:32 AM > To: [EMAIL PROTECTED] > Subject: MySQL client hangs > > > 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/mysql?> [EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]