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
