开源数据库Mysql_DBA运维实战 （备份与还原）

-- 创建备份数据库的存储过程
DELIMITER $$
CREATE PROCEDURE BackupDatabase(IN dbName VARCHAR(255), IN backupPath TEXT)
BEGIN
    SET @stmt = CONCAT('BACKUP TABLES TO `', backupPath, '`');
    PREPARE stmt FROM @stmt;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
END$$
DELIMITER ;

-- 调用存储过程进行备份
CALL BackupDatabase('my_database', '/path/to/backup/directory');

-- 创建还原数据库的存储过程
DELIMITER $$
CREATE PROCEDURE RestoreDatabase(IN dbName VARCHAR(255), IN backupPath TEXT)
BEGIN
    SET @stmt = CONCAT('RESTORE TABLES FROM `', backupPath, '`');
    PREPARE stmt FROM @stmt;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
END$$
DELIMITER ;

-- 调用存储过程进行还原
CALL RestoreDatabase('my_database', '/path/to/backup/directory');