Thanks Kevin! I see what you're saying. That would mean I would have a common 'mysql' database though (for the db, user, func tables, etc). I thinks that's acceptable in my case. (I assume I don't need to update these tables if I want to add a 'link' to a new database somewhere, and that 'USE' would auto-detect any new directory.)
I'll probably do a little experimenting in Windows soon (since I'm trying to be portable, or maybe I should stop supporting Windows, hmm). Thanks again! Marlon -----Original Message----- From: Kevin [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 6:39 PM To: Baculio, Marlon; [EMAIL PROTECTED] Subject: RE: Different DB directories against one MySQL Hi Marlon, Under linux mysql will 'see' any databases you've got links in the folder you've configured it to look. So in my /var/lib/mysql I have a symlink to /db/Allpoetry, and it knows to look there for the data files. So each database can have its own directory. You could probably even symlink the tables to files on other odd places if you wanted too. I assume the same thing is possible under windows. I know cygwin does symlinks, but don't know if the windows mysql will follow them, or if it follows shortcuts otherwise anyways. Not sure what the efficiency problems of running a database from a cdrom would be either, but it'd be an interesting experiment :) Ciao, Kevin Watt Community Manager, Allpoetry.com What happened to the cow who went for a drive? He got a Moo_ving violation What do you call someone who is crazy about hot chocolate? A cocoa nut What do bees use to cut wood? Buzz saws Who eats at underwater resturants ? Suba diners How do really small people call each other ? On Microphones How do you fix a broken chimp? With a monkey wrench > -----Original Message----- > From: Baculio, Marlon [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 24, 2003 3:32 PM > To: [EMAIL PROTECTED] > Subject: Different DB directories against one MySQL > > I'm trying to have MySQL connect to different filesystems (mostly in > read-only mode). I've tried setting the read-only attribute of my files > under my database directory under "c:\mysql\data" and MySQL seems to be > able to SELECT it with no problem (I then tried doing an INSERT and it > came up with an error message, which is perfect). Hopefully, this would > also work if my database directory is in CDROM even if the MySQL > binaries are in writable hard disk. > > My question is: Is it possible to have a single instance of MySQL where > each connection might have a different data directory? For example, I > have a user that needs to query data from a CDROM, and there's another > one that needs to query some tape backup. If not, I am assuming it > should be OK to run multiple instances of MySQL (on different ports) and > just have them point to different data paths (unless you guys know of a > more elegant solution). > > Thanks! > > Marlon > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
