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]
