RE: Attempting to re-install MySQL - Paul DuBois - com.mysql.lists.win32

20 messages in com.mysql.lists.win32RE: Attempting to re-install MySQL

From	Sent On	Attachments
Degan, George E, JR, MGSVC	24 Jul 2003 08:38
Paul DuBois	24 Jul 2003 08:47
Degan, George E, JR, MGSVC	24 Jul 2003 08:49
Degan, George E, JR, MGSVC	24 Jul 2003 08:52
Paul DuBois	24 Jul 2003 09:02
Paul DuBois	24 Jul 2003 09:04
Degan, George E, JR, MGSVC	24 Jul 2003 09:24
Degan, George E, JR, MGSVC	24 Jul 2003 10:35
Degan, George E, JR, MGSVC	24 Jul 2003 10:37
Paul DuBois	24 Jul 2003 11:35
Degan, George E, JR, MGSVC	24 Jul 2003 12:29
Paul DuBois	24 Jul 2003 12:56
Edwards	24 Jul 2003 13:18
Paul DuBois	24 Jul 2003 13:33
Edwards	24 Jul 2003 14:31
Degan, George E, JR, MGSVC	25 Jul 2003 04:59
Paul DuBois	25 Jul 2003 17:31
Degan, George E, JR, MGSVC	28 Jul 2003 07:41
Paul DuBois	28 Jul 2003 21:52
Degan, George E, JR, MGSVC	29 Jul 2003 11:55

Subject:	RE: Attempting to re-install MySQL
From:	Paul DuBois (pa...@mysql.com)
Date:	07/24/2003 11:35:08 AM
List:	com.mysql.lists.win32

At 12:35 -0500 7/24/03, Degan, George E, JR, MGSVC wrote:

The mysqld --console is still running in one cmd prompt window and I have gone through the steps in 4.1.3 to install/run multiple servers. As stated before:

You probably want to shut down that server now, given that you'll be running two other servers as services.

I am running Windows 2000, Version 5.0 (build 2195, Service Pack 2) (In case it matters, I have about 20 GB available on my 40GB hard drive and 192MB of RAM. I haven't invoked mysql yet, so I don't use any options as yet. 4.0.13 is in folder C:\mysql-4.0.13 extracted with the setup utility provided. 4.1.0 was simply extracted to folder C:\mysql-4.1.0.

C:\my.cnf is as follows:

# options for default service (MySql) [mysqld] basedir = C:/mysql-4.0.13/mysql port = 3306

#options for default service (mysqld2) [mysqld2] basedir = c:/mysql-4.1.0/mysql port = 3307 protocol = mypipe2

C:\my-opts1 is as follows:

[mysqld] basedir = C:/mysql-4.0.13/mysql datadir = C:/mysql-4.0.13/mysql/data port = 3306

C:\my-opts2.cnf is as follows:

[mysqld2] basedir = C:/mysql-4.1.0/mysql datadir = C:/mysql-4.1.0/mysql/data port = 3307 protocol = mypipe2

I noticed a mysql.opt and it has (I didn't create this so I don't know if it was part of the setup file, so I don't know where to find the file: \.mysql_history or if it is pointing to the right directory) :

# Options file generated by MySQL client

Uh, no, sorry. The "mysql" client doesn't create any option file. You must mean something else.

user=root host=localhost port=3306 num_of_queries=100 timeout=60 defbase= socket= queries_file=/.mysql_history queries_root= last_database_file= terminator=, enclose=' password=1 compress=0 ask=1 max_width=50 update_timeout= 10.00 font_used= style_file=

and C:\WINNT\my.ini is a very elegant ;-):

[WinMySQLAdmin] Server=C:/mysql-4.0.13/mysql/bin/mysqld.exe

When I attempt the following:

C:\mysql-4.1.0\mysql\bin>c:\mysql-4.0.13\mysql\bin\mysqld-nt --install --default s-file=c:\my-opts1.cnf

and:

C:\mysql-4.1.0\mysql\bin>c:\mysql-4.1.0\mysql\bin\mysqld-nt --install mysqld2 -- defaults-file=c:\my-opts2.cnf

Both come back with the following:

Service successfully installed.

Good.

However when I invoke mysql (from c:\mysql-4.0.13\mysql\bin and c:\mysql-4.1.0\mysql\bin respectively I go into mysql and get this:

Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 [2 for the second one] to server version: 4.0.13-max-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

Shouldn't the one invoked from c:\mysql-4.1.0\mysql\bin com back with server version: 4.1.0?

No. Why should it?

You didn't tell it which server to connect to, so it uses the default port, which is 3306. That's the port that the 4.0.13 server is listening to.

Use -P 3307 on the command line to connect to the other server.

What am I missing?

I suspect that you have an idea in your head about how you want things to work in a multi-server setup, and you're assuming that programs will "just know" what you want them to do without being told.

As you're discovering, that's not happening. MySQL is highly configurable, and in a complex situation with multiple servers, you're going to have to tell the programs how you want them to operate.

Are you MySQL certified? http://www.mysql.com/certification/