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.

When I get rid of the ibdata1 and ib_logfile0 files (move them
elsewhere), and then rename the '5's so that MySQL tries to access
those, the MySQL server won't start.

Whil