Thursday, October 10, 2019

[google-cloud-sql-discuss] Re: importing database doesn't create views/functions/procedures -- how to programatically create them?

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. 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/714678b1-505d-4789-aec3-2182b2081858%40googlegroups.com.

No comments:

Post a Comment