06-25-2008
23,
0
Join Date: Jan 2008
Last Activity: 19 September 2008, 12:25 PM EDT
Posts: 23
Thanks Given: 0
Thanked 0 Times in 0 Posts
Errors while executing mysql cmds in SUn solaris server
Hi All,
I am using mysql at sun solaris unix(Hp) server. I logged into mysql server with root as user. its logged in properly. Then i used 'show databases' mysql command. its display all the available databases.
for example
mysql > show databases;
It displayed as follows.
exampledb1
exampledb2
mysql
test
Now i used mysql > use exampledb1;
its given message called database changed.
now i trying to show all the tables under exampledb1 database using the below command.
mysql > show tables;
Now i am getting one error called
ERROR 12: Can't read dir of './exampledb1/' (Errcode: 13)
then i tried to drop the exampledb1 database using the below command.
mysql> drop database exampledb1;
Now i am getting different error.
ERROR 1008: Can't drop database 'exampledb1'. Database doesn't exist
can you please give me solutions for the above errors?