Whil Hentzen wrote:
> Baron Schwartz wrote:
>> Whil Hentzen wrote:
>>> Michael Dykman wrote:
>>>> if you see no errors, check your config... are you sure InnoDB is
>>>> enabled ?
>>>
>>> I can create a new database and add InnoDB tables to it without
>>> problems.
>>>
>>> Ack, I lied. No error in the /var/lib/mysql, but there IS an error
>>> file in /var/logs, and it contains:
>>>
>>> "./ibdata1: error 13 in a file operation"
>>> "mysqld does not have access rights to the directory"
>>>
>>> But..... I'm sitting here looking and I can't see any difference
>>> between the ibdata1 and the ibdata1_orig files, nor the folders that
>>> contain the .frm files either.
>>
>> Ownership and permissions are both identical?
>
> As best as I can tell - here's the remote machine list:
>
> drwxr-xr-x 11 mysql mysql 4096 Sep 11 18:29 .
> drwxr-xr-x 33 root root 4096 May 10 11:17 ..
> drwx------ 2 mysql mysql 4096 Sep 11 13:22 delme
> drwx------ 2 mysql mysql 4096 Sep 11 14:19 delmeinno
> -rw-r----- 1 mysql mysql 10485760 Sep 11 17:10 ibdata1
> -rw-rw---- 1 mysql mysql 10485760 Sep 11 14:19 ibdata1_5
> -rw-r----- 1 mysql mysql 5242880 Sep 11 17:10 ib_logfile0
> -rw-rw---- 1 mysql mysql 5242880 Sep 11 14:20 ib_logfile0_5
>
> There are two databases here.
>
> delme is MyISAM. Works fine.
> delmeinno is the InnoDB. The original works fine.
>
> ibdata1 and ib_logfile0 are the original InnoDB files. They work fine.
>
> ibdata1_5 and ib_logfile0_5 are the InnoDB files that were copied from
> the local box. Yes, i see that these have 'w' permissions for mysql
> group but I can't see why that would matter or cause the error that is
> occurring.

Give it a try making the permissions identical anyway and just see what
happens. There might be something funny going on, such as the server
running as a different group than you think.

Baron