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