Hi, I already had a similar problem. I did the following things: I zipped my master database to unzip it on the slave and then I did a "reset master",that's it. The reason why you have this problem it's certainly due to the fact that your master and slave database are not identical.
you didn't talk about it, but I suppose that you granted the slave to make file access on master. http://www.mysql.com/doc/R/e/Replication_HOWTO.html Frederic ----- Original Message ----- From: "Terry" <[EMAIL PROTECTED]> To: "Mysql@Lists. Mysql. Com" <[EMAIL PROTECTED]> Sent: Thursday, June 06, 2002 9:29 AM Subject: replication problem > i am sending it again, maybe this time someone would help ... :) > > > hello, > > > > i have major problem with setting up replication. > > > > both ends are running mysql 3.23.49 > > i have set up proper entries in my.cnf on both sides and > > have replicated the dbs. > slave's data directory is exactly the same as master's data dir. > then, i start master, then slave > > > > > now, > > > > on master: > > show master status reads: > > +--------------------+----------+--------------+------------------+ > > | File | Position | Binlog_do_db | Binlog_ignore_db | > > +--------------------+----------+--------------+------------------+ > > | bdnotebook-bin.001 | 758 | | | > > +--------------------+----------+--------------+------------------+ > > 1 row in set (0.00 sec) > > > > show processlist reads: > > | 4 | root | linux.compfort | NULL | Binlog Dump | 1212 | Slave > > connection: wa > > iting for binlog update | NULL | > > > > now on slave: > > > > show slave status reads: > > | Master_Host | Master_User | Master_Port | Connect_retry | > > Log_File | > > Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | > > Last_errno | Last_error | Skip_counter | > > +-------------+-------------+-------------+---------------+- > > ---------+ > > -----+---------------+-----------------+-------------------- > > -+-------- > > ----+------------+--------------+ > > | 10.0.0.111 | rep | 3306 | 30 | > > | > > 35 | Yes | | | 0 > > | | 0 | > > +-------------+-------------+-------------+---------------+- > > ---------+ > > -----+---------------+-----------------+-------------------- > > -+-------- > > ----+------------+--------------+ > > > > show processlist: > > | 1 | system user | none | NULL | Connect | 294 | Waiting to > > reconnect after a failed read | NULL | > > > > in slave's logfiles i see these errors: > > 020531 14:04:08 Slave: Failed reading log event, reconnecting to > > retry, log 'FIRST' position 35 > > 020531 14:04:08 Slave: reconnected to master > > '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position > > 35 > > 020531 14:04:08 Slave: received 0 length packet from > > server, apparent > > master shutdown: (0) > > > > and the databases are not being updated. > > > > what am doing possibly wrong ? have i missed something ? > > > > please help :> > > > > terry > > > > > > > > ------------------------------------------------------------ > > --------- > > 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 > --------------------------------------------------------------------- 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
