delimiter |

CREATE TRIGGER `feed_insert`
BEFORE INSERT ON `feeds`
FOR EACH ROW BEGIN
SET @alevel = (SELECT max(readinglist_feeds.acct_level)
FROM grazr_accounts.readinglist_feeds
WHERE grazr_accounts.readinglist_feeds.url_md5_fk = NEW.url_md5_fk);
IF @alevel IS NULL THEN SET NEW.acct_level = 0;
ELSE SET NEW.acct_level = @alevel;
END IF; END |

as dump has it:

/*!50003 SET @OLD_SQL_MODE=@@SQL_MODE*/;
DELIMITER ;;
/*!50003 SET SESSION SQL_MODE="" */;;
/*!50003 CREATE */ /*!50003 TRIGGER `feed_insert` BEFORE INSERT ON `feeds` FOR EACH ROW BEGIN 
SET @alevel = (SELECT max(readinglist_feeds.acct_level) 
FROM grazr_accounts.readinglist_feeds 
WHERE grazr_accounts.readinglist_feeds.url_md5_fk = NEW.url_md5_fk); 
IF @alevel IS NULL THEN SET NEW.acct_level = 0; 
ELSE SET NEW.acct_level = @alevel; 
END IF; END */;;

as it is replicated:

to the master, replicated to the slave
#071018 12:11:49 server id 1 end_log_pos 8177666 Query thread_id=13 exec_time=0 error_code=0
SET TIMESTAMP=1192723909;
CREATE DEFINER=`root`@`localhost` TRIGGER `feed_update` BEFORE UPDATE ON `feeds` FOR EACH ROW BEGIN 
SET @alevel = (SELECT max(grazr_accounts.readinglist_feeds.acct_level) 
FROM grazr_accounts.readinglist_feeds 
WHERE grazr_accounts.readinglist_feeds.url_md5_fk = NEW.url_md5_fk); 
IF @alevel IS NULL THEN SET NEW.acct_level = 0; 
ELSE SET NEW.acct_level = @alevel; 
END IF; END */;
# End of log file
ROLLBACK /* added by mysqlbinlog */;

the error:

 Error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*/' at line 5' on query. Default database: 'grazrserver'. Query: 'CREATE DEFINER=`root`@`localhost` TRIGGER `feed_insert` BEFORE INSERT ON `feeds` FOR EACH ROW BEGIN 
SET @alevel = (SELECT max(readinglist_feeds.acct_level) 
FROM grazr_accounts.readinglist_feeds 
WHERE grazr_accounts.readinglist_feeds.url_md5_fk = NEW.url_md5_fk); 
IF @alevel IS NULL THEN SET NEW.acct_level = 0; 
ELSE SET NEW.acct_level = @alevel; 
END IF; END */' |