Jean,
Here is the format for the SHOW TABLE STATUS command from
http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html:
SHOW TABLE STATUS [FROM db_name] [LIKE wild]
You are using FROM <TABLENAME> not your database's name. Try this:
SHOW TABLE STATUS FROM jeandatabase
and see if it works better ;)
Respectfully,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Jean Zhong
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
com> cc:
Fax to:
06/10/2004 11:04 Subject: "show table status" problem
AM
Hello, everyone
I am new on MySQL.
I created several tables by command:
%mysql jeandatabase -u root -h localhost -p <
jean1.sql
and jean1.sql is as follows:
use jeandatabase;
drop table if exists jean1;
create table jean1( id int not null,
field1 char(9),
primary key(id)
);
But, when I try to take a look on the table1 status
by:
mysql> show table status from jean1;
It gave me the following error:
ERROR 12: Can't read dir of './jean1/' (Errcode: 2)
I think it supposes that there would be a sub-directry
under .../jeandatabase/, and named jean1.
But when I cd to /usr/local/mysql/data/jeandatabase/
There are three files:
jean1.MYD
jean1.MYI
jean1.frm
I wonder if the way I import the table is not correct.
Could anyone give me some ideas about this problem?
Thank you very much.
Jean
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
