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 use a different datafile for the new data. Could partitioning come to the rescue? Although the documentation mentions that it is possible that partions reside in different physical locations ("Partitioning takes this notion a step further, by allowing you to distribute portions of individual tables across a filesystem according to rules which you can set largely as needed"), I could not find any description of how this could be done, or whether it has actually been implemented. The solution should work with either MyISAM or INNODB, or better still, be independent of the engine. Cheers, Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]