Wednesday, October 24, 2018

[google-cloud-sql-discuss] Re: Understanding the behaviour of gcloud sql export

Any news on that?

Il giorno giovedì 18 ottobre 2018 15:08:45 UTC+2, Matteo Di Sabatino ha scritto:
Hello all,
I've got a Google Cloud SQL instance of second generation; for a purpose of mine, I decided to create a sort of replica machine by exporting data from it and importing to another instance.
Before begin I controlled the used disk space, that was 125GB and after I exported the database by running the command:

gcloud sql export sql MY_INSTANCE gs://MY_BACKET/2018-10-18/mysql/MY_DB.mysql.sql.gz --database=MY_DB

When it finished I imported that backup into the replica machine, and... surprise! The used disk space was 180GB!
How is it possibile? Why was the second instance 55GB bigger?
Thanks in advance for the response.

--
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/f808a5f8-a72e-4ffd-b6dc-273f5d257812%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment