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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
