i get the following error in the connection slave->master while setting up a replication between two MySQLServer(slave and master both windows XP):
.err file on slave: MySql: ready for connections 021023 14:08:34 InnoDB: Started 021023 14:08:35 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 021023 14:08:35 Error updating slave list: Query error 021023 14:08:35 Slave I/O thread exiting, read up to log 'FIRST', position 4 what does it mean? My.ini on Master: log-bin=C:\Programmi\MySQL\Logs\MySQL-bin server-id=1 My.ini on Slave: master-host=192.168.0.4 master-user=repl master-password=<password> master-port=3306 server-id=2 set-variable = slave_net_timeout=3600 set-variable = net_read_timeout=3600 Show master status: File : MySQL-bin.001 Position : 79 Binlog_do_db : Binlog_inogne_db : ERROR No query specified Show Slave status: Master_Host : 192.168.0.04 Master_User : repl Master_Port : 3306 Connect_retry : 60 Master_Log_File : Read_Master_Log_Pos : 4 Relay_Log_File : MySQL-relay-bin.002 Relay_Log_Pos : 4 Relay_Master_Log_File : Slave_IO_Running : Yes Slave_SQL_Running : Yes Replicate_do_db : Replicate_ignore_db : Last_errno : 0 Last_error : Skip_counter : 0 Exec_master_log_pos : 0 Relay_log_space : 0 ERROR: No query specified What is wrong? Why do I get the error <No query specified>? Which type of query should I specify? Thanks in advance. Natale Babbo ______________________________________________________________________ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.com/ --------------------------------------------------------------------- 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
