M-S出错

MYSQLER

restart mysql and flush logs what is the difference between

yueliangdao0608

原帖由 MYSQLER 于 2008-5-23 13:26 发表
restart mysql and flush logs what is the difference between

They both generate a new log file.

MYSQLER

I already restart mysql, the problem remains!

yueliangdao0608

原帖由 MYSQLER 于 2008-5-23 14:07 发表
I already restart mysql, the problem remains!

You just restart your mysql?

Remember to reset the  parameters master_log_file and master_log_pos.

MYSQLER

I just restart the mysql。

How to do ?

MYSQLER

还是用中文吧

我现在想知道的是如何重新设置
master_log_file 和master_log_pos.
请指教一下，我现在正在弄呢

MYSQLER

月亮呢

yueliangdao0608

原帖由 MYSQLER 于 2008-5-23 14:56 发表
还是用中文吧

我现在想知道的是如何重新设置
master_log_file 和master_log_pos.
请指教一下，我现在正在弄呢

change master_log_file = ...,master_log_pos= ...;

voxxu

原帖由 MYSQLER 于 2008-5-23 14:56 发表
还是用中文吧

我现在想知道的是如何重新设置
master_log_file 和master_log_pos.
请指教一下，我现在正在弄呢

change master to  语句
先slave stop先,改好了再start

MYSQLER

原帖由 yueliangdao0608 于 2008-5-27 11:17 发表


change master_log_file = ...,master_log_pos= ...;

这是我的错误日志

1. May 23 09:31:51 webserver mysqld[16218]: 080523  9:31:51 [ERROR] Got fatal error 1236: 'Client requested master to start replication from impossible position' from master when reading data from binary log
   
2. May 23 09:31:51 webserver mysqld[16218]: 080523  9:31:51 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000138', position 13810120

复制代码

那我的master_log_file=mysql-bin.000138还是master_log_file=mysql-bin.000139?

master_log_pos=?这个值从哪里得到？看很多文章都写4？为什么？