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]
