Error importing MySQL dump that includes geometry

[Alexander Bertram]

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

[Razvan Musaloiu-E.]

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

-- Razvan ME

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

[Alexander Bertram]

Can I send you a link to the dump in GCS privately? My address is al...@bedatadriven.com

Best,

Alex

On Tuesday, October 22, 2013 11:40:23 AM UTC-4, Razvan Musaloiu-E. wrote:

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

-- Razvan ME

On Tue, Oct 22, 2013 at 4:25 AM, Alexander Bertram <al...@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+unsub...@googlegroups.com.

[Razvan Musaloiu-E.]

Sure, I just contacted you off-the-list.

Thanks!

Razvan ME

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/ad6a7ef1-f207-4419-b934-616137c573ea%40googlegroups.com.