Hi!
InnoDB does not work on a read-only file system. It needs to write to data
files and ib_logfiles. For example, the transaction id advances also with
SELECT queries, and we need to write it to the files.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
----- Original Message -----
From: "superfly" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, November 23, 2005 7:32 PM
Subject: Re: MySQL with InnoDB on a readonly filesystem.
Ralph,
Not sure why your trying to open a innodb file on a read-only
filesystem.
Personally I'd place the innod onto a read-write file syste, and grant
the users connect and select priveleges only.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
