More than likely you have missed the step that the slave database has to be the exact one that the master has before the start of the binlog. Shutdown both servers, grab a copy of the master's data directory and tar that up, move that to the slave, delete the slave's current data directory, now untar the master's data dir in appropriate place on the slave (/usr/local/mysql in most cases), then make sure the permissions on the files a right (basically the mysql user must be able to read & write to the files & the directory), then restart the master, then finally restart the slave. Once that is done test replication by going to the master and creating a database, then check on the slave to ensure its there with a show databases.
Scott Helms ----- Original Message ----- From: "Bartomiej Dolata" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 31, 2002 7:59 AM Subject: replication problem > 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. > > 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
