Tried that.
mysql> ALTER TABLE Craft type=MYISAM;
ERROR 1016: Can't open file: 'Craft.ISD'. (errno: 138)
I have tried to run the mysql_convert_table_format script but I can't find
any examples and I cannot get it to work either. I'm quite sure it's
operator error in this case.
We have pulled the database off the tape onto three different machines and
it runs fine everywhere but this one.
I have re-extracted on this machine several times.
I don't think the tape is bad, it works fine elsewhere.
I don't think the extraction is the problem, I've done it several times here
and the same way as elsewhere.
I know I must be missing something - - I just can't figure out what!
Bev
-----Original Message-----
From: Rolf Hopkins [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 9:34 PM
To: Beverly Baird; [EMAIL PROTECTED]
Subject: Re: Problem running old database with 3.23.30-gamma
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
