LinuxQuestions.org - fc5 multiple MySQL servers

- Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)

- - fc5 multiple MySQL servers (https://www.linuxquestions.org/questions/linux-software-2/fc5-multiple-mysql-servers-449907/)

fc5 multiple MySQL servers

Hi,
I'm trying to setup two MySQL server on my Fedora Core 5 box. MySQL 5.x has been preinstalled, but in addition I would like to install MySQL 4.1.19, so that both servers can run at the same time.
I have been searching the web for almost 2 days now, but can't find a guide that would work. The best I've found is "bobcares.com/article44.html". However, when it comes to compiling the server, it spits out the following errors, and quits:

Code:

make[3]: *** No rule to make target 'my-small.conf.sh', needed by 'my-small.conf'. Stop.

make[3]: Leaving directory '/tmp/mysql-4.1.19/support-files'

make[2]: *** [all-recursive] Error 1

make[2]: Leaving directory '/tmp/mysql-4.1.19/support-files'

make[1]: *** [all-recursive] Error 1

make[1]: Leaving directory '/tmp/mysql-4.1.19'

make: *** [all] Error 2

Can anyone help me plz? Does anyone know of a good guide, that contains step-by-step instructions on how to setup multiple MySQL server on fc5? I have only basic knowledge of Linux, so a simple guide or instructions would be great, but any help is greatly appriciated.

Thanks... :confused:

Is there any reason why you want to compile this yourself ? I would suggest downloading a precompiled tar.gz binary from http://dev.mysql.com site (I run fedora core 5 as well and just tried that with "Linux (non RPM, Intel C/C++ compiled, glibc-2.3) downloads" > Linux (x86)).

Once unpacked, you can start the server with the command /path/to/mysqlinstall/bin/mysqld.

You will have to configure mysql with a different data dir/socket/network port than the other server if you want both of them to run at the same time. Issue a "/path/to/mysqlinstall/bin/mysqld --verbose --help" to see all option you can set (including setting all the formers options directly on the command line or specifying a specific my.cnf config file).

Examples:

Code:

/path/to/mysqlinstall/bin/mysqld --defaults-file=/etc/alternatemy.cnf



/path/to/mysqlinstall/bin/mysqld --no-defaults \

--basedir=/path/to/mysqlinstall --datadir=/var/lib/alternate-mysql \

--log=/var/log/mysql --pid-file=/var/run/mysql/alternate-mysql.pid \

--user=mysql --port=3308 etc...

Thanks for your help zeitounator! I've managed to get bit further now :). I've just got two more questions regarding this installation. I have unpacked the tar.gz file that I've downloaded from the mysql website, and ran the ../bin/mysqld --....stuff... command. After creating some directories passed as paramaters, the server seems to startup although I get "Table 'mysql.host' doesn't exist" along with some other error messages.
What directories are generally used for mysql? Where is the basedir, datadir, etc. normally?
How do I get the MySQL server to startup with all those parameters at boot time?
Once again, thanks for your help.

This message just means the base mysql tables are not yet installed. In the mysql distribution you unpacked, you should have a "mysql-install-db" script.