MySQL copy all views from one database to another in stored procedure
You need to call SHOW CREATE VIEW to get the view code.  However, that will have the database name in the code.  You would need to parse the output, replace that database name, then execute dynamic statements with PREPARE and EXECUTE.  

Stored procedures may be the most difficult way to manage this. For example, you can mysqldump can dump/load the views from one database to another in one line : https://stackoverflow.com/questions/1658204/backing-up-views-with-mysql-dump

Other tools like Flyway and Liquibase can help with schema management as well.