Re: writing to a database on a read-only medium

2006-04-11 Thread Frank
sheeri kritzer wrote: > Frank, > > 1) Check out the FEDERATED storage engine, that might help. > > 2) You cannot specify a different location for a read database and a > write database. > > 3) Another solution is to use multiple databases -- each database is > just a directory, so you could

Re: writing to a database on a read-only medium

2006-04-07 Thread sheeri kritzer
Frank, 1) Check out the FEDERATED storage engine, that might help. 2) You cannot specify a different location for a read database and a write database. 3) Another solution is to use multiple databases -- each database is just a directory, so you could try to symlink: ie, if your datadir is /

writing to a database on a read-only medium

2006-04-07 Thread Frank
Hi, is there a possibility to configure a MySQL database in such a way that I can store the database on a read-only medium (say a CD), but still be able to write to the database (without having to copy the datafiles to disk or memory first)? What I have in mind is something like telling MySQL to