Re: Multiple MySQL db's on one machine
Paul DuBois wrote: It may be that the person was thinking of the InnoDB tablespace. The InnoDB storage handler manages all InnoDB tables within a single tablespace, no matter which database they come from. But even so, each database has its own directory, and InnoDB tables do have a .frm file in the appropriate database directory. I made this very statement (on this list), FYI, and it was directly regarding InnoDB tables as part of a thread about difficulties of using InnoDB and disk quotas together. I don't know if I'm the person, but if I am ... :) -- Michael T. Babcock C.T.O., FibreSpeed Ltd. (SQL) http://www.fibrespeed.net/~mbabcock - 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
Re: Multiple MySQL db's on one machine
From: Paul DuBois [EMAIL PROTECTED] At 16:04 -0800 12/9/02, tmb wrote: I thought MySQL created a seperate directory for each db put each db's files in their respective folder... That's correct. However, a small complication to my answer: Another small complication: the individual DB directories all need to be in the same parent directory. However, they can be symlinks to other, unrelated locations. - SQL SQL SQL SOL - -- : Jan Steinman -- nature Transography(TM): http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Buy My Step Van! http://www.Bytesmiths.com/van - 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
Re: Multiple MySQL db's on one machine
At 16:04 -0800 12/9/02, tmb wrote: I was told that if you had multiple MySQL db's on a single machine... that actually it was really only one db with tables for for db1, db2, db3... ??? This doesn't sound right. Ask the person that told you this for evidence to support the claim. I thought MySQL created a seperate directory for each db put each db's files in their respective folder... That's correct. However, a small complication to my answer: It may be that the person was thinking of the InnoDB tablespace. The InnoDB storage handler manages all InnoDB tables within a single tablespace, no matter which database they come from. But even so, each database has its own directory, and InnoDB tables do have a .frm file in the appropriate database directory. true or not ? thanks - tmb - 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