Re: [google-cloud-sql-discuss] SQL file import - ERROR 2013 (HY000) at line 2732: Lost connection to MySQL server during query

It does not depend on the size of the server. It is related to the dump format. A normal dump made with mysqldump does not work in Google Cloud SQL

пятница, 14 апреля 2017 г., 20:50:35 UTC+3 пользователь Vadim Berezniker написал:

It sounds like MySQL could be crashing during the import (perhaps running out of memory?)

Can you check Cloud Logging for your instance to see if there are logs from MySQL when this happens?

You could try using a larger instance during the import and then switch to a smaller instance when you're done.

On Fri, Apr 14, 2017 at 6:12 AM Илья Вайсер <il...@skorik.co> wrote:

I can not do data import. I import a sql file, 5 gb with 20 million records.

I get error ERROR 2013 (HY000) at line 2732: Lost connection to MySQL server during query

I try and through ip address, through GCS Bucket. Does not work.

How can this problem be solved?

--
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/4a254eff-949a-42ca-b84a-a4e0a5759bdb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/6f797fc7-90b0-49df-8dac-6e09d8174ca1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.