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
