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]