mysql on second drive

hello

I'm running MySQL on a secondary drive, but I'm having this problem:

mysql> drop database user_DB;
ERROR 6: Error on delete of './user_DB/table.MYI' (Errcode: 13)
as far as I could find, it is related to file system permissions, but everything seens to be fine...
the mysql datadir is /mnt/disk2/var/lib/mysql/ and here are the permissions

on /:
drwxr-xr-x 6 root root 4096 Dec 12 20:25 mnt/

on /mnt:
drwxr-xr-x 8 root root 4096 May 28 01:37 disk2/

on /mnt/disk2:
drwxr-xr-x 7 root root 4096 Mar 16 22:38 var/

on /mnt/disk2/var:
drwxr-xr-x 4 root root 4096 May 28 01:38 lib/

on /mnt/disk2/var/lib:
drwxr-x--x 304 mysql root 8192 May 28 01:58 mysql/

on /mnt/disk2/var/lib/mysql:
drwxrwx--- 2 user mysql 4096 May 26 00:54 user_DB/

on /mnt/disk2/var/lib/mysq/user_DB:
-rwxrwx--- 1 user mysql 8826 Feb 17 2004 table.frm*
-rwxrwx--- 1 user mysql 100 May 26 2004 table.MYD*
-rwxrwx--- 1 user mysql 3072 May 28 01:53 table.MYI*

any ideas?

thanks

 

 

 

 

Top