Is it possible to create mulitple database directories ... with one of them
on a CD-ROM?
One of the databases our app uses is an 'archive', and once a record is
written to it, that record is never altered or updated. Each night, a daemon
runs through the archive, 'indexes' it and writes out a pair of files that
are part of the full-text search engine we use. As the database grows, the
amount of time required to build the FTS indexes increases.
The FTS engine is being upgraded to handle multiple databases, and there is
some thought being given to breaking the archive database by years. When
2001 is over, we would rename the archive database (arc2001) and store it
(along with its FTS indexes) with arc1998, arc1999, arc2000, etc.
We currently store the databases in the tree MySQL's installer creates. Can
you have a second data directory, which would a device like a CD-ROM?
Gerald Jensen
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
