Try, adding

master-port=3306 (or the numebr you are using)

to my.ini (slave file) under [mysqld].

I think it is in the manual.

Andrés.

----- Original Message -----
From: Remco Ploeg <[EMAIL PROTECTED]>
To: Mysql (E-mail) <[EMAIL PROTECTED]>
Sent: Friday, January 04, 2002 8:59 AM
Subject: mysql replication


Goodmorning,
I have two machines running mysql (win nt) They are running now, in the
slave data dir, i see that the slave is connected to the master:

Slave: connected to master [EMAIL PROTECTED], replication started in log
'FIRST' at postition 305

But when I insert data into the master, the slave does not update that. Do I
have to use a command to do that.
This is my ini file of the master:
#This File was made using the WinMySQLAdmin 1.3 Tool
#14-12-2001 13:24:25

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
log-bin
server-id=1
basedir=C:/mysql
#bind-address=60.0.1.219
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=root
password=xxx

And this is the slave:
[WinMySQLAdmin]
Server=C:/MYSQL/bin/mysqld-opt.exe
user=root
password=xxxxxx

[mysqld]
master-host=50.0.1.219
master-user=repl
master-password=xxxxx
server-id=2
basedir=C:/MYSQL
#bind-address=50.0.1.138
datadir=C:/MYSQL/data
#language=C:/MYSQL/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M


Do you know what is wrong?

thanks in advance,

Remco Ploeg
The Netherlands


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to