Re: [google-cloud-sql-discuss] 2nd gen backups with mysqldump --routines --events possible?

Hello Rob,

As previously mentioned by Vadim, the 2nd Generation Cloud SQL export should include everything. This is valid when using the SQL Admin API as well. You won't need to use ExportContext.SqlExportOptions to include routines or events, if you wish to export them in back up. You can try this using Google APIs Explorer.

Sincerely,

On Thursday, May 19, 2016 at 2:56:20 PM UTC-4, Rob wrote:

Thanks, will give it a test.

It is possible to achieve the same with the SQLAdmin API Export? Does gen 2 via the admin API t now also to specify --routines --events ?

I ask only because ExportContext.SqlExportOptions does not seem to have any options other than Schema Only and the specific tables.

On Thursday, May 19, 2016 at 2:50:27 PM UTC-4, Vadim Berezniker wrote:

Second Generation backups should include everything, you should not have to change any settings.

Give it a try.

On Thu, May 19, 2016 at 11:46 AM Rob <rober...@parasql.com> wrote:

In first gen Cloud SQL it was not possible to specify backups with the equivalent of mysqldump --routines --events (triggers were backed up as that is the default).

Is it possible to specify these parameters for gen2 Cloud SQL? Could this even be made the default so everything is backed up?

Also, is this now possible at least via the CloudSQLAdmin API so i can run my own backups that include everything?

--

--
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/8e747c6a-3e39-42a6-b982-5eeff4ed8668%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.