Hi, I want to set up 3 independent MySQL databases. What I mean by independent is that...
I've got a program which requires the MySQL backend which I am currently debugging and applying various tweaks. I've also got 2 projects which requires a different architecture(in MySQL). These projects, when done, would be hosted on separate servers. Currently, I only have one system in which I use for development/testing of the programs. Because of the nature of these database structures, I use phpMyAdmin to get a database dump of all the tables and values(including the mysql table) on a given project. I couldn't find any information which can tell me how I can set up one system(RedHat9) to have 3 data tables(on 3 separate ports, of course). mysqld_multi seemed promising... except I couldn't understand the manual online, nor was I able to get it to work. It also sounded like I had to create a "multi_admin" user in all servers. Normally, I wouldn't prefer to have a superflous account(multi_admin)... but I'm desperate. Has someone got this to work? That is, have multiple servers on one machine? Can someone direct me to a WALKTHROUGH? The directions I found on http://dev.mysql.com/doc/mysql/en/Multiple_servers.html were not of much help to me. Thanks in advance, -Mk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]