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