What if you did try upgrading myism tables? I remember reading something
about ism tables not being supported in the future anyway.
----- Original Message -----
From: "Beverly Baird" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 01, 2001 2:33
Subject: Problem running old database with 3.23.30-gamma
> Hello,
>
> I have a database, called mace, that was collected under 3.21.??
>
> It runs under 3.22.26a
> It runs under 3.23.28-gamma
>
> But what I need it to function with is 3.23.30-gamma
>
> When I try to run with 3.23.30-gamma I get the following:
>
> % mysql mace
>
> Reading table informatin for completino of table and column names
> You can turn off this feature to get a quicker start up with -A
>
> Didn't find any fields in table 'Contact'
> Didn't find any fields in table 'Craft'
> Didn't find any fields in table 'CraftActiveSensor'
> Didn't find any fields in table 'DataType'
> Didn't find any fields in table 'Environmental'
> Didn't find any fields in table 'NasSensor'
> Didn't find any fields in table 'Navigation'
> Didn't find any fields in table 'NonAcoustic'
> Didn't find any fields in table 'RawData'
> Didn't find any fields in table 'Sensor'
> Didn't find any fields in table 'RawData'
> Didn't find any fields in table 'Wavetrain'
>
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection is is 637 to server version 3.23.30-gamma
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql>
>
> If I start with a different database and then type
>
> mysql> use mace;
>
> I get the same "Didn't find any . . . ." messages.
>
> If I type "show tables;" it displays all the tables happily.
>
> But queries yield
>
> mysql> select count(*) from Craft;
> ERROR 1016: Can't open file: 'Craft.ISD'. (errno: 138)
>
>
>
>
> At first I thought it was an ISD, ISM / MSD, MSI problem.
>
> But the fact that I can install the same database on different machines
> (sparc and linux) and it works under 3.22. and 3.23. databases makes me
> think that's not the problem. (I believe the switch to MyISAM was at
3.23?)
> And it's supposed to be backwards compatible, and seems to be.
>
> The machine that is the problem is a linux box running RedHat 6.2.
>
>
> Thanks in advance
>
>
> Beverly Baird
> Digital System Resources
> 703-263-2849
> [EMAIL PROTECTED]
>
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
