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]
