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; [email protected]
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: [email protected]
> 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: [email protected]
> > 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: [email protected]
> > 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]
