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` ;