» Quick Links
You can make money on these forums
We Share profits with you
Google
Google Adsense
Google Adwords
YPN
Yahoo
MSN Search
Web Directories
Web Hosting
Web Hosting Offers
Hosting News
Suggestions
Link Building
Domain Names
PHP Forums
MySQL Forums
» More Links
OSP News
Reseller Hosting
Shared Hosting
Dedicated Servers
Google Adsense
Search Engine Marketing
Link Development
Affiliate Marketing


» Advertising
Multiple DC PR Check

Free SEO Tools


Go Back   Webmaster Forums > Website Developement / Programming > MySQL Forums

MySQL Forums Share Your Ideas and Tips about MYSQL. Ask questions about MYSQL. Table Design and Much More...

Reply
 
Thread Tools Display Modes
  #1  
Old 12-09-2005, 06:04 AM
omen omen is offline
Junior Member
 
Join Date: Dec 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
omen is on a distinguished road
Default MySQL 5 and MySQL 4.1 on One Machine ??

I'd like to install MySQL 5 on a server that already run MySQL 4.1, but keep it listening on another TCP port. Ive put MySQL 5 in /usr/local/mysql5 and /home/mysql5 instead and I use /etc/my5.cnf.
All goes well until I try to start MySQL5 when I get:

"A mysqld process already exists"

Is it possible to run multiple MySQL servers on one machine?
Thanks in Advance. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
Revenue Sharing Ads ( ?):
  #2  
Old 12-09-2005, 06:07 AM
programmers programmers is offline
OSP Starters
 
Join Date: Dec 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
programmers is on a distinguished road
Smile Solution

It was much more complex than it should be. I had to change the mysql.server script a whole lot until it worked...
Below is whats working for


#!/bin/sh

PATH=/sbin:/usr/sbin:/bin:/usr/bin:$basedir/bin
export PATH

basedir=/usr/local/mysql5
datadir=/home/mysql5
bindir=/usr/local/mysql5/bin
pid_file=/home/mysql5/goofy.pid
server_pid_file=/home/mysql5/goofy.pid
user=mysql5

#
# Use LSB init script functions for printing messages, if possible
#
lsb_functions="/lib/lsb/init-functions"
if test -f $lsb_functions ; then
source $lsb_functions
else
log_success_msg()
{
echo " SUCCESS! $@"
}
log_failure_msg()
{
echo " ERROR! $@"
}
fi

wait_for_pid () {
i=0
while test $i -lt 35 ; do
sleep 1 -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
Reply


Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL failing? Blinck MySQL Forums 1 01-04-2007 06:08 AM
Installing mysql on BSD Jansher MySQL Forums 1 12-26-2006 08:02 AM
Getting MySQL & PHP to communicate JCH MySQL Forums 0 05-29-2006 01:52 PM
Alcatel Selects MySQL AB outsourcingplans Web Hosting News 0 12-13-2005 04:03 PM
MySQL 5.1.3-alpha has been released gunet MySQL Forums 0 12-09-2005 03:55 AM


All times are GMT. The time now is 03:36 AM.