4 messages in com.mysql.lists.mysqlRe: (Errcode: 13) after moving data d...| From | Sent On | Attachments |
|---|---|---|
| boll | 20 Apr 2006 21:18 | |
| Dominik Klein | 21 Apr 2006 06:47 | |
| boll | 21 Apr 2006 08:54 | |
| boll | 25 Apr 2006 12:57 |
| Subject: | Re: (Errcode: 13) after moving data directory |
|---|---|
| From: | boll (bo...@sonic.net) |
| Date: | 04/21/2006 08:54:27 AM |
| List: | com.mysql.lists.mysql |
Dominik Klein wrote:
Did you check FAT-permissions? When mounting a FAT-partition, you have to set explicit permissions while mounting as FAT does not understand the unix permission concept.
Try to mount this way: mount -t vfat -o uid=mysql,gid=mysql,rw,umask=007 /dev/[yourdevicename] /your/mountpoint
Hi Dominik,
In /etc/fstab the partition is mounted with this line: /dev/hdb2 /mnt/FAT vfat uid=27,gid=27,umask=000 0 0 ...which I think is the same as what you recommend (uid 27 is "mysql") .
What I really don't understand is: Why mysqld will start up and use the dataq on the FAT partition (as I want it to do) if I start it with "mysqld_safe", but when I boot the computer or try, as root, "service mysqld start", it fails to start with these log errors: 060421 08:43:10 mysqld started 060421 8:43:11 [Warning] Can't create test file /mnt/FAT/mysqldata/localhost.lower-test /usr/libexec/mysqld: Can't change dir to '/mnt/FAT/mysqldata/' (Errcode: 13) 060421 8:43:11 [ERROR] Aborting
I'm guessing that since mysqld_safe runs as user mysql, maybe mysqld runs as a different user? How would I find that out?
I will keep reading the manual, but will be grateful for any ideas.