>Description:
I just moved all of our mysql files over from a machine Running
Solaris 8 to a machine running Linux Redhat. I then installed the latest
version of mysql. For some reason, I get an error when trying to access
any table that is of the ISM format. I can've even convert them to MYI.
As an experiment, I copied a table over to a Solaris machine, converted
it to MYI and then copied it back to the LInux machine. It opens fine.
WHY??? and how do I remedy this??
I could copy all of the tables over and convert them to MYI, but we have
over 8,000 tables that take up over 150 Gigs of space. This would be a
painfully slow conversion.
>How-To-Repeat:
See above
>Fix:
See above
>Submitter-Id: Noah Silverman
>Originator: AllResearch
>Organization:
>MySQL support: extended email support CONTRACT 725
>Synopsis: Opens MYI but not ISM in Linux
>Severity: CRITICAL
>Priority: HIGH
>Category: mysql
>Class: Support
>Release: mysql-3.23.42 (Official MySQL RPM)
>Server: /usr/bin/mysqladmin Ver 8.21 Distrib 3.23.42, for pc-linux-gnu on i686
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.42
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 7 hours 4 min 5 sec
Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0
Queries per second avg: 0.000
>Environment:
System: Linux raidzone.webclipping.com 2.4.6-2smp #1 SMP Mon Aug 20 12:40:49 EDT 2001
i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake
Compilation info: CC='egcs' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium'
CXX='egcs' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti -mpentium' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Aug 21 09:38 /lib/libc.so.6 -> libc-2.2.2.so
-rwxr-xr-x 1 root root 1236396 Apr 6 21:58 /lib/libc-2.2.2.so
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --without-berkeley-db --without-innodb
--enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man
'--with-comment=Official MySQL RPM'
---------------------------------------------------------------------
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
