The UNIX and Linux Forums  


Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
.
google unix.com




View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #1 (permalink)  
Old 06-25-2008
dbsurf dbsurf is offline
Registered User
  
 

Join Date: Jan 2008
Posts: 23
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?