Hai
1. To use another conf file
Use this option "--defaults-file=#" to refer the default values from the file
other than /etc/my.cnf file. In t
eg:
# mysql --defaults-file=/opt/mysql/share/my.cnf
2. To change the data dir
Do the following changes to change the "data dir" other than /var/lib/mysql
In this example we are changing the dir from '/opt/mysql/var' to '/var/opt/mysql'
###########################################
file: bin/mysql_config
line 74
# ldata='/opt/mysql/var'
ldata='/var/opt/mysql'
###########################################
file: bin/mysql_install_db
line 76
#test -z "$ldata" && ldata=/opt/mysql/var
test -z "$ldata" && ldata=/var/opt/mysql
###########################################
file: bin/mysqld_safe
line 113
# DATADIR=/opt/mysql/var
DATADIR=/var/opt/mysql
###########################################
file: share/mysql/mysql.server
line 52
#datadir=/opt/mysql/var
datadir=/var/opt/mysql
line 132
#if test "$datadir" != "/opt/mysql/var"
if test "$datadir" != "/var/opt/mysql"
###########################################
Thanks
Mathan
[EMAIL PROTECTED]
www.visolve.com
----- Original Message -----
From: "tasvir rohila" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 09, 2004 2:27 PM
Subject: Multiple mysql on same linux Box.
> Hello,
>
> I have installed multiple mysql servers on the same box running Redhat linux 9.0.
> one through mysql RPM (version 3.2.54a) and other through source (version 3.2.58).
> The RPM installation has default configuration (like /etc/my.cnf, /var/lib/mysql etc
> etc). The second source installation has been configured as follows:-
> port = 4406, --prefix=/usr/local/somedir/sw/mysql/
> --localstatedir=/usr/local/somedir/db/
> --with-unix-socket-path=/usr/local/somedir/sock/mysql.sock --with-tcp-port=4406
>
> The problem is that even after specifying the prefix and localstatedir the second
> type of installation references the configuration directives from my.cnf and the
> database is installed in /var/lib/mysql and the socket and ports are from the
> default.
>
> Is there a way to run multiple mysql servers with different ports, database
> directories and different sockets on Redhat 9.0 ???
>
> any help in this regard is appreciated...in advance.
>
> thanks
>
> Tasvir
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Finance: Get your refund fast by filing online
