List:General Discussion« Previous MessageNext Message »
From:Kishore Jalleda Date:May 2 2006 3:23pm
Subject:Re: Fixing Databases When Replication Is Enabled?
View as plain text  
My Sincere apologies,  I intented to mean mysqlcheck but  somehow came
out as  myisamchk   :)

Kishore Jalleda

On 5/2/06, Marciano <marciano@stripped> wrote:
> How myisamchk can write to binlog if the server need to be down?
>
> --------- Mensagem Original --------
> De: "Kishore Jalleda" <kjalleda@stripped>
> Para: "Robinson, Eric" <eric.robinson@stripped>
> Cópia: mysql@stripped
> Assunto: Re: Fixing Databases When Replication Is Enabled?
> Data: 01/05/06 22:25
>
> Yes
>
> On 5/1/06, Robinson, Eric <eric.robinson@stripped> wrote:
> > I ran mysqlcheck, not myisamchk or REPAIR. Is what you said still true?
> >
> > -----Original Message-----
> > From: Kishore Jalleda [mailto:kjalleda@stripped]
> > Sent: Monday, May 01, 2006 1:56 PM
> > To: Robinson, Eric
> > Cc: mysql@stripped
> > Subject: Re: Fixing Databases When Replication Is Enabled?
> >
> > On 5/1/06, Robinson, Eric <eric.robinson@stripped> 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/mysql?unsub=1
> >
> >
>
> --
>
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
> Yes
>
> On 5/1/06, Robinson, Eric <eric.robinson@stripped> wrote:
> > I ran mysqlcheck, not myisamchk or REPAIR. Is what you said still true?
> >
> > -----Original Message-----
> > From: Kishore Jalleda [mailto:kjalleda@stripped]
> > Sent: Monday, May 01, 2006 1:56 PM
> > To: Robinson, Eric
> > Cc: mysql@stripped
> > Subject: Re: Fixing Databases When Replication Is Enabled?
> >
> > On 5/1/06, Robinson, Eric <eric.robinson@stripped> 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/mysql?unsub=1
> >
> >
>
> --
>
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
>
>
> __________________________________
> Webmail Intercol http://www.intercol.com.br
>
Thread
Fixing Databases When Replication Is Enabled?Eric Robinson1 May
  • Re: Fixing Databases When Replication Is Enabled?Kishore Jalleda1 May
    • Re: Fixing Databases When Replication Is Enabled?Atle Veka2 May
      • Re: Fixing Databases When Replication Is Enabled?Kishore Jalleda2 May
RE: Fixing Databases When Replication Is Enabled?Eric Robinson2 May
  • Re: Fixing Databases When Replication Is Enabled?Kishore Jalleda2 May
Re: Fixing Databases When Replication Is Enabled?Kishore Jalleda2 May
RE: Fixing Databases When Replication Is Enabled?Eric Robinson3 May
  • RE: Fixing Databases When Replication Is Enabled?Atle Veka4 May