DELIMITER $$

DROP PROCEDURE IF EXISTS `sp_cleanup_trigger_ex` $$

CREATE PROCEDURE `sp_cleanup_trigger_ex`()
BEGIN
            INSERT INTO ex_tbl_trgr (SELECT * FROM ex_tbl_trgr_bkp);
            DELETE FROM ex_tbl_trgr_bkp;
            SELECT * FROM test.ex_tbl_trgr_bkp;
END $$

DELIMITER ;
demo