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 ? Thanks, floyd -----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 --------------------------------------------------------------------- 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