On Tuesday 25 February 2003 16:36, Floyd Wellershaus wrote:
> Egor,
> I am sorry, my bad. I misrepresented the versions of mysql I am using. Must
> have been a typo.
> Here is what I am using.
>
> Master: Sparc Solaris 7 MySQL 4.0.9-gamma-log
> Slave: RedHat Linux 7.2 MySQL 4.0.8-gamma-log.
>
> Could you continue to help me with this ?
I tested on 4.0.10 ..
What replication options do you have in my.cnf?
Do you use any replicate-* options?
Could you provide a test case?
>
> -Original Message-
> From: Egor Egorov [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 25, 2003 8:28 AM
> To: [EMAIL PROTECTED]
> Subject: re: Replication problem (alter table fails)
>
> On Tuesday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote:
> > Coud you, please, give an advice to solve following problem:
> >
> > I've got two Mysql Servers:
> >
> > * Master: Sparc Solaris 8, MySQL 3.23.32
> > * Slave: RedHat Linux 7.2, MySQL 3.23.32
> >
> > Replication of data runs fine, all "insert into" and "delete from" made
> > on master successfully change the slave database. Creation and dropping
> > of the whole tables also work fine. But if I add or delete certain
> > column in any table on master DB (e.g. run ALTER TABLE commands), slave
> > ignores is and later on stops replication because it cannot replicate
> > the data appeared or changed on the master afterwards (because these
> > fields not exist on the slave).
> >
> > Is there any way to tell either Master or Slave to replicate ALTER TABLE
> > queries as well?
>
> Since 3.23.32 there were a lot of bug fixed related to the replication.
> Please, upgrade servers and test it again.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php