Got it. Just in case I did the following to get the triggers: Ran this on the server that had the dB originally:
mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt events > events.sql I copied the "events.sql" from the old server to the new one. I put it in the Mysql bin directory to make things easier and then ran this on my new server: mysql -u <user> -p events < events.sql To check I ran the following query on my new server: SELECT `TRIGGER_SCHEMA` FROM information_schema.TRIGGERS; The result should show 'events'. Just to be safe I also ran (from mysql): use events; show triggers; -------------------- m2f -------------------- Read this topic online here: http://forums.zenoss.com/viewtopic.php?p=38972#38972 -------------------- m2f -------------------- _______________________________________________ zenoss-users mailing list [email protected] http://lists.zenoss.org/mailman/listinfo/zenoss-users
