No ... I'm just setting up the replication for the first time. I make a dump of the master and i replaced it on the slave.
thanks and bye. --- Victor Pendleton <[EMAIL PROTECTED]> ha scritto: > Has the replication worked previously for you? > If so, have you reset the master and the slave? > Was a snapshot of the master placed on the slave > before beginning > replication? > I hate to ask such simple questions but I am just > checking. > > Victor > > -----Original Message----- > From: Natale Babbo > To: [EMAIL PROTECTED] > Sent: 10/23/02 8:22 AM > Subject: mysql replication error > > 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 ______________________________________________________________________ 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
