On Thu, 27 Jun 2002 17:37:24 -0700
Patelli Paolo <[EMAIL PROTECTED]> wrote:
> mysql> SHOW MASTER STATUS;
> +----------------+----------+--------------+------------------+
> | File | Position | Binlog_do_db | Binlog_ignore_db |
> +----------------+----------+--------------+------------------+
> | keynes-bin.023 | 399 | | |
> +----------------+----------+--------------+------------------+
>
> On slave:
> mysql> SHOW SLAVE STATUS;
>
>+-------------+-------------+-------------+---------------+----------+-----+---------------+-----------------+---------------------+------------+------------+--------------+
> | 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 |
>
>+-------------+-------------+-------------+---------------+----------+-----+---------------+-----------------+---------------------+------------+------------+--------------+
> | keynes | repl | 3306 | 60 | | 31 |
> Yes | | | 0 |
> | 0 |
>
>+-------------+-------------+-------------+---------------+----------+-----+---------------+-----------------+---------------------+------------+------------+--------------+
go to your slave server ...
and do this query
"slave stop;change master to master_log_file="keynes-bin.023;change master to
master_log_pos=4;slave start;"
--
Let's call it an accidental feature.
-- Larry Wall
sql,query
---------------------------------------------------------------------
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
