MySQL异常关闭时备份存储过程？

可以使用事件（Event）和脚本（Script）来实现。

步骤如下：

1.创建一个事件，每30分钟执行一次，并执行以下脚本（建议将Schema和备份目录改为自己的）：

DELIMITER $$
CREATE EVENT Backup_Procedures_Event
    ON SCHEDULE EVERY 30 MINUTE
    DO
      BEGIN
        SET @schema = 'your_schema_name';
        SET @backup_directory = '/backup/directory/';

        DECLARE done INT DEFAULT FALSE;
        DECLARE proc_name VARCHAR(255);
        DECLARE cur CURSOR FOR SELECT `name`
          FROM `mysql`.`proc`
          WHERE `specific_schema` = @schema;

        DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

        CREATE TEMPORARY TABLE IF NOT EXISTS tmp_procedures ( Name TEXT, Definer TEXT,
          Modified TIMESTAMP, Created TIMESTAMP,
          Security_type TEXT, Comment TEXT, character_set_client TEXT,
          collation_connection TEXT, Database_Collation text, body text );

        OPEN cur;
        get_procedures: LOOP
          FETCH cur INTO proc_name;
          IF done THEN
            LEAVE get_procedures;
          END IF;

          INSERT INTO tmp_procedures ( Name, Definer, Modified, Created, Security_type, Comment, character_set_client, collation_connection, Database_Collation, body ) SELECT `name`, `definer`, `modified`, `created`, `security_type`, `comment`, `character_set_client`, `collation_connection`, `Database_Collation`, `body` FROM `mysql`.`proc` WHERE `name` = proc_name AND `specific_schema` = @schema ;
        END LOOP;
        CLOSE cur;

        SET @proc_list = '';

        SELECT GROUP_CONCAT(Name) FROM tmp_procedures INTO @proc_list;

        SET @backup_filename = CONCAT(@backup_directory, 'Procedures_', @schema, '-', DATE_FORMAT(NOW(), '%Y-%m-%d_%H-%i-%s'), '.sql');

        SELECT CONCAT('mysqldump --no-tablespaces --routines --triggers --skip-add-drop-table --skip-lock-tables --no-create-info --no-data --skip-comments --default-character-set=utf8 -u root -p your_mysql