LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 05-30-2006, 08:50 AM   #1
jerryau
LQ Newbie
 
Registered: May 2006
Posts: 6

Rep: Reputation: 0
Question 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...
 
Old 05-30-2006, 09:34 AM   #2
zeitounator
Member
 
Registered: Aug 2003
Location: Montpellier, France, Europe, World, Solar System
Distribution: Debian Sarge, Fedora core 5 (i386 and x86_64)
Posts: 262

Rep: Reputation: 30
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...
 
Old 05-30-2006, 12:30 PM   #3
jerryau
LQ Newbie
 
Registered: May 2006
Posts: 6

Original Poster
Rep: Reputation: 0
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.
 
Old 06-01-2006, 12:38 AM   #4
zeitounator
Member
 
Registered: Aug 2003
Location: Montpellier, France, Europe, World, Solar System
Distribution: Debian Sarge, Fedora core 5 (i386 and x86_64)
Posts: 262

Rep: Reputation: 30
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple servers acasaamj Linux - General 1 06-10-2005 12:09 AM
multiple mysql servers on 1 server stoffell Debian 1 03-01-2005 07:28 AM
Multiple X servers Stephanie Linux - General 2 02-27-2003 02:32 PM
multiple x servers?? icyfire Linux - Software 2 11-12-2002 01:42 AM
multiple X servers acid_kewpie Linux - General 1 11-11-2001 03:06 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 06:45 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration