So, just to be clear, when I run: mysqlcheck -r -f <database_name>
Any fixes are recorded to the binlog and replicated to the slave? I want to be sure about this because someone in this forum said the opposite a couple of weeks ago. Thanks! --Eric -----Original Message----- From: Kishore Jalleda [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 02, 2006 8:23 AM To: Marciano Cc: Robinson, Eric; mysql@lists.mysql.com Subject: Re: Fixing Databases When Replication Is Enabled? My Sincere apologies, I intented to mean mysqlcheck but somehow came out as myisamchk :) Kishore Jalleda On 5/2/06, Marciano <[EMAIL PROTECTED]> wrote: > How myisamchk can write to binlog if the server need to be down? > > --------- Mensagem Original -------- > De: "Kishore Jalleda" <[EMAIL PROTECTED]> > Para: "Robinson, Eric" <[EMAIL PROTECTED]> > Cópia: mysql@lists.mysql.com > Assunto: Re: Fixing Databases When Replication Is Enabled? > Data: 01/05/06 22:25 > > Yes > > On 5/1/06, Robinson, Eric <[EMAIL PROTECTED]> wrote: > > I ran mysqlcheck, not myisamchk or REPAIR. Is what you said still true? > > > > -----Original Message----- > > From: Kishore Jalleda [mailto:[EMAIL PROTECTED] > > Sent: Monday, May 01, 2006 1:56 PM > > To: Robinson, Eric > > Cc: mysql@lists.mysql.com > > Subject: Re: Fixing Databases When Replication Is Enabled? > > > > On 5/1/06, Robinson, Eric <[EMAIL PROTECTED]> wrote: > > > I ran mysqlcheck against a replication master database and it > > > reported > > > > > a problem with a table, which it corrected. Is the slave now out > > > of > > sync? > > > If so, how do I correct the problem without copying the whole > > > database > > > > > over a slow WAN link? > > > > > > --Eric > > > > > > > By Default when you run REPAIR or myisamchk --recover , MySQL writes > > the changes made to the Binlog , and those will be obviously > > replicated to the slave, so if everything went fine with your > > myisamck on the master, then your slave is in sync and you don't > > have to do anyhthing special on the slave... > > > > Kishore Jalleda > > http://kjalleda.googlepages.com/projects > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > Yes > > On 5/1/06, Robinson, Eric <[EMAIL PROTECTED]> wrote: > > I ran mysqlcheck, not myisamchk or REPAIR. Is what you said still true? > > > > -----Original Message----- > > From: Kishore Jalleda [mailto:[EMAIL PROTECTED] > > Sent: Monday, May 01, 2006 1:56 PM > > To: Robinson, Eric > > Cc: mysql@lists.mysql.com > > Subject: Re: Fixing Databases When Replication Is Enabled? > > > > On 5/1/06, Robinson, Eric <[EMAIL PROTECTED]> wrote: > > > I ran mysqlcheck against a replication master database and it reported > > > > > a problem with a table, which it corrected. Is the slave now out of > > sync? > > > If so, how do I correct the problem without copying the whole database > > > > > over a slow WAN link? > > > > > > --Eric > > > > > > > By Default when you run REPAIR or myisamchk --recover , MySQL writes the > > changes made to the Binlog , and those will be obviously replicated to > > the slave, so if everything went fine with your myisamck on the master, > > then your slave is in sync and you don't have to do anyhthing special on > > the slave... > > > > Kishore Jalleda > > http://kjalleda.googlepages.com/projects > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > __________________________________ > Webmail Intercol http://www.intercol.com.br > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]