MySQL Forums
Forum List  »  Newbie

Can't read dir of ...
Posted by: Henk Jansen
Date: April 18, 2005 04:54PM

I'm transferring my databases from a crashed disk on a Fedora 2 system to a fresh Fedora 3 system. I've put the databases under /var/lib/mysql and get the following disappointing result:

[root@jaki mysql]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 3.23.58

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>>>
[root@jaki mysql]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 3.23.58

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use zope
Can't read dir of './zope/' (Errcode: 13)
Database changed
mysql> check table members;
+------------------------+-----------+---------------+------------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+------------------------+-----------+---------------+-------------------------------------------------------------------------+
| zope.members | check | error | Can't find file: './zope/members.frm' (errno: 13) |
+--------------+--------+-----------+------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

[root@jaki mysql]# Error code 13: Permission denied
<<<

As far as I can see ownership and directory and file permissions are correct: in /var/lib/mysql
[root@jaki mysql]# ls -la ./
...
drwx------ 2 mysql mysql 4096 Apr 17 03:23 zope
...
and for the tables:
[root@jaki mysql]# ls -la ./zope
drwx------ 2 mysql mysql 4096 Apr 17 03:23 .
drwxr-xr-x 10 mysql mysql 4096 Apr 19 00:34 ..
-rw-rw---- 1 mysql mysql 8748 Mar 10 20:41 locations.frm
-rw-rw---- 1 mysql mysql 296 Apr 17 03:08 locations.MYD
-rw-rw---- 1 mysql mysql 1024 Apr 17 03:08 locations.MYI
-rw-rw---- 1 mysql mysql 9144 Mar 13 02:57 members.frm
-rw-rw---- 1 mysql mysql 2016 Apr 17 03:08 members.MYD
-rw-rw---- 1 mysql mysql 1024 Apr 17 03:08 members.MYI
-rw-rw---- 1 mysql mysql 9626 Mar 10 21:33 practise.frm
-rw-rw---- 1 mysql mysql 10140 Apr 17 03:08 practise.MYD
-rw-rw---- 1 mysql mysql 1024 Apr 17 03:08 practise.MYI
-rw-rw---- 1 mysql mysql 8592 Mar 11 03:18 special_days.frm
-rw-rw---- 1 mysql mysql 56 Apr 17 03:08 special_days.MYD
-rw-rw---- 1 mysql mysql 1024 Apr 17 03:08 special_days.MYI

I've seen many postings scattered over the internet where people struggeling with the same or similar problems. I haven't found a solution that works for me yet.

Anyone some idea?

Thanks,
--Henk

Options: ReplyQuote


Subject
Written By
Posted
Can't read dir of ...
April 18, 2005 04:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.