Duplicate Database from template, useful for restore point

duplicate_database.sql

SELECT @tbl_template := 'vcerp_template', @tbl_target := 'vcerp';

SELECT 'SET FOREIGN_KEY_CHECKS=0;'
UNION
SELECT Concat('DROP TABLE IF EXISTS ', @tbl_target, '.', TABLE_NAME, ';')
FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema = @tbl_template
UNION
SELECT Concat('CREATE TABLE ', @tbl_target, '.', TABLE_NAME, ' LIKE ', @tbl_template, '.', TABLE_NAME, ';')
FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema = @tbl_template
UNION
SELECT Concat('INSERT INTO ', @tbl_target, '.', TABLE_NAME, ' SELECT * FROM ', @tbl_template, '.', TABLE_NAME, ';')
FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema = @tbl_template
UNION
SELECT 'SET FOREIGN_KEY_CHECKS=1;';