On Thu, May 22, 2008 at 5:36 PM, Salah Nait-Mouloud < [EMAIL PROTECTED]> wrote:
> Hi all. > > I have 2 MySQL servers. > One master and one slave. > In order to add new slave server, and because i can't stop the master one, > i > have tried this: > > http://forums.mysql.com/read.php?26,99846,102058 > > " > *You don't have to modify the other slaves configuration. What you need to > do is obtain a snapshot of the data on those slaves with their current > position relative to the master. The easiest way to do this is to stop > mysql > on one of the slaves and copy it's data directory (except for the bin logs) > and my.cnf to the new slave. Then start the old slave so it doesn't get too > far behind in replication. On the new slave change the server-id in my.cnf > so it's unique from the other servers. Add skip-slave to my.cnf. Start > mysql, login and run show slave status\G Then run the following command > substituting the $values from the show slave status > > change master to master_log_file='$Relay_master_log_file', > master_log_pos=$Exec_master_log_pos; > > Then start the new slave; > > Once replication catches up it's good to go :)* > " > > The issue is when i do "START SLAVE;" i obtain this error: > > Slave_IO_Running: Yes > Slave_SQL_Running: No > Replicate_Do_DB: > Replicate_Ignore_DB: > Replicate_Do_Table: > Replicate_Ignore_Table: > Replicate_Wild_Do_Table: > Replicate_Wild_Ignore_Table: > Last_Errno: 1146 > Last_Error: Error 'Table 'XXXXXX.yyyyyyyyy' doesn't exist' > on query. Default database: 'XXXXXXXX'. Query: 'INSERT INTO > yyyyyyyyy ' .... > > MySQL Server version: version 5.0.32 . > > Any idea ? It looks like you started at a position that after an INSERT. So your position is wrong. > > Many Thanks. > -- > Salah NAIT-MOULOUD > Echovox - www.echovox.com > m-Boost - www.m-boost.com >
