Hello, > > 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.
i did exactly that, checked md5sums on all files and whether mysql user can create/read/write to mysql's data directory. then i start master, and in its datadir 3 files show up: mysql log, binary log and index file after that i start slave, and in its datadir 2 files show up: mysql log and master.info file. in mysql log i can read: 020603 14:49:18 mysqld started /usr/sbin/mysqld: ready for connections 020603 14:49:18 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 020603 14:49:18 Slave: received 0 length packet from server, apparent master shutdown: (0) 020603 14:49:18 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 35 020603 14:49:18 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 35 020603 14:49:18 Slave: received 0 length packet from server, apparent master shutdown: (0) what am i doing possible wrong ? 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
