Chris, Wednesday, June 05, 2002, 3:55:52 PM, you wrote: CS> I have one product already using a mySQL database. We just inherited a new CS> product (via an acquisition) that uses it's own mySQL database which we're CS> going to stick on the same server. My manager wants me to setup a second CS> instance of mySQL on the machine for the new product's database. I don't CS> see the point. Why not just have both databases running under the same CS> instance of mySQL? Which brings me to my question. What are the pros and CS> cons of setting up multiple instances of mySQL on the same machine?
In general you can't use more than one data dir for one MySQL server, but you can create another dir for your database and create a symlinks to this dir. CS> Thanks so much, CS> CS -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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