importing database doesn't create views/functions/procedures -- how to programatically create them?

[Tim Holme]

When importing data into a Cloud MySQL, the documentation says that triggers, stored procedures, functions, and views must be recreated manually. What is a way to do create views/functions/procedures/events/triggers programatically (via script or program) so I don't have to do this literally manually for hundreds of views, procs, functions, etc?

[George (Cloud Platform Support)]

Hello Tim, 

As you rightly point out, documentation indicates you need to re-create triggers manually, that is: if you export and then import data. Depending on your use-case and practical needs, you might be able to rather replicate your data to another MySQL instance by setting up replication. This can be accomplished in practice from your Cloud SQL instance directly to a Cloud SQL instance, or using the external master feature as an intermediate step.

This discussion group is oriented more towards general opinions, trends, and issues of general nature touching App Engine and Cloud SQL. For coding and programming architecture, as well as exporting and importing MySQL data, you may be better served in dedicated forums such as stackoverflow, where experienced programmers are within reach and ready to help.