first time sync code looks quite as expected (except from useless recreation of view, but thats another story):

-- -----------------------------------------------------
-- Placeholder table for view `my_other_sync_schema`.`view1`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `my_other_sync_schema`.`view1` (`id` INT);

-- -----------------------------------------------------
-- View `my_other_sync_schema`.`view1`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `my_other_sync_schema`.`view1`;
CREATE OR REPLACE  VIEW `my_other_sync_schema`.`view1` AS
select 0;

end of first sync code



second sync script (this time its a bit messy):

CREATE SCHEMA IF NOT EXISTS `my_other_sync_schema` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;

USE `my_other_sync_schema`;

CREATE  TABLE IF NOT EXISTS `my_other_sync_schema`.`table1` (
  `idtable1` INT(11) NOT NULL ,
  PRIMARY KEY (`idtable1`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1
COLLATE = latin1_swedish_ci;

DROP SCHEMA IF EXISTS `my_sync_schema` ;

-- -----------------------------------------------------
-- Placeholder table for view `my_other_sync_schema`.`view1`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `my_other_sync_schema`.`view1` (`id` INT);

-- -----------------------------------------------------
-- Placeholder table for view `my_sync_schema`.`view1`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `my_sync_schema`.`view1` (`id` INT);

-- -----------------------------------------------------
-- View `my_other_sync_schema`.`view1`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `my_other_sync_schema`.`view1`;
CREATE OR REPLACE  VIEW `my_other_sync_schema`.`view1` AS
select 0;

-- -----------------------------------------------------
-- View `my_sync_schema`.`view1`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `my_sync_schema`.`view1`;
DROP VIEW IF EXISTS `my_sync_schema`.`view1` ;