Re: [google-cloud-sql-discuss] Re: How do you move a cloudsql instsance to a smaller disk?

Yes, we are aware the storage capacity cannot be decreased, hence the question.

Thanks for those steps. This is a production DB that cannot be taken offline, is there another step to do a replication? Sorry if I left that point out.

- Jake

On Monday, May 25, 2020 at 11:44:45 PM UTC-4, yananc wrote:

Hi Jacob,

As Sabyasachi has pointed out in the doc, once the instance is created, the storage capacity cannot be decreased. The best option is to create a new instance with the desired capacity and then copy all the data of the old instance into it. The copying process could include exporting data to a CSV file and importing the file to the newly created instance.

Hope it helps!

--
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/3905c389-79d9-428a-bcfd-d7eb28500ca0%40googlegroups.com.