Re: MySQL with InnoDB on a readonly filesystem.

2005-11-25 Thread Heikki Tuuri
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

Re: MySQL with InnoDB on a readonly filesystem.

2005-11-24 Thread Ralph Koning
Jeremy Cole wrote: Is it possible to run MySQL with InnoDB enabled on a readonly filesystem. We only intend to run some select query's on this server. I guess I can ask the obvious question. Why are you trying to use InnoDB, if your data/filesystem is read only? Why not use MyISAM inste

Re: MySQL with InnoDB on a readonly filesystem.

2005-11-23 Thread Jeremy Cole
Hi Ralph, Is it possible to run MySQL with InnoDB enabled on a readonly filesystem. We only intend to run some select query's on this server. I guess I can ask the obvious question. Why are you trying to use InnoDB, if your data/filesystem is read only? Why not use MyISAM instead? Regards,

MySQL with InnoDB on a readonly filesystem.

2005-11-23 Thread Ralph Koning
Hello, Is it possible to run MySQL with InnoDB enabled on a readonly filesystem. We only intend to run some select query's on this server. This is the errormessage from InnoDB Nov 23 13:36:30 aliao mysqld[16073]: InnoDB: Error number 30 means 'Read-only file system'. Nov 23 13:36:30 aliao mysqld