multiple mysql installations?
I managed to get multiple instances of mysql to install and run(via mysqld_multi), but only by compiling the source. The system I had was Redhat9 and I used the Mysql RPM, but I couldn't get that to work, so I opted to download and compile the source. Is this the ONLY way to get multiple instances of mysql to run on one machine?
mysqld_multi
Hi, Can someone tell me how I can use mysqld_multi to have one RPM installation of MySQL(default with RedHat9) to run multiple mysqlds? Thanks -Minuk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PHP RPM + 3 binary install of Mysql-4.0.20
I have redhat9. I removed the RPM install of MySQL, and instead installed 3 copies of MySQL-4.0.20 BINARY distributions into my /usr/local/ directory, under the helpful instructions of Thierno Cisse. However, it seems like now, the PHP RPM installation cannot find the mysql extension. When I try to load up phpMyAdmin-2.5.6(after changing the port and socket values to reflect the mysql directory), I get cannot load MySQL extension, please check PHP Configuration. Documentation After prodding around, my guess is that because when I uninstalled the MySQL RPM, the MySQL extension was also removed and the PHP RPM installation can no longer locate the MySQL directory. My question is... how do I resolve this; in the case of 1 PHP installation and multiple copies of MySQL Binary distribution installations, make PHP access the correct MySQL installation?? Thanks in advance, -Minuk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
redhat9 multiple instances walkthrough
Hey, I have RedHat 9, with the default MySQL RPM pre-installed. I'd like to set up multiple instances of MySQL. That is, have multiple data directories(all with separate mysql database and tables) on different ports.(I have a few projects which share user names but different privileges). What I need, because I'm new at this is a walkthrough. I would appreciate any help you can provide, as I tried to read and follow the online documentation regarding mysqld_multi but I couldn't make heads or tails out of it - I need some working examples. Thanks in advance, -Minuk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
multiple servers on one machine?
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]