Here[1] is the link to the doc in case you would like to know more about the other parameters available for this API
-- [1] https://cloud.google.com/sql/docs/mysql/admin-api/rest/v1beta4/instances/restoreBackup
On Wednesday, March 25, 2020 at 8:22:26 AM UTC-4, chen levi wrote:
On Wednesday, March 25, 2020 at 8:22:26 AM UTC-4, chen levi wrote:
yes you can , we do that and its way faster.its possible through Rest API.for example:curl -o /dev/null -w'%{http_code}' -X POST https://www.googleapis.com/sql/v1beta4/projects/${ -H "Authorization: Bearer ${TOKEN}"TARGET_PROJECT}/instances/${ SQL_TARGET_INSTANCE}/ restoreBackup -H 'Content-Type: application/json' -d '{"restoreBackupContext": {"backupRunId":"${SOURCE_BACKUP_ID}","project":"${ SOURCE_PROJECT}","instanceId": "${SQL_SOURCE_INSTANCE}"}}' where:TARGET_PROJECT = the project you want to restore backup toSQL_TARGET_INSTANCE = the sql instance you want to do restore onTOKEN = authentication tokenSOURCE_BACKUP_ID=the backup id from the source instance you want to use for the restoreSOURCE_PROJECT=the project of the sql instance which were backed upSQL_SOURCE_INSTANCE=the sql instance which were backed uphope that's clear enough.ChenOn Wed, Mar 25, 2020 at 5:08 AM abhishek singh <abhishek.singhdba@gmail.com> wrote:Hi,--Our Production Db is approx 1.3 TB and we do restore PROD to lower env using export/import. This is takes approx 22-26 hrs.Is there a way if i can restore a cloudsql managed backup across different projects ?ThanksAbhi
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/08330703-74e9-4bcf- 80cc-8060893fa998% 40googlegroups.com
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/ff0fafa7-c490-4896-847c-5ba5222a9451%40googlegroups.com.
No comments:
Post a Comment