Re: Error importing MySQL dump that includes geometry

Could you provide us with a small dump file that fails?

-- Razvan ME

On Tue, Oct 22, 2013 at 4:25 AM, Alexander Bertram <alex@bedatadriven.com> wrote:

Hi, 

We have two Cloud SQL instances, one for production, one for testing. Periodically, we export a dump from production, and import it into testing so that the environments stay roughly in sync.

However, since we started storing geometry in our production instance, we can no longer import the dumps into the testing instance:

Failed to import gs://xxxxxxx/xxxxx-2013-10-21.gz: Invalid UTF8 line: INSERT INTO `adminentity` VALUES (272,69.9614562988281,74.8794311871666,35.4463539123535,38.4834261112114,NULL,'Badakhshan',NULL,1249,NULL,0,'\0\0\0\0 \0\0\0 \0\0\0 \0\0\0 \0\0\0u \0\0 ??fu?Q@M ? L?B@P}?M??Q@Ԋ ?Y?B@\?\rR=\??Q@?5? u?B@\0/0> ?Q@\0|S\???B@?|: $?Q@????\??B@?|?[c?Q@@\?BW??B@? \" ??Q@\?\?\? \??B@?\?\??ˑQ@@?\?]n?B@?$??ˑQ@{fG_n?B@ ?v???Q@?!+ _?B@?? ?m?Q@\r = ?B@\0\?\?cF?Q@@ +???B@`-\n (?Q@U?c\?a?B@`????Q@@ b}??B@\??.S ?Q@B\?R?9?B@@n3???Q@???\?}?B@\0\??\" ?Q@?\??=??B@W::? ?... An unknown problem occurred (ERROR_RDBMS)

The dump is fine; I can load it into a local MySQL instance on my development machine.

Any work arounds for this?

Thanks,

Alex

--
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/03a21c5d-ea74-49d7-9827-ebc7e0785f06%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
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/CA%2BUvTg1DO72vD2o4oqL0ei7sC%3D0eWsnv4Hxj5en64Hg7iHvn%3DA%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.