Log into the slave and do this command mysql> mysql> show slave status\G
..... what do you see?
Also, what is in your my.cnf file on the slave?
FYI, here is instructions on how I set up replication last week http://homepage.mac.com/kelleherk/iblog/C711669388/E351220100/index.html
-Kieran
________________________________________________________________
Config = OS X 10.3.4 / Java 1.4.2 / WO 5.2.3 / XCode v1.2 / MySQL 4.0.20 / Connector-J 3.0.11
Blog: http://webobjects.webhop.org/
On Jun 24, 2004, at 9:15 AM, Rousseau, Pierre wrote:
Hi Bug Team,
I have set up a Master Slave System with MySQL 4.0.20. I've done completing every task from "6.4 How to Set Up Replication".
But my problem is :
040624 14:44:44 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4
040624 14:44:45 While trying to obtain the list of slaves from the master '164.23.43.160:3306', user 'Replikator' got the following error: 'the master returned an invalid number of fields for SHOW SLAVE HOSTS'
040624 14:44:45 Slave I/O thread exiting, read up to log 'FIRST', position 4
I have not found any support for this problem :(
Your Faithfully Pierre Rousseau
Deutsche Telekom AG T-Com, Technische Infrastruktur Niederlassung Nord Pierre Rousseau E-Mail: <mailto:[EMAIL PROTECTED]> Internet: <http://www.t-com.net>
Diese E-Mail könnte vertrauliche und/oder rechtlich geschützte
Informationen enthalten. Wenn Sie nicht der richtige Adressat sind oder
diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den
Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die
unbefugte Weitergabe dieser Mail sind nicht gestattet.
This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorised copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
