Hi,
We're attempting to get mysql running on our
System: SunOS hsNavMrySun2 5.6 Generic_105182-21 i86pc i386 i86pc
Architecture: i86pc
We're using the Workshop pro compilers, and can compile the source v
3.23.33 without problems.
However, nothing on the system that I've found can create tables
correctly.
mysql> create table test (
-> a1 INT,
-> a2 INT);
Query OK, 0 rows affected (0.32 sec)
mysql> select * from test;
ERROR 1016: Can't open file: 'test.MYD'. (errno: 126)
Here's another table that I created on another machine, and copied the
ISAM files over from a working Linux ix86 machine, and they work fine.
mysql> select station, station_local from location where station='CYYZ';
+---------+---------------+
| station | station_local |
+---------+---------------+
| CYYZ | YYZ |
+---------+---------------+
1 row in set (0.46 sec)
mysql> delete from location;
Query OK, 0 rows affected (0.04 sec)
mysql> select station, station_local from location where station='CYYZ';
ERROR 1016: Can't open file: 'location.MYD'. (errno: 126)
>Server: mysqladmin Ver 8.15 Distrib 3.23.33, for pc-solaris2.6 on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.33
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 1 hour 4 min 45 sec
Threads: 1 Questions: 180 Slow queries: 0 Opens: 27 Flush tables: 1
Open tables: 2 Queries per second avg: 0.046
>Environment:
<machine, os, target, libraries (multiple lines)>
System: SunOS hsNavMrySun2 5.6 Generic_105182-21 i86pc i386 i86pc
Architecture: i86pc
Some paths: /usr/local/bin/perl /usr/ccs/bin/make /opt/SUNWspro/bin/cc
Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS=''
LDFLAGS=''
LIBC:
-rw-r--r-- 1 bin bin 1476980 Sep 9 1998 /lib/libc.a
lrwxrwxrwx 1 root root 11 Nov 4 1998 /lib/libc.so ->
./libc.so.1
-rwxr-xr-x 1 bin bin 890992 Sep 9 1998 /lib/libc.so.1
-rw-r--r-- 1 bin bin 1476980 Sep 9 1998 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Nov 4 1998 /usr/lib/libc.so
-> ./libc.so.1
-rwxr-xr-x 1 bin bin 890992 Sep 9 1998 /usr/lib/libc.so.1
Configure command: ./configure
--with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory
--with-mit-threads=yes --without-perl
--enable-thread-safe-client --without-berkeley-db
Perl: This is perl, version 5.005_02 built for i86pc-solaris
and using myisamchk
# ../../bin/myisamchk location.MYI
../../bin/myisamchk: error: 'location.MYI' doesn't have a correct index
definition. You need to recreate it before you can do a repair
I'd appreciate any pointers to getting mysql running on this system.
$ cc -V
cc: WorkShop Compilers 4.2 24 Nov 1997 C 4.2 patch 105062-03
usage: cc [ options] files. Use 'cc -flags' for details
I'd also prefer not to need to switch to gcc as this machine also
compiles lots of legacy code.
I'm predicting that the problem is wrt the actual creation of the index
with errors...
If all else fails we can connect to a remote Linux-based Mysql server,
but it would be very nice to know that the database will actually work
on the local machine...
Thanks for any advice.
Scott V
---------------------------------------------------------------------
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
