The "from jean1" is looking for a database named "jean1", it is not the table name. See http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html
If you are already connected to the database, just use:
Show Table Status;
If you want status for a particular table then try:
Show Table Status like "jean1";
or
Show Table Status like "jean%";
if you have more than 1 table starting with "jean".
Mike
At 10:04 AM 6/10/2004, you wrote:
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]
