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]