mysql create copy database statments

create-db-statement.sql

SET @NewSchema := "www-staging-1";
SET @OldSchema := "www";
SELECT CONCAT("DROP TABLE IF EXISTS `", @NewSchema, "`.`", table_name, "`;\nCREATE TABLE `", @NewSchema, "`.`",table_name, "` LIKE `", TABLE_SCHEMA , "`.`", table_name, "`;\nINSERT INTO `",@NewSchema, "`.`", table_name, "` SELECT * FROM `", TABLE_SCHEMA , "`.`", table_name, "`;") 
AS `sql` FROM information_schema.TABLES WHERE TABLE_SCHEMA = @OldSchema AND TABLE_TYPE != "VIEW";