SQL file import - ERROR 2013 (HY000) at line 2732: Lost connection to MySQL server during query

[Илья Вайсер]

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?

[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.

--
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-d...@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.

[Илья Вайсер]

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+unsub...@googlegroups.com.

[Pia Chamberlain]

Are you following these instructions when you create the SQL dump file?

https://cloud.google.com/sql/docs/mysql/import-export/creating-mysqldump-csv

[Илья Вайсер]

Yes! But without success.

This help me - '--extended-insert=FALSE --order-by-primary --complete-insert' 

среда, 26 апреля 2017 г., 18:27:47 UTC+3 пользователь Pia Chamberlain написал: